Hi Marc, > We (EXASOL), plan to develop a database integration for JOOQ.
Great news and thanks for your interest! > What is required to appear on your list of planned integrations. That's the easiest part. Done: https://github.com/jOOQ/jOOQ/issues/1985 > Also it would be very interesting for us to know how much development time > would be required for such an integration for a database system similar to > oracle. Unlike with other database abstraction frameworks, things are a bit more tricky to integrate in jOOQ, depending on how far you want to go. This is due to the fact that jOOQ takes into account subtle SQL dialect differences for advanced SQL features and quite a few functions. There are several tasks with rough estimates: - 2-3d for the first-time integration (i.e. understanding jOOQ's integration tests and getting things to run) - 1-2d for a "standard" jooq-meta integration (exotic data types, UDT support, SP's may take a bit longer) - 2-3d to fix integration tests (and the API documentation, with all the @Support annotations) > As i understood you have to implement an extension of AbstractDatabase and > related classes in jooq-meta and adjust required tests. Yes, that's a rough summary. An option is also to skip the jooq-meta part and implement this ticket here - if your JDBC driver's DatabaseMetaData can deliver the required meta information: https://github.com/jOOQ/jOOQ/issues/1636 > Is there any Evaluation process for contributed db integrations? My requirements are: - I have to be able to easily run and execute the integration tests on a free developer licensed database instance (this includes the JDBC driver) - I need access to extensive SQL documentation. Free 1st level support is a plus, too. - If that instance doesn't further cripple my poor laptop (hello Oracle, DB2, and 12 other DBs!) that's a plus, too :-) Then, there are maintenance considerations. Adding new features (e.g. new function support, new SQL feature support) becomes more and more complex, as the number of supported databases grows. Do you see your potential contribution as a long-term affiliation with jOOQ, or as a one-time contribution? I'm also open to more formal affiliations, such as the one recently offered by CUBRID: http://www.cubrid.org/blog/cubrid-life/first-batch-of-donations-to-opensource-projects-from-cubrid-affiliates-program/ It included a one-time donation, as well as free promotion for jOOQ on the CUBRID blog and website. Should you be interested, feel free to contact me through a P.M. N.B: it would probably be interesting to see your database on this page: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems Best Regards, Lukas
