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 Feeder

blog.jooq.org

Java, SQL and jOOQ.

Get the latest updates from Java, SQL and jOOQ. directly as they happen.

Follow now 119 followers

Latest posts

Last updated 4 days ago

When SQL Meets Lambda Expressions

4 days ago

ARRAY types are a part of the ISO/IEC 9075 SQL standard. The...

Think About SQL MERGE in Terms of a RIGHT JOIN

18 days ago

RIGHT JOIN is an esoteric feature in the SQL language, and hardly...

Resisting the Urge to Document Everything Everywhere

about 1 month ago

Every product manager knows this situation: This is such a common pattern...

Emulating SQL FILTER with Oracle JSON Aggregate Functions

10 months ago

A cool standard SQL:2003 feature is the aggregate FILTER clause, which is...

Getting Top 1 Values Per Group in Oracle

about 1 year 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

about 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

about 2 years ago

DiagnosticsListener improvements A lot of additional diagnostics have been added, including the...

How to use jOOQ’s Converters with UNION Operations

about 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

about 2 years ago

One of the more frequent questions about jOOQ is how to write...

The Performance Impact of SQL’s FILTER Clause

about 2 years ago

I’ve found an interesting question on Twitter, recently. Is there any performance...