Please turn JavaScript on
Java, SQL and jOOQ. icon

Java, SQL and jOOQ.

Get updates from Java, SQL and jOOQ. via email, on your phone or read them on follow.it on your own custom news page.

You can filter the news from Java, SQL and jOOQ. that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.

See the latest news from Java, SQL and jOOQ. below.

Site title: Java, SQL and jOOQ. – Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.05 / day

Message History

ANTI JOIN is a very useful operator from relational algebra. Regrettably, only few dialects support it in terms of SQL syntax, as we’ve written earlier. In jOOQ, you can write it as follows: If your RDBMS supports this natively (e.g. ClickHouse, Databricks), then it is rendered as such. Otherwise, jOOQ will translate this to: But …

Read full story
Some SQL operators are as esoteric as they’re powerful. One of the oldest operator that you’ve likely hardly ever used in real world applications is NATURAL JOIN which is the default in relational algebra. We’ve covered a funky use-case for NATURAL JOIN earlier on this blog. The main reason why it’s not very useful is …

Read full story
When implementing the awesome MULTISET operator in jOOQ, its implementation mostly relied on SQL/JSON support of various RDBMS. In short, while standard SQL supports nested collections via ARRAY or MULTISET operators like this: This is poorly supported in most RDBMS, so jOOQ emulates it using SQL/JSON as follows (or similar): Wait a second. A JSON …

Read full story