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.
webcoderspeed.com
5 articles
Database branching enables PR-per-database workflows. Learn Neon and PlanetScale branching, safe migration testing, and CI automation for schema changes.
Test migrations for backwards compatibility, forwards compatibility, rollback safety, and data integrity. Catch schema-code mismatches before deployment.
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.
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.
Master the expand/contract pattern, concurrent index creation, and rollback-safe migrations to deploy schema changes without user impact.