Charlie is a former teacher, tech journalist, and filmmaker who’s now combined those three professions into writing and making videos about databases and application development (and occasionally messing with NLP and Python to create weird things in his spare time).
SQL performance best practices: performance tuning to speed up your database
Learn how to optimize your relational database for better performance, including tuning queries, adding indexes, adjusting your schema, and more!
Charlie Custer
October 23, 2023
Product
High CPU usage in Postgres: how to detect it, and how to fix it
High CPU usage can bring your database – and with it, your application – grinding to a halt. This is, unfortunately, a fairly common problem. But it also can be a relatively easy fix. Let’s take a look at how to check CPU usage in Postgres, and how to troubleshoot for some of the most common causes of high CPU usage.
Charlie Custer
October 16, 2023
Product
What is a distributed database and how do they work?
The cloud is, by definition, a distributed system. Distributed application architecture is mainstream in the world of software — you wouldn’t build any other way. For more than a decade, though, the database has lagged behind. The architecture of traditional relational databases frequently conflicts with the architectural needs of modern cloud applications: horizontal scale, elasticity, and microservices.
Charlie Custer
October 9, 2023