Use Flyway for DB Upgrades

NCEAS / metacat

Data repository software that helps researchers preserve, share, and discover data

https://knb.ecoinformatics.org/software/metacat

GNU General Public License v2.0

28 stars 13 forks source link

Use Flyway for DB Upgrades #1917

Open artntek opened 6 months ago

artntek commented 6 months ago

We require operators to have upgraded to Metacat v2.19 before installing the 3.0.0 release. Since we have broken backwards compatibility, now would be a great time to re-assess our database version management system, and maybe move to using a tool like Flyway to simplify future upgrades?

We have a "clean slate" right now. If we wait too long, however, there will be too many interim upgrades to incorporate, and our window of opportunity will have closed...

artntek commented 6 months ago

See Matt's simple example of using testcontainers and flyway for testing. README here