Different To-Many Nesting Algorithms’ Efficiency Compared – Java, SQL and jOOQ.
It has been a while since jOOQ 3.15 was released, introducing its revolutionary standard SQL MULTISET emulation feature. In this …
lukaseder
Filtering a SQL Nested Collection by a Value using Java, SQL, and jOOQ
I came across an interesting question on Stack Overflow about using jOOQ’s MULTISET operator to nest a collection and then …
Java, SQL, and jOOQ Embrace 3.17.0 Version: Computed Columns, Audit Columns, Pattern Matching, Reactive Transactions, and Kotlin Coroutine Compatibility.
This release continues the work from previous releases around more sophisticated SQL transformation capabilities, including: Client side computed columns for …
Java, SQL, and jOOQ: Enhance Your Views with Virtual Client-Side Computed Columns in jOOQ 3.17
One of jOOQ 3.17‘s coolest new features are client side computed columns. jOOQ 3.16 already added support for server side …
Exploring the Power of jOOQ: Java, SQL, and More
jOOQ is mainly known for its powerful type safe, embedded, dynamic SQL capabilities that are made available through code generation. …
Leveraging H2 as a Test Database with jOOQ in Java and SQL
The H2 database is an immensely popular in-memory database product mostly used by Java developers for testing. If you check …
Integration Testing Stored Procedures with jOOQ: A Comprehensive Guide
When you write stored procedures and functions in your database, you want to ensure their correctness, just like with your …
Returning Data from SQL DML: A Comprehensive Approach with Java, SQL, and jOOQ
Probably the most challenging aspect of standardizing SQL is retrieving data from DML statements. In this article, we explore different …
“Java, SQL, and jOOQ as Fields for Defining a Condition”
Starting with jOOQ 3.17, the Condition type extends the Field<Boolean> type. Because, that’s what the SQL standard thinks it is, …
Support for Implicit Join Now Available in jOOQ 3.17 for DML Operations – Enhancing Java, SQL, and jOOQ
Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is …