-
Software Development
Infinite Loops. Or: Anything that Can Possibly Go Wrong, Does.
A wise man once said: Anything that can possibly go wrong, does – Murphy Some programmers are wise men, thus…
Read More » -
Desktop Java
Transform Your SQL Data into Charts Using jOOQ and JavaFX
In the recent past, we’ve shown how Java 8 and functional programming will bring a new perspective to Java developers…
Read More » -
Software Development
How to Emulate the MEDIAN() Aggregate Function Using Inverse Distribution Functions
Some databases are awesome enough to implement the MEDIAN() aggregate function. Remember that the MEDIAN() is sligthly different from (and…
Read More » -
Software Development
The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions
Sometimes when aggregating data with SQL, we’d love to add some additional filters. For instance, consider the following world bank…
Read More » -
Enterprise Java
Leaky Abstractions, or How to Bind Oracle DATE Correctly with Hibernate
We’ve recently published an article about how to bind the Oracle DATE type correctly in SQL / JDBC, and jOOQ.…
Read More » -
Software Development
Are You Binding Your Oracle DATEs Correctly? I Bet You Aren’t
Oracle database has its ways. In my SQL talks at conferences, I love to confuse people with the following Oracle…
Read More » -
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
Don’t be “Clever”: The Double Curly Braces Anti Pattern
From time to time, I find someone using the double curly braces anti pattern (also called double brace initialisation) in…
Read More » -
Software Development
jOOQ Tuesdays: Yalim Gerger brings Git to Oracle
We’re excited to launch a new series on our blog: the jOOQ Tuesdays. In this series, we’ll publish an article…
Read More »