undefined | Better HN

0 pointsjolmg7y ago0 comments

Not all problems are obvious, though. You can have an app work 100%, your database be completely coherent, and then realize some of the data is missing.

It would be cool to not have to be so careful when committing migrations, needing to be absolutely sure that we're not screwing something up. This is similar to how one would be careful of changes done in source code before we learned how to use version control systems like git.

I can go completely wild with git, deleting random files, overwriting others with random junk, sharing them to my coworkers, etc. It would only take a few minutes to fix that.

0 comments

1 comments · 1 top-level

smt887y ago

This is OK for git because updates to a repo happen maybe 100 times a day at the most.

A production DB is changed potentially millions of times a day.

If you have this goal from the beginning, you can create an append-only database, but that's orthogonal to migrations.

To have "append-only" migrations is seemingly out of scope for mainstream database engines.

j / k navigate · click thread line to collapse