SQL
-
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 » -
Enterprise Java
Leaky Abstractions, or How to Bind Oracle DATE Correctly with Hibernate
We’ve recently published an article about how to bind the Oracle DATE type correctly in SQL / JDBC, and jOOQ.…
Read More » -
Software Development
A True SQL Gem You Didn’t Know Yet: The EVERY() Aggregate Function
We’ve just added support for the EVERY() aggregate function (#1391) to jOOQ, and would like to take the opportunity of…
Read More » -
Software Development
Do You Really Understand SQL’s GROUP BY and HAVING clauses?
There are some things in SQL that we simply take for granted without thinking about them properly. One of these…
Read More » -
Software Development
The downside of version-less optimistic locking
Introduction In my previous post I demonstrated how you can scale optimistic locking through write-concerns splitting. Version-less optimistic locking is…
Read More » -
Software Development
Don’t Miss out on Awesome SQL Power with FIRST_VALUE(), LAST_VALUE(), LEAD(), and LAG()
If you’re using a commercial database or PostgreSQL / Firebird / CUBRID, you will be able to take advantage of…
Read More » -
Software Development
Painless Access from Java to PL/SQL Procedures with jOOQ
PL/SQL is one of those things. Most people try to stay clear of it. Few people really love it. I…
Read More » -
Software Development
Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?
When writing DDL in SQL, you can specify a couple of constraints on columns, like NOT NULL or DEFAULT constraints.…
Read More »
