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.
1575 articles
Database branching enables PR-per-database workflows. Learn Neon and PlanetScale branching, safe migration testing, and CI automation for schema changes.
Master connection pooling with PgBouncer and pgpool-II. Learn transaction vs session mode, pool sizing math, Prisma connection pooling, serverless connection pooling, and monitoring.
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.
Master Postgres query optimization using EXPLAIN ANALYZE, covering index types, query rewriting, and plan analysis for production databases.