Tag: Database
-
How to connect to MySQL remotely with SSH PuTTY Tunnels: A step-by-step guide
Posted on April 6, 2023, Level beginner Resource Length long
MySQL is a popular relational database management system to organize and store data. Depending on your specific use cases and preferences, you can connect to a MySQL Server through a command-line interface, using GUI tools,such as dbForge Studio for MySQL, programming languages or via web-based interfaces such as phpMyAdmin. By Julia Evans.
Tags infosec cloud devops database servers
-
How to orchestrate an ETL Data Pipeline with Apache Airflow
Posted on March 10, 2023, Level intermediate Resource Length medium
Data Orchestration involves using different tools and technologies together to extract, transform, and load (ETL) data from multiple sources into a central repository. By Aviator Ifeanyichukwu.
Tags apache database nosql data-science python big-data
-
Write reusable code for AppSync JavaScript resolvers
Posted on March 6, 2023, Level beginner Resource Length short
Learn how to share code between AppSync JS resolvers. AWS AppSync is a fully managed service that allows developers to build scalable and performant GraphQL APIs. It is also serverless, meaning that you will only pay for what you use. By Benoît Bouré.
Tags nodejs javascript aws frontend apis database
-
Build your own command-line replica with GTID aware mariadb binlog
Posted on February 24, 2023, Level advanced Resource Length medium
This blog post begins a three part series to create and customize your own asynchronous MariaDB replication client. With the release of MariaDB Community Server 10.8.1, the mariadb-binlog command line utility now supports both 1) filtering events by GTID ranges, and 2) validating a binary log's ordering of Global Transaction IDentifiers (GTIDs). By Brandon Nesterenko.
Tags app-development mysql database performance
-
Storing OpenAI embeddings in Postgres with pgvector
Posted on February 8, 2023, Level beginner Resource Length medium
A new PostgreSQL extension is now available in Supabase: pgvector, an open-source vector similarity search. By Greg Richardson.
Tags cloud machine-learning devops bots database
-
2023 state of databases for serverless & edge
Posted on February 2, 2023, Level intermediate Resource Length medium
There's been massive innovation in the database and backend space for developers building applications with serverless and edge compute. There are new tools, companies, and even programming models that simplify how developers store data. By Lee Robinson.
Tags serverless cio cloud database iot devops
-
Using Apache Kafka to process 1 trillion inter-service messages
Posted on January 27, 2023, Level intermediate Resource Length long
Cloudflare has been using Kafka in production since 2014. We have come a long way since then, and currently run 14 distinct Kafka clusters, across multiple data centers, with roughly 330 nodes. Between them, over a trillion messages have been processed over the last eight years. By Matt Boyle.
Tags event-driven apache apis app-development database
-
Entity to DTO – how-to
Posted on December 20, 2022, Level intermediate Resource Length medium
DTO is probably the most straightforward pattern in object-oriented programming. What could be the motives for using DTOs in our applications? By Andrey Belyaev.
Tags database oop web-development app-development java
-
Faster MQTT data collection with InfluxDB
Posted on November 11, 2022, Level intermediate Resource Length long
Native MQTT eliminates the need to write custom code, orchestrate additional technology layers or incorporate additional hosting services. By By Jason Myers.
Tags database app-development web-development devops
-
Azure PostgreSQL Flexible Server exciting new backup and restore enhancements
Posted on October 17, 2022, Level beginner Resource Length medium
Backup and restore are key pillars for business continuity and disaster recovery offerings for Azure Database for PostgreSQL Flexible Server. We're excited to announce new features including Fast Restore, Geo Restore and Custom Restore Points to allow you more fine-grained control on your DR plan to achieve the RPO and RTO objectives. In this post we'll share an overview of each of these new features. By Varun Dhawan.
Tags database azure mysql devops
-
Postgres: Better message queue than Kafka?
Posted on October 13, 2022, Level intermediate Resource Length long
Today author is going to talk about why they made the unconventional decision to build thier logging system on top of Postgres, what worked well, what didn't work well, and how they did it. By Pete Hunt.
Tags apache mysql app-development database messaging
-
Reducing graph complexity using Go and transitive reduction
Posted on September 19, 2022, Level intermediate Resource Length medium
Directed acyclic graphs (DAGs) serve a wide variety of applications in computer science, biology, sociology, and other fields that involve complex networks. While these graphs often contain a large number of edges, some of the edges might be redundant, making computations unnecessarily expensive and the graph structure harder to understand. By Dominik Braun.
Tags apis app-development performance golang database