3 ms·
programming in time is hard (especially with migrations, because migrations take time) this feels too high-level -- different migration operations can afford
by awinter-py 4y ago
programming in time is hard
(especially with migrations, because migrations take time)
this feels too high-level -- different migration operations can afford different guarantees (esp in the multi-node case). In particular this doesn't talk about data migrations, where you might need to lock 2 tables + join them to generate a third. not all migrations are pure-sql either, they may include app code
my favorite article about this is benchling's https://benchling.engineering/move-fast-and-migrate-things-how-we-automated-migrations-in-postgres-d60aba0fc3d4 https://benchling.engineering/move-fast-and-migrate-things-h... because it talks about pre + post deploy migrations