Hi Bear, A lot is required :-)
In the early days of jOOQ, adding support for a new database was rather simple - maybe 2-3 days' worth of effort for me, or perhaps 1 week for a contributor. Times have changed. jOOQ 3.11 will add support for 4 new databases: Aurora MySQL & PostgreSQL Edition, SQL Data Warehouse, and Teradata. The latter have been quite a hassle to get right and took quite a while to implement, both with still quite a few "known limitations" (e.g. no stored procedure support in Teradata yet). There's a lot of work getting the (closed source) integration tests to run, keeping track of all the hundreds of little edge cases that they contain in the meantime. Which is a good thing. This means that jOOQ has matured a lot and it's become more quite difficult to write a query that breaks jOOQ (e.g. some funky edge case where a correlated subquery uses offset / limit, but omits order by, along with some nested union operations) Having said so, I don't think it's reasonable for a contributor to add support for additional databases at this point, let alone for us to accept a PR and maintain it. Unlike JPA, for example, jOOQ really supports (almost) the entirety of the SQL language and has to emulate all sorts of features in all sorts of dialects. Here are some examples: https://blog.jooq.org/2018/03/13/top-10-sql-dialect-emulations-implemented-in-jooq It has become very difficult to get this right, and there are only few databases left where the market is big enough to justify the effort of adding an integration (Teradata was one of them) Hope this helps, Lukas 2018-06-04 16:57 GMT+02:00 Bear Giles <[email protected]>: > Out of curiousity what is required for support of new databases? I know > the database-specific packages are pretty thin but I would imagine there's > quite a bit of testing distributed throughout the package hierarchy. > > Bear > > -- > 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.
