Database Migrations

This is a comprehensive guide, packed with best practices and expert insights about proper deployment, to master the art of seamless database migrations.

Database Migrations vadim kravcenko development long-read newsletter Database Migrations 01 October 2023 · 43,114 views · Updated 04 April 2026 I’d rank database migrations right next to dentist appointments and moving apartments on the “things engineers postpone until absolutely necessary” list. One wrong step and suddenly the whole team treats every ALTER TABLE like a live grenade. On paper the problem looks harmless: change a column, push some code, done. In reality the edge-cases multiply the moment you have real users and real data. (I’ve lost count of how many Friday evenin

related reading

• Everything I know about good system designseangoedecke.com
• The startup's Postgres survival guidehatchet.run
• How I Dropped Our Production Database and Now Pay 10% More for AWSalexeyondata.substack.com
• Evolutionary Database Designmartinfowler.com
• The Ultimate Database Scaling Cheatsheet: Strategies for Optimizing Performance and Scalabilitydzone.com
• Nine ways to shoot yourself in the foot with PostgreSQLphilbooth.me
• Deploying Django • Buttondownbuttondown.com
• A mental model for Prisma Migrate | Prisma Documentationprisma.io
• Mistakes engineers make in large established codebasesseangoedecke.com
• An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com
• The Beginner's Guide to Databasestechnically.substack.com
• Databases in 2024: A Year in Review // Blog // Andy Pavlo - Carnegie Mellon Universitycs.cmu.edu