Automated database migrations

[jojule]

Integrate and automate Flywheel to Control Center to make database upgrades easy with application version upgrades.

[Legioth]

I assume we're talking about https://github.com/flyway/flyway and not any of the unrelated products named Flywheel?

I assume this is for the application's own database tables and not for data stored by Control Center?

I assume Flyway would mainly be used directly from the application itself since e.g. the migration files should be under version control. This also means that the database would be automatically updated just by deploying a new version of the application. How would Control Center add value on top of that?

[heruan]

Yes, it's Flyway 🙂 And yes, this is for the app's database that is created by Control Center that will provide a Flyway bean and configure it to connect to the database and apply migrations read from the app's resources.

[Legioth]

That sounds like a relatively small feature at least from a technical perspective? Basically just taking the database configuration functionality that we would have for other cases also and also using it in one more place.

Nothing wrong with that in itself. I'm just somehow expecting that there would be more to it when this is defined as a separate ticket rather than just another case in the #7339.