Blog
Notes on building developer tools, AI, and the occasional career tip.
Popular topics
Clear filtersMore topics (145)
topic PostgreSQLView all posts
Latest articles
Showing 1–2 of 2
deploymentJul 17, 20262 min read
Zero-Downtime Database Migrations: A Safe Deployment Playbook
Use expand-and-contract migrations, backfills, compatibility windows, observability, and rollback planning to change production schemas safely.
PostgreSQLJul 17, 20262 min read
PostgreSQL Indexes Explained: B-Tree, Composite, Partial, and GIN
Understand PostgreSQL indexes, when to use B-tree, composite, partial, and GIN indexes, and how to verify queries with EXPLAIN.