Good question. I suspect that http://www.gitora.com might be a tool for PL/SQL to do exactly that... Perhaps you're luckier with this question on reddit.com/r/java, reddit.com/r/SQL, or reddit.com/r/PostgreSQL, or maybe on Quora.com.
Should you ask that question on other platforms, I'd be very curious to know - feel free to link to those questions from here... Cheers, Lukas 2015-06-18 15:18 GMT+02:00 Ben Hood <[email protected]>: > Hi all, > > This is not a question about JOOQ per se, but I was wondering what > tools the JOOQ community uses to manage their DDL. > > Until now, I've been using Flyway to auto-migrate the DDL when the app > gets restarted. In some instance I also invoke Flyway from the command > line. > > The whole process has been smooth for a long time. > > But the one thing I Flyway doesn't appear to have a story for is how > to squash a patch series down to a newline baseline and produce the > baseline as a consolidated DDL artifact. > > So now that I've gone beyond 100 patches for an app, some of my procs > have undergone multiple tweaks, so their verbatim definition is > present in multiple files in source control, which the latest patch > having the current definition. What I would prefer is to treat my > procs as I would treat any other source file, i.e. the current working > version is the current version and history is in it Git, not in a > series of patch files. > > Is anybody aware of tool that can periodically re-baseline the DDL and > produce a squashed DDL artifact that you can put into source control > in place of the previous patch series? > > Cheers, > > Ben > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
