blog.jooq.orgadded August 2026
Java, SQL and jOOQ.by lukaseder8 Mar 2023
DiagnosticsListener improvements A lot of additional diagnostics have been added, including the automated detection of pattern replacements, helping you lint your SQL queries irrespective of...
Java, SQL and jOOQ.by lukaseder2 Mar 2023
jOOQ 3.15 introduced the concept of an ad-hoc converter, a converter that is applied “ad-hoc” to a single query.
Java, SQL and jOOQ.by lukaseder24 Feb 2023
One of the more frequent questions about jOOQ is how to write a derived table (or a CTE). The jOOQ manual shows a simple example of a derived table: In SQL: SELECT nested.* FROM ( SELECT AUTHOR_ID...
Java, SQL and jOOQ.by lukaseder6 Feb 2023
I’ve found an interesting question on Twitter, recently. Is there any performance impact of using FILTER in SQL (PostgreSQL, specifically), or is it just syntax sugar for a CASE expression in an...
Java, SQL and jOOQ.by lukaseder20 Jan 2023
One of MySQL 8’s biggest improvements is the support of window functions. As I always said in conferences, there’s SQL before window functions and SQL after window functions.
Java, SQL and jOOQ.by lukaseder8 Dec 2022
A frequently encountered doubt people have when using jOOQ is to decide when a “complex” query should be written using jOOQ API vs. when it should be implemented using native SQL.
Java, SQL and jOOQ.by lukaseder4 Nov 2022
The standard SQL WITH clause has been tremendously helpful in structuring SQL queries. Instead of nesting everything in unreadable derived tables like this: SELECT actor_id, name, COUNT(*) FROM (...
Java, SQL and jOOQ.by lukaseder21 Oct 2022
Using jOOQ’s code generator to call stored procedures is a popular reason to use jOOQ. For example, when you have a procedure like the following Oracle PL/SQL procedure: CREATE OR REPLACE PROCEDURE...
Java, SQL and jOOQ.by lukaseder13 Sept 2022
Starting with jOOQ 3.11, type safe implicit JOIN have been made available, and they’ve been enhanced to be supported also in DML statements in jOOQ 3.17.
Java, SQL and jOOQ.by lukaseder6 Sept 2022
For new users working with jOOQ for the first time, the number of types in the jOOQ API can be overwhelming.
Java, SQL and jOOQ.by lukaseder1 Sept 2022
No need for expensive Tableau subscriptions. Ditch Microsoft Excel. Just use native PostgreSQL to quickly visualise your data! Here’s an idea I had for a while.
Java, SQL and jOOQ.by lukaseder30 Aug 2022
I’ve just stumbled upon this great post by Vlad Mihalcea, titled The Best Way to Fetch a Spring Data JPA DTO Projection. It got some nice traction on reddit, too.
Java, SQL and jOOQ.by lukaseder30 Aug 2022
Starting with jOOQ 3.16 and #12601, there may be a compilation error with a message like this in your jOOQ generated code: [ERROR] …/DefaultCatalog.java:[53,73] cannot find symbol [ERROR] symbol...
Java, SQL and jOOQ.by lukaseder25 Aug 2022
Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is generated implicitly because of the presence of a path expression.
Java, SQL and jOOQ.by lukaseder24 Aug 2022
Starting with jOOQ 3.17, the Condition type extends the Field<Boolean> type. Because, that’s what the SQL standard thinks it is, in sorts: <boolean value expression> ::= <predicate> The exact...
Java, SQL and jOOQ.by lukaseder23 Aug 2022
Probably the hardest thing to standardise in SQL is RETURNING data from DML statements. In this article, we’ll look at various ways of doing that with jOOQ, in many of jOOQ’s supported dialects...
Java, SQL and jOOQ.by lukaseder22 Aug 2022
When you write stored procedures and functions in your database, you want to ensure their correctness, just like with your Java code. In Java, this is done with unit tests, typically with JUnit.
Java, SQL and jOOQ.by lukaseder19 Aug 2022
The H2 database is an immensely popular in-memory database product mostly used by Java developers for testing.
Java, SQL and jOOQ.by lukaseder28 Jul 2022
jOOQ is mainly known for its powerful type safe, embedded, dynamic SQL capabilities that are made available through code generation.
Java, SQL and jOOQ.by lukaseder30 Jun 2022
One of jOOQ 3.17‘s coolest new features are client side computed columns. jOOQ 3.16 already added support for server side computed columns, which many of you appreciate for various reasons.
top 1%