database9 min read
Database Branching — Git-Like Workflows for Your Schema
Database branching enables PR-per-database workflows. Learn Neon and PlanetScale branching, safe migration testing, and CI automation for schema changes.
Read →
Migrations
5 articles
database10 min read
Testing Database Migrations — Catching Breaking Changes Before They Reach Production
Test migrations for backwards compatibility, forwards compatibility, rollback safety, and data integrity. Catch schema-code mismatches before deployment.
Read →
postgresql9 min read
Database Migrations in Production — Zero-Downtime Schema Changes at Scale
Master zero-downtime schema changes: expand/contract pattern, PostgreSQL 11+ instant column additions, gh-ost and pg_repack for online schema changes, testing with production subsets, backwards-compatible deployments.
Read →
backend6 min read
Migration Locking the Table — The ALTER TABLE That Took Down Production
You deploy a migration that runs ALTER TABLE on a 40-million row table. PostgreSQL rewrites the entire table. Your app is stuck waiting for the lock. Users see 503s for 8 minutes. Schema changes on large tables require a completely different approach.
Read →
postgres10 min read
Zero-Downtime Database Migrations — Schema Changes Without Locking Your Tables
Master the expand/contract pattern, concurrent index creation, and rollback-safe migrations to deploy schema changes without user impact.
Read →