SQL
-
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 » -
Software Development
Awesome SQL Trick: Constraints on Views
CHECK constraints are already pretty great when you want to sanitize your data. But there are some limitations to CHECK…
Read More » -
Software Development
A Wonderful SQL Feature: Quantified Comparison Predicates (ANY, ALL)
Have you ever wondered about the use-case behind SQL’s ANY (also: SOME) and ALL keywords? You have probably not yet…
Read More » -
Software Development
All You Ever Need to Know About Recursive SQL
Oracle SYNONYMs are a great feature. You can implement all sorts of backwards-compatibility tweaks simply by creating SYNONYMs in your…
Read More » -
Software Development
SQL Tip of the Day: Be Wary of SELECT COUNT(*)
Recently, I’ve encountered this sort of query all over the place at a customer site: …
Read More » -
Software Development
Are You Using SQL PIVOT Yet? You Should!
Every once in a while, we run into these rare SQL issues where we’d like to do something that seems…
Read More »
