SQL
-
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 » -
Software Development
An entity modelling strategy for scaling optimistic locking
Introduction Application-level repeatable reads are suitable for preventing lost updates in web conversations. Enabling entity-level optimistic locking is fairly easy.…
Read More » -
Core Java
Don’t Miss out on Writing Java 8 SQL One-Liners with jOOλ or jOOQ
More and more people are catching up with the latest update to our platform by adopting functional programming also for…
Read More » -
Core Java
Asynchronous SQL Execution with jOOQ and Java 8’s CompletableFuture
Reactive programming is the new buzzword, which essentially just means asynchronous programming or messaging. Fact is that functional syntax greatly…
Read More »