4 ms·
Reading further > Endorse-ish: Schema migration by Diff Well that explains it... What a terrible approach to migrations for data integrity.
by f549abd0 3y ago
Reading further
> Endorse-ish: Schema migration by Diff
Well that explains it... What a terrible approach to migrations for data integrity.
- cloogshicer 3y agoGenuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?
- jspdown 3y agoIncremental forward-only migrations (non-state based). Then, for the How and When, it mostly depends of your constraints and sizes. There's no silver bullet, it's hard, it require constant thinking, it's a slow and often multi step process. I never saw a successful fully automated one-way-of-doing process.
- from-nibly 3y agoAre you talking about the mechanics? Like more than just run a migration script on boot?
- jamescontrol 3y agoCan you explain? Having a tool to detect changes and create a migration doesn’t sound bad? In a nutshell thats how django migrations work as well, which works really well.