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 109 followers
Latest posts
Last updated about 2 months ago
Getting Top 1 Values Per Group in Oracle
about 2 months ago
I’ve blogged about generic ways of getting top 1 or top n...
An Efficient Way to Check for Existence of Multiple Values in SQL
2 months ago
In a previous blog post, we’ve advertised the use of SQL EXISTS...
A Hidden Benefit of Implicit Joins: Join Elimination
3 months ago
One of jOOQ’s key features so far has always been to render...
jOOQ 3.19’s new Explicit and Implicit to-many path joins
4 months ago
jOOQ 3.19 finally delivers on a set of features that will greatly...
Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error
4 months ago
In MySQL, you cannot do this: The UPDATE statement will raise an...
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
4 months ago
New Dialects It’s been a few releases since we’ve added support for...
Maven Coordinates of the most popular JDBC Drivers
4 months ago
Do you need to add a JDBC driver to your application, and...
To DAO or not to DAO
4 months ago
jOOQ’s DAO API is one of jOOQ’s most controversial features. When it...
JDBC Connection URLs of the Most Popular RDBMS
5 months ago
Need to connect to your RDBMS with JDBC and don’t have the...
How to Generate Package Private Code with jOOQ’s Code Generator
10 months ago
Java’s package private visibility is an underrated feature. When you omit any...
How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ
12 months 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 1 year ago
Occasionally, you want to write a SQL query and fetch a hierarchy...