SQL
-
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 » -
Software Development
Yet Another 10 Common Mistakes Java Developers Make When Writing SQL (You Won’t BELIEVE the Last One)
(Sorry for that click-bait heading. Couldn’t resist!) We’re on a mission. To teach you SQL. But mostly, we want to…
Read More » -
Software Development
Time to break free from the SQL-92 mindset
Are you stuck in the 90s? If you are only using the SQL-92 language reference, then you are overlooking so…
Read More » -
Software Development
The Index You’ve Added is Useless. Why?
Recently, at the office: Bob: I’ve looked into that slow query you’ve told me about yesterday, Alice. I’ve added the…
Read More » -
Software Development
How to Implement Sort Indirection in SQL
I’ve recently stumbled upon this interesting Stack Overflow question, where the user essentially wanted to ensure that resulting records are…
Read More » -
Core Java
Three-State Booleans in Java
Every now and then, I miss SQL’s three-valued BOOLEAN semantics in Java. In SQL, we have: TRUE FALSE UNKNOWN (also…
Read More » -
Software Development
NoSQL? No, SQL! – How to Calculate Running Totals
If anything at all, our jOOQ talks at various JUGs and conferences have revealed mostly one thing: Java developers don’t…
Read More » -
Software Development
How can I do This? – With SQL of Course!
Haven’t we all been wondering: How can I do this? I have these data in Excel and I want to…
Read More »
