4 ms·
Well JOOQ certainly influnced the query DSL API which we use. JOOQ is certainly very mature and can express much more complex SQL statements. JOOQs API is more
by scottysinclair 11y ago
Well JOOQ certainly influnced the query DSL API which we use. JOOQ is certainly very mature and can express much more complex SQL statements.
JOOQs API is more database centric and I was looking for a framework with a similar query DSL but which produced more Pojo like objects.
One of the most interesting things about BarleyDB is that it can be used (if so desired) without any compilation. You can import a schema from an XML file and the use the meta model to query and to save data.
BarleyDB also provides:
optimistic locking,
query batching,
access-control checks - via plugin,
auditing - via plugin,
insert / update statement reordering for increased batch sizes.
Scott
- lukaseder 11y ago> You can import a schema from an XML file and the use the meta model to query and to save data. You can do the same with jOOQ, just in case. > optimistic locking, query batching, Also supported in jOOQ > access-control checks - via plugin, auditing - via plugin Also possible in jOOQ, although, perhaps not out of the box. How does this work in BarleyDB? > insert / update statement reordering for increased batch sizes. A quick win that appears to be a very bad idea in general, e.g. in the presence of triggers.