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 121 followers
Latest posts
Last updated about 2 months ago
Simplifying ANTI JOIN with jOOQ Syntax
about 2 months ago
ANTI JOIN is a very useful operator from relational algebra. Regrettably, only...
Why JOIN USING Can Lead to Errors in SQL
about 2 months ago
Some SQL operators are as esoteric as they’re powerful. One of the...
Managing Sensitive Data in jOOQ 3.21+ Logs
3 months ago
One of jOOQ’s most popular feature is the out-of-the-box debug logging experience...
Consider using JSON arrays instead of JSON objects for serialisation
11 months ago
When implementing the awesome MULTISET operator in jOOQ, its implementation mostly relied...
When SQL Meets Lambda Expressions
about 1 year ago
ARRAY types are a part of the ISO/IEC 9075 SQL standard. The...
Think About SQL MERGE in Terms of a RIGHT JOIN
over 1 year ago
RIGHT JOIN is an esoteric feature in the SQL language, and hardly...
Resisting the Urge to Document Everything Everywhere
over 1 year ago
Every product manager knows this situation: This is such a common pattern...
jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more
over 1 year ago
New dialects: jOOQ 3.20 ships with 2 new experimental dialects: ClickHouse is...
Emulating SQL FILTER with Oracle JSON Aggregate Functions
about 2 years ago
A cool standard SQL:2003 feature is the aggregate FILTER clause, which is...
Getting Top 1 Values Per Group in Oracle
over 2 years 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
about 3 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
over 3 years ago
Occasionally, you want to write a SQL query and fetch a hierarchy...