We went with Flyway as an independent migration framework (our app has a mix of legacy Hibernate and Jooq), and we run the migrations as a separate process outside of the application itself.
The lack of rollbacks was an initial concern - eventually, we found the fact that migrations would rollback via transaction isolation on error (SQL or otherwise) mitigated A LOT of that. There are still issues of migrations altering, or removing data that can't be rolled back - or more, prevent rolling back software versions - but thru judicious planning, and having backups if needed we’ve not yet really had a scenario where that's been an issue. *touch wood*. Mark -- "Great artists are extremely selfish and arrogant things" — Steven Wilson, Porcupine Tree On 19 May 2024 at 3:05:18 AM, 'Bernd Huber' via jOOQ User Group < [email protected]> wrote: > i like to use the following frameworks for database evolutions (migrations) > - liquibase > - flyway > - play framework evolutions > > but they all have some drawbacks: > > - liquibase: > - complicated rollbacks and tedious XML/SQL files that are very > maintenance intensive > - only transaction safe within each changeset (no full transactional > safety for all changesets at once) > > flyway: > - no rollbacks (without commercial) > > play framework evolutions: > - no good support outside of the play framework world. > > --- > > i somewhere read that (i dont know exactly where), that jooq also plans to > provide an own database evolutions framework with jooq. > > Wanted to ask if there is something in the making... :) > > It could be nice to write typesafe Database Evolutions with Jooq, make > rollbacks, convert them to SQL if needed outside of the framework, etc. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/d636129e-df4f-4d2f-a518-dc31c2ea2013n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/d636129e-df4f-4d2f-a518-dc31c2ea2013n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CALYGm1wPM2C0De899tRniy4MCF1ANUu339T1hv85UtOMpX9wUw%40mail.gmail.com.
