News for hackers. Stuff that matters.
Re:Things to know about databases by beckingz on Monday June 27, 2022 @02:26PM (#31898610)
I heard about Flywaydb today, which appears to be an open source database versioning tool. Pretty interesting! https://flywaydb.org/
Re:Things to know about databases by vladsanchez on Monday June 27, 2022 @02:34PM (#31898727)
Pretty open-source, until you need "premium" features like "rollback" :/ (headwall)
Re:Things to know about databases by krab on Tuesday June 28, 2022 @05:20PM (#31913160)
At multiple companies I worked for, they concluded the backwards schema changes are not worth the risks and testing overhead. It's usually quick enough to issue a hotfix.

With rollback, you always risk losing data - remember, you're doing it when something didn't go as you expected. What are the odds, the rollback will break something further?

These were all Postgres shops, so schema changes within a transaction - that can be rolled back safely if it fails in the middle.

Re:Things to know about databases by beckingz on Tuesday June 28, 2022 @10:59AM (#31908577)
Oh that's unfortunate. No thank you.