Skip to main content
Database migrations critical

Database Migrations

Database migration patterns covering version control, rollback strategies, zero-downtime deployments, and the expand-contract pattern for production safety.

Difficulty
advanced
Read time
1 min read
Version
v1.0.0
Confidence
established
Last updated

Quick Reference

Database Migrations: Use expand-contract for zero-downtime (add column → backfill → remove old). Always backwards compatible. Separate deploy from release. Test in staging first. Backup before production migrations. Use transactions for atomicity. Version control migration files with code.

Use When

  • Deploying schema changes to production
  • Managing database versions
  • Zero-downtime deployments
  • Rolling back failed migrations

Skip When

  • Development-only databases
  • Greenfield projects without production data

Database Migrations

Database migration patterns covering version control, rollback strategies, zero-downtime deployments, and the expand-contract pattern for production safety.

Tags

database migrations prisma alembic zero-downtime

Discussion