I have recently stumbled upon your very nice-looking tool in search for a Java database source control and migration tool, as this is a frequently requested feature for jOOQ. jOOQ is a database abstraction library built on top of JDBC, that allows for type-safe SQL construction and execution using its fluent API. It features many advanced and vendor-specific SQL concepts, such as UDT’s / UDF’s, recursive queries, nested selects, ref cursors, etc, and a code-generator generating source code from a database schema. Read more on the jOOQ home page:
The supported set of databases is similar to that of Liquibase, so I thought a cooperation might be interesting for all of us…? Liquibase might be useful to jOOQ to maintain its integration test schemata, whereas jOOQ might be useful to Liquibase to navigate database meta data… A commonly supported and documented integration might be a nice success-story for both tools. E.g.
- Maintain and increment a DB schema with Liquibase
- Run the jOOQ source code generator to make the upgraded schema available to the client application.