Everything you care about in one place
Follow feeds: blogs, news, RSS and more. An effortless way to read and digest content of your choice.
Get Feederblog.jooq.org
Java, SQL and jOOQ.
Get the latest updates from Java, SQL and jOOQ. directly as they happen.
Follow now 118 followers
Latest posts
Last updated 8 months ago
Emulating SQL FILTER with Oracle JSON Aggregate Functions
8 months ago
A cool standard SQL:2003 feature is the aggregate FILTER clause, which is...
Getting Top 1 Values Per Group in Oracle
11 months ago
I’ve blogged about generic ways of getting top 1 or top n...
How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ
almost 2 years ago
Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is...
How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQ
almost 2 years ago
Occasionally, you want to write a SQL query and fetch a hierarchy...
3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0
almost 2 years ago
DiagnosticsListener improvements A lot of additional diagnostics have been added, including the...
How to use jOOQ’s Converters with UNION Operations
almost 2 years ago
jOOQ 3.15 introduced the concept of an ad-hoc converter, a converter that...
How to Write a Derived Table in jOOQ
almost 2 years ago
One of the more frequent questions about jOOQ is how to write...
The Performance Impact of SQL’s FILTER Clause
almost 2 years ago
I’ve found an interesting question on Twitter, recently. Is there any performance...
Emulating Window Functions in MySQL 5.7
about 2 years ago
One of MySQL 8’s biggest improvements is the support of window functions...
Why You Should Execute jOOQ Queries With jOOQ
about 2 years ago
Previously on this blog, I’ve written a post explaining why you should...
jOOQ’s R2DBC LoggingConnection to log all SQL statements
about 2 years ago
jOOQ already has a LoggingConnection (see also the manual), which acts as...