Hacker News .hnnew | past | comments | ask | show | jobs | submitlogin

Are those all things you've actually done? Or are you making a list of "potential database migration scenarios" like I described above?

As a datapoint, I've been a backend guy for coming up on 25 years now, and not only have I never needed to roll back a database migration, I'm not aware of that ever having needed to be done anywhere, even anecdotally. It just never happens in the reality we live in.

Yet all migration tools support it, require reverse migration scripts, etc. And you listed it in your "must have" list.



These are features I actually use liquibase for. That's why I know about them.

About rollbacks: yes, they are not always useful and you can think of ways to avoid them. But these days when you can rollback a docker application upgrade with a few commands/clicks, this way you can also roll back the DB changes. Not all the changes require this, but there are many ways a schema upgrade can go. Datapoint: changing stored procedures/functions that should match the calling application's version. Yes, not everybody uses logic in the DB, but sometimes you need that performance.


merging of branches with migration files, which means you can't just use "30, 31, 32, ... etc" is definitely something people do, all the time.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: