A practical guide to running database schema changes against a live production database without downtime — the expand/contract pattern, rename and backfill strategies, shadow tables for rewrites, lock-aware migrations, and tooling that makes it safe.
Databases & Storage
-
Database Migrations Without Downtime: Expand/Contract, Shadow Tables, and Safe Deploys -
PostgreSQL for Developers: Indexes, EXPLAIN ANALYZE, JSONB, and Tuning for Real Workloads A practical deep-dive into PostgreSQL for developers — understanding indexes and when to use them, reading EXPLAIN ANALYZE output, using JSONB for flexible schemas, and tuning the key configuration knobs that matter for real workloads.
-
SQLite in Production: When It's the Right Choice, WAL Mode, Backups, and Litestream Replication SQLite is more capable in production than most developers realize. This guide covers when to choose it over Postgres, WAL mode for concurrent reads and writes, proper backup strategies, and continuous replication with Litestream.