SQL
-
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 » -
Software Development
A Better Query Language than SQL
Leland Richardson, Founder of Tech.Pro has recently published a very interesting article about BQL, his visions of a better query…
Read More » -
Software Development
Please, Run That Calculation in Your RDBMS
There’s one thing that you can do terribly wrong when working with RDBMS. And that thing is not running your…
Read More » -
Enterprise Java
Java 8 Friday Goodies: SQL ResultSet Streams
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
JOOQ Facts: SQL functions made easy
The JDBC API has always been cumbersome and error-prone and I’ve never been too fond of using it. The first…
Read More » -
Core Java
Java 8 Friday Goodies: Lambdas and SQL
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
You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!
You’re very likely to have gotten SQL date time arithmetic wrong. And why is that? Google it! You’ll quickly find…
Read More »