Database Branching — Development Workflows With Neon, PlanetScale, and Branch-Per-PR
Use database branching to test migrations safely. Branch per PR, mask PII, and integrate with CI/CD for rapid iteration.
webcoderspeed.com
1276 articles
Use database branching to test migrations safely. Branch per PR, mask PII, and integrate with CI/CD for rapid iteration.
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.