3.17.0 Release with Computed Columns, Audit Columns, Pattern Matching, Reactive Transactions and Kotlin Coroutine Support
Java, SQL and jOOQ.by lukaseder·22 Jun 2022
This release contiues the work from previous releases around more sophisticated SQL transformation capabilities, including: - Client side computed columns for both read and write operations - Audit...
How to Filter a SQL Nested Collection by a Value
Java, SQL and jOOQ.by lukaseder·10 Jun 2022
I stumbled upon a very interesting question on Stack Overflow about how to use jOOQ’s MULTISET operator to nest a collection, and then filter the result by whether that nested collection contains a...
The Performance of Various To-Many Nesting Algorithms
Java, SQL and jOOQ.by lukaseder·9 Jun 2022
It’s been a while since jOOQ 3.15 has been released with its revolutionary standard SQL MULTISET emulation feature.
Changing SELECT .. FROM Into FROM .. SELECT Does Not “Fix” SQL
Java, SQL and jOOQ.by lukaseder·31 May 2022
Every now and then, I see folks lament the SQL syntax’s peculiar disconnect between - the lexical order of operations (SELECT .. FROM ) - the logical order of operations (FROM ..
The Many Different Ways to Fetch Data in jOOQ
Java, SQL and jOOQ.by lukaseder·19 May 2022
The jOOQ API is all about convenience, and as such, an important operation (the most important one?) like fetch() must come with convenience, too.
Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries
Java, SQL and jOOQ.by lukaseder·11 May 2022
An interesting hint by Vladimir Sitnikov has made me think about a new benchmark for jOOQ: The benchmark should check whether single row queries should have a JDBC Statement.setFetchSize(1) call...
How to Typesafely Map a Nested SQL Collection into a Nested Java Map with jOOQ
Java, SQL and jOOQ.by lukaseder·9 May 2022
A really cool, recent question on Stack Overflow was about how to map a nested collection into a Java Map with jOOQ.
Your filters hide everything on this page. Adjust them in preferences.