SQL
-
Software Development
It’s the Little Things: The PL/SQL NULL Statement, and why Every Language Should have One
Syntax is one of those topics. One of those emotional topics that lead to very very very important discussions. I…
Read More » -
Enterprise Java
How to Avoid the Dreaded Dead Lock when Pessimistic Locking – And some Awesome Java 8 Usage!
Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to…
Read More » -
Software Development
How to use SQL PIVOT to Compare Two Tables in Your Database
This can happen ever so easily. You adapt a table by adding a new column: …
Read More » -
Software Development
How to Extract a Date Part in SQL
The Modern SQL Twitter account (by Markus Winand) published a hint about how to extract a date part in SQL:…
Read More » -
Software Development
10 SQL Articles Everyone Must Read
We’ve been blogging about Java and SQL for a while now, on the jOOQ blog. Over the years, while researching…
Read More » -
Enterprise Java
How to fix optimistic locking race conditions with pessimistic locking
Recap In my previous post, I explained the benefits of using explicit optimistic locking. As we then discovered, there’s a…
Read More » -
Software Development
Still Using Windows 3.1? So why stick to SQL-92?
We’ve been blogging a lot about the merits of modern SQL on the jOOQ blog. Specifically, window functions are one…
Read More » -
Software Development
Declarative SQL Mode Pitfall
As we know a view object definition supports three SQL modes. There are normal, declarative and expert modes. In this post…
Read More » -
Core Java
How to Translate SQL GROUP BY and Aggregations to Java 8
I couldn’t resist. I have read this question by Hugo Prudente on Stack Overflow. And I knew there had to…
Read More »
