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.