SQL
-
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 » -
Desktop Java
Transform Your SQL Data into Charts Using jOOQ and JavaFX
In the recent past, we’ve shown how Java 8 and functional programming will bring a new perspective to Java developers…
Read More » -
Software Development
How to Emulate the MEDIAN() Aggregate Function Using Inverse Distribution Functions
Some databases are awesome enough to implement the MEDIAN() aggregate function. Remember that the MEDIAN() is sligthly different from (and…
Read More »