Comment by f549abd0

2 years ago

Reading further

> Endorse-ish: Schema migration by Diff

Well that explains it... What a terrible approach to migrations for data integrity.

4 comments

f549abd0

Reply
jamescontrol  2 years ago

Can 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.

cloogshicer  2 years ago

Genuinely curious (I don't have much experiences with DBs), how is schema migration done 'properly' these days?

  • jspdown  2 years ago

    Incremental 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.