SQL
-
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 » -
Enterprise Java
Tracing SQL statements in JBoss AS 7 using a custom logging handler
Using an ORM to abstract from your specific database and to let it create and issue all the SQL statements…
Read More » -
Enterprise Java
Stop Trying to Emulate SQL OFFSET Pagination with Your In-House DB Framework!
I’m pretty sure you’ve gotten it wrong in numerous ways, so far. And you probably won’t get it right any…
Read More » -
Software Development
Java 8 Friday: JavaScript goes SQL with Nashorn and jOOQ
At Data Geekery, we love Java. And as we’re really into jOOQ’s fluent API and query DSL, we’re absolutely thrilled…
Read More »