Database migrations without downtime are a superpower. Here's the playbook that's survived dozens of...
Database migrations without downtime are a superpower. Here's the playbook that's survived dozens of schema changes in production.
The core idea
Never change schema and code at the same time. Split every migration into phases where the old code and new code can both run against the same schema.
Adding a column
Phase 1: Add the column as nullable. Deploy.
Database Migration Strategies That Actually Work in Production Database migrations are the...
Database Migrations: Managing Schema Changes as Version-Controlled Code A practical guide...
Database migrations have a reputation for going wrong at the worst possible moment. Omitted rollback...
I've written before about why we run SQLite in production for HelperX, and about multi-tenant...
Adding a required column to a table sounds like the simplest task in the world. Then you try it on a...
It's the most boring migration there is. Add a column, backfill it, done. Instant on your laptop....
