Consider using JSON arrays instead of JSON objects for serialisation rss-bridge 2025-08-11T12:43:10+00:00 +0 replies

When SQL Meets Lambda Expressions rss-bridge 2025-03-27T13:04:44+00:00 +0 replies

Think About SQL MERGE in Terms of a RIGHT JOIN rss-bridge 2025-03-13T14:45:53+00:00 +0 replies

Resisting the Urge to Document Everything Everywhere rss-bridge 2025-02-28T10:39:07+00:00 +0 replies

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 rss-bridge 2025-02-20T10:27:54+00:00 +0 replies

Emulating SQL FILTER with Oracle JSON Aggregate Functions rss-bridge 2024-06-03T12:17:41+00:00 +0 replies

Getting Top 1 Values Per Group in Oracle rss-bridge 2024-03-01T09:55:41+00:00 +0 replies

An Efficient Way to Check for Existence of Multiple Values in SQL rss-bridge 2024-02-16T14:16:45+00:00 +0 replies

A Hidden Benefit of Implicit Joins: Join Elimination rss-bridge 2024-01-10T14:19:00+00:00 +0 replies

jOOQ 3.19’s new Explicit and Implicit to-many path joins rss-bridge 2023-12-28T14:35:14+00:00 +0 replies

Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error rss-bridge 2023-12-20T14:20:29+00:00 +0 replies

jOOQ 3.19.0 Released with DuckDB, Trino, Oracle 23c support, join path improvements, an official gradle plugin, commercial maven repositories, policies, UDT paths, trigger meta data, hierarchies, and much more rss-bridge 2023-12-15T16:30:41+00:00 +0 replies

Maven Coordinates of the most popular JDBC Drivers rss-bridge 2023-12-13T11:25:44+00:00 +0 replies

To DAO or not to DAO rss-bridge 2023-12-06T13:41:52+00:00 +0 replies

JDBC Connection URLs of the Most Popular RDBMS rss-bridge 2023-12-01T11:12:59+00:00 +0 replies

How to Generate Package Private Code with jOOQ’s Code Generator rss-bridge 2023-06-28T15:54:18+00:00 +0 replies

How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ rss-bridge 2023-04-25T12:16:30+00:00 +0 replies

How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQ rss-bridge 2023-03-24T15:45:28+00:00 +0 replies

3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 rss-bridge 2023-03-08T16:34:56+00:00 +0 replies

How to use jOOQ’s Converters with UNION Operations rss-bridge 2023-03-02T11:18:17+00:00 +0 replies

How to Write a Derived Table in jOOQ rss-bridge 2023-02-24T09:18:48+00:00 +0 replies

The Performance Impact of SQL’s FILTER Clause rss-bridge 2023-02-06T07:51:38+00:00 +0 replies

Emulating Window Functions in MySQL 5.7 rss-bridge 2023-01-20T11:07:00+00:00 +0 replies

Why You Should Execute jOOQ Queries With jOOQ rss-bridge 2023-01-18T11:46:25+00:00 +0 replies

jOOQ’s R2DBC LoggingConnection to log all SQL statements rss-bridge 2023-01-17T10:12:05+00:00 +0 replies

When to Use jOOQ and When to Use Native SQL rss-bridge 2022-12-08T13:53:02+00:00 +0 replies

LATERAL is Your Friend to Create Local Column Variables in SQL rss-bridge 2022-11-04T08:56:17+00:00 +0 replies

Calling Procedures with Default Parameters using JDBC or jOOQ rss-bridge 2022-10-21T14:35:39+00:00 +0 replies

Using jOOQ’s Implicit Join From Within the JOIN .. ON Clause rss-bridge 2022-09-13T07:29:59+00:00 +0 replies

A Brief Overview over the Most Common jOOQ Types rss-bridge 2022-09-06T12:30:37+00:00 +0 replies

How to Plot an ASCII Bar Chart with SQL rss-bridge 2022-09-01T08:25:29+00:00 +0 replies

The Second Best Way to Fetch a Spring Data JPA DTO Projection rss-bridge 2022-08-30T14:48:44+00:00 +0 replies

Cannot resolve symbol ‘VERSION_3_17’ in jOOQ generated code rss-bridge 2022-08-30T06:56:20+00:00 +0 replies

jOOQ 3.17 Supports Implicit Join also in DML rss-bridge 2022-08-25T08:07:00+00:00 +0 replies

A Condition is a Field rss-bridge 2022-08-24T09:09:11+00:00 +0 replies

The Many Ways to Return Data From SQL DML rss-bridge 2022-08-23T15:02:04+00:00 +0 replies

How to Integration Test Stored Procedures with jOOQ rss-bridge 2022-08-22T12:36:00+00:00 +0 replies

Using H2 as a Test Database Product with jOOQ rss-bridge 2022-08-19T07:25:43+00:00 +0 replies

The Best Way to Call Stored Procedures from Java: With jOOQ rss-bridge 2022-07-28T13:11:59+00:00 +0 replies

Create Dynamic Views with jOOQ 3.17’s new Virtual Client Side Computed Columns rss-bridge 2022-06-30T14:46:35+00:00 +0 replies

3.17.0 Release with Computed Columns, Audit Columns, Pattern Matching, Reactive Transactions and Kotlin Coroutine Support rss-bridge 2022-06-22T15:15:05+00:00 +0 replies

How to Filter a SQL Nested Collection by a Value rss-bridge 2022-06-10T14:32:38+00:00 +0 replies

The Performance of Various To-Many Nesting Algorithms rss-bridge 2022-06-09T10:15:50+00:00 +0 replies

Changing SELECT .. FROM Into FROM .. SELECT Does Not “Fix” SQL rss-bridge 2022-05-31T08:39:55+00:00 +0 replies

The Many Different Ways to Fetch Data in jOOQ rss-bridge 2022-05-19T07:29:09+00:00 +0 replies

Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries rss-bridge 2022-05-11T08:55:41+00:00 +0 replies

How to Typesafely Map a Nested SQL Collection into a Nested Java Map with jOOQ rss-bridge 2022-05-09T10:06:51+00:00 +0 replies

A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL rss-bridge 2022-05-04T07:18:48+00:00 +0 replies

Nested Transactions in jOOQ rss-bridge 2022-04-28T15:30:06+00:00 +0 replies

How to Fetch Sequence Values with jOOQ rss-bridge 2022-03-01T13:08:00+00:00 +0 replies