-
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 »




