SQL
-
Software Development
How SQL GROUP BY Should Have Been Designed – Like Neo4j’s Implicit GROUP BY
In the recent past, we’ve explained the syntactic implications of the SQL GROUP BY clause. If you haven’t already, you…
Read More » -
Enterprise Java
jOOQ Tuesdays: Vlad Mihalcea Gives Deep Insight into SQL and Hibernate
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month…
Read More » -
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 »
