Bootstrapping SQL databases for local and production setup

A practical walkthrough of how I manage SQL databases across dev and prod - from local container setups to CI/CD-powered migrations in the cloud. Code and examples are available here: bootstrapping-databases Intro When working with databases, it’s easy to fall into the trap of taking shortcuts - a quick container here, a few clicks in the AWS console there, and before you know it, you’re running production off an unversioned schema with the master user....

April 18, 2025 · 11 min · 2150 words · Theo "Bob" Massard

Tracking Row Level changes in PostgreSQL

Ownerships and modification dates often have a huge role in troubleshooting or understanding how applications work. Making last change metadata available can be a game changer in case of bug hunting or to understand how data behaves without digging through logs for hours. Let’s dive in a way of automating this “last update” tracking at the row level in Postgresql. Code is available at github.com/tbobm/postgresql-row-level-changes Automatically Tracking Row-Level Changes in PostgreSQL Managing changes to database records is a crucial part of maintaining data integrity and transparency in a system....

November 4, 2024 · 5 min · 1028 words · Theo "Bob" Massard