10 AWS Services that use SQL
When it comes to selecting the right database tool on AWS, the options can seem daunting. This guide will help you find your way.
2 months ago
Architecture
Postgres Connection Pooling and Proxies
Connection pooling, implementing it in Postgres, and how proxies fit in.
3 months ago
Choose the Right Model: Comparing Relational, Document, and Graph Databases
There are 3 major types of database models in use today. Learn about their differences and what applications they are good for.
6 months ago
Set Up MySQL 8 Replication with Linux Nodes
This guide will show you how to set up a 2 node replication server by configuring mysqld.
7 months ago
Why You Need To Backup Your Postgres Database and How To Do It
This article will demonstrate why database backups are crucial and how to back up your PostgreSQL database using pg_dump and pg_dumpall.
7 months ago
Nostalgia: What Happened to MyISAM?
Before InnoDB replaced it, MyISAM was one of the flagship storage engines available in MySQL. However, as time moved on, InnoDB replaced it as MySQL engineers found it to be a better choice.
9 months ago
Architecting Database Systems for the Microservices World
This article explores the evolution of microservices, their benefits and tradeoffs, and how databases should be structured around this new paradigm.
10 months ago
How to Set Up PostgreSQL High Availability with Patroni
Create a Postgres High Availability cluster with Patroni, etcd, and HAProxy on Ubuntu
10 months ago
Utilizing BigQuery as a Data Warehouse in a Distributed Application
When it comes to storing data, a robust and reliable solution to store data from various sources is the most important factor. In this article, we will see how to centralize data collection in a distributed application with Google BigQuery.
a year ago
