It's funny how some customers explicitly forbid using their logos on the jOOQ website, only for their engineers to tell just about anyone that they're using jOOQ at every occasion as well as talk to me about it in public 😅

There are joins that can only return rows from the left table Semi join => rows matching the right (IN or EXISTS) Anti join => rows not matching the right (NOT IN or NOT EXISTS) @lukaseder.bsky.social makes the case these should have their own #SQL syntax

Good news for PostgreSQL / pgjdbc users! There's work on binary UDT serialisation support via JDBC's SQLData API: github.com/pgjdbc/pgjdb... I'm adding experimental support for it in jOOQ: github.com/jOOQ/jOOQ/is... This should speed up UDT support quite a bit!

Hey @vladmihalcea.bsky.social, do you have the source code for these benchmarks somewhere for reproduction? I want to check if the jOOQ single query case has some mapping related bottleneck (e.g. allocation) within jOOQ: www.youtube.com/watch?v=nrNY...

Just had a support case today where the solution was to use jOOQ's powerful anti join convenience: ctx .select(AUTHOR.ID) .from(AUTHOR) .where(notExists(AUTHOR .book())) That's something I often wish SQL had natively blog.jooq.org/simplifying-...

SQL's JOIN .. USING seems to be a really cool syntax to save time, but regrettably, it's not a good idea to use it in production queries: blog.jooq.org/why-join-usi...

Classic

That looks like a fun session at @springio.net, wish I could be there :) 2026.springio.net/sessions/the...

A small but cool new feature of jOOQ 3.21's commercial editions: redacted columns, which do not expose their contents to DEBUG logs and other text output: blog.jooq.org/managing-sen...

After 18 years of maknig jOOQ, I'm still discovering such subtle differences where trying to insert a long string into a VARCHAR(n) column will raise an error if too long, but casting it to VARCHAR(n) will silently truncate it, e.g. in PostgreSQL: github.com/jOOQ/jOOQ/is... SQL is full of surprises

Just work with Java, folks, because, you know... 😏

How many time zone bugs go undetected if developers are located in London (UTC)? and not some time zone where the offset produces tons of problems already at dev time?

Oh no, here goes my free time

👾New on CyberJAR: A jOOQ Deep Dive ORM makes you suffer? Let's explore a SQL-first approach to persistence with jOOQ! This video covers type-safe SQL in Java for complex queries, CTE pipelines, nested result mappings, and dynamic query composition: www.youtube.com/watch?v=J47i...

Man, I just love my job. Interesting problems, happy customers, the joys of a great product market fit, flexible work hours (and not too many anymore). Thanks to all you jOOQ customers out there, making this dream-come-true possible!

Huh, interesting. It appears that PostgreSQL decided to go against the SQL standard here ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor> GR 4) b) i) says that empty tables should produce a JSON array with no elements (intuitively), not NULL. Why this behaviour in PG?

A View Is Not a Table: It Is a Controlled Integration Contract martinelli.ch/a-view-is-no...

Why Vaadin and jOOQ Are a Natural Fit for AI Driven Development martinelli.ch/why-vaadin-a...

Could be worse

LEAD(x) IGNORE NULLS OVER(ORDER BY n) Not very often, but when I need IGNORE NULLS, then I really miss it in PostgreSQL. modern-sql.com/caniuse/T616

The love/hate Hibernate topic hasn't lost it's relevance: the video sparkled a nice conversation on Reddit www.reddit.com/r/java/comme... What is your stance, friends? What do you prefer, ORM or JDBC/jOOQ?

This little API change allows for omitting some syntactic ceremony when working with EXISTS subqueries in jOOQ: github.com/jOOQ/jOOQ/is... E.g. you can now write: ctx. select(AUTHOR, exists(AUTHOR. book())) .from(AUTHOR) Instead of spelling out the complete correlated subquery.

One Query, Complete Object Graphs: Nested DTOs with jOOQ MULTISET martinelli.ch/one-query-co... by @martinelli.ch

“There are only two tragedies in life: one is not getting what one wants, and the other is getting it.” ― Oscar Wilde

My disappointment when SQL dialects choose this kind of name resolution strategy is very very deep

Man, I've been doing jOOQ for 15+ years now and I still write flaky tests due to missing ORDER BY clauses, and thus non-deterministic result set ordering 🫠

🇫🇷 jOOQ et le code legacy: 1/ https://shodo.io/jooq-et-le-code-legacy-1/ 2/ https://shodo.io/jooq-et-le-code-legacy-2/

Huh, has Oracle stopped publishing commits to the MySQL github repo? github.com/mysql/mysql-... github.com/mysql/mysql-...

🤯

Fun discovery, the standard SQL aggregate FILTER clause can be emulated with Google SQL's (BigQuery, Spanner) aggregate HAVING clause. This is especially useful when the default emulation using CASE doesn't work as NULL values should be preserved, e.g. in ARRAY_AGG() github.com/jOOQ/jOOQ/is...

Due to the Liquibase license change to the FSL, I've deprecated the LiquibaseDatabase, which is used for jOOQ code generation: github.com/jOOQ/jOOQ/is... Going forward, the recommended way to integrate Liquibase with jOOQ is by using testcontainers: blog.jooq.org/using-testco...

Some RDBMS have a weird understanding of case sensitivity in identifiers. Here's Google Spanner. - Quoting doesn't affect case sensitivity - DDL identifiers are case sensitive (though "duplicates" are not allowed) - DML identifiers are not case sensitive

gvenzl/oracle-free images are now available for #Oracle AI #Database 23.26.0!

This is... something: aws.amazon.com/de/blogs/big...

What do you folks think? Is this a good email footer? “The bureaucracy is expanding to meet the needs of the expanding bureaucracy.” ― Oscar Wilde

What on earth is AWS Clean Rooms SQL?? docs.aws.amazon.com/clean-rooms/...

Recursive generics are so tricky to grasp because they rely on grasping recursive generics.

Did we as an industry just collectively agree that "bouncy castle" is a very secure sounding term for a "security provider," yes? downloads.bouncycastle.org/java/docs/bc...

So, we now have: - BigQuery - ClickHouse - Databricks - DuckDB - Exasol - H2 - Snowflake - Teradata (the inventor, I think?) And now also: - Oracle! I'm assuming MySQL will follow suit, soon? PostgreSQL, when!?

Apply the Oct 2025 Release Update and Oracle Database 23ai becomes Oracle AI Database 26ai This adds the QUALIFY clause QUALIFY filters window functions after grouping Like the HAVING clause does for aggregate functions SELECT ... FROM ... QUALIFY fn OVER ( ... ) > ...

Well, that's something! The Derby Database is unsupported ("retired"). It has been around forever, I'm kinda feeling nostalgic about this... issues.apache.org/jira/browse/...

Q: Does your RDBMS use zero-based or one-based indexing? A: Yes

Are you making any of these common #SQL mistakes? Forgetting about NULL Processing data in Java memory Using JDBC Pagination to paginate large results Using aggregate instead of window functions @lukaseder.bsky.social explains what to do instead & lists 7 more

Thanks to a sponsor, the upcoming jOOQ 3.21 will have support for the Google Spanner dialect! github.com/jOOQ/jOOQ/is...

This always struck me as one of the biggest cognitive dissonances in programming style guides

Found an actual German word de.wikipedia.org/wiki/Lieferk...

Writing a CREATE TABLE statement in SQL be like

Whaat, a Java record component cannot be deprecated by Javadoc, only by annotation? That looks like a bug in javac to me, no? The JLS doesn't mention Javadoc explicitly: docs.oracle.com/javase/specs...

Back to SQL: How jOOQ puts you in the driver's seat with @martinelli.ch www.youtube.com/watch?v=QZ8S...

Every time I write new integration test for a jOOQ bug, I also write an integration test for an RDBMS bug