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

Every. Time. Why. Does. It. Complain. 😬 Oooh, that's why. 😅

This sounds like my recent experience with OSGi tutorials

"5 HoUrS oF TrIaL AnD ErRoR SaVeS YoU 10 MiNuTeS oF ReAdInG ThE DoCuMeNtAtIoN." The documentation:

Debugging jOOQ bugs be like

PostgreSQL. Why do you betray me? Where are my nulls??

SQL can be so subtle, at times

I mean, jOOQ isn't like that but many are, I think?

It's so hard to be opinionated in programming

Another cool improvement of jOOQ 3.21: Implement a custom Formatter to tell jOOQ how to embed your user defined type (e.g. hstore, etc.) in a SQL/JSON or SQL/XML document in order to serialise it with MULTISET queries: github.com/jOOQ/jOOQ/is...

How to fetch multiple to-many relationships with jOOQ MULTISET vladmihalcea.com/fetch-multip...

My inbox before and after the CI/CD server noticed the short github outage.

Coming to jOOQ 3.21, emulation of named parameters in stored function calls, when the underlying RDBMS doesn't support named parameters, but supports defaulted params, such as Firebird: github.com/jOOQ/jOOQ/is...

Is it really happening today??? 🥹

Hmm, I wish the JDK had a few additional methods in Collections, similar to synchronizedMap(), but with a ReadWriteLock instead of a mutex. Two read operations shouldn't block each other.

See you at the JUGS summer party! www.jug.ch/html/events/...