How to Calculate Multiple Aggregate Functions in a Single Query

Many SQL Performance Problems Stem from “Unnecessary, Mandatory Work”

The Open-Closed Principle is Often Not What You Think it Is

A Nice API Design Gem: Strategy Pattern With Lambdas

Why You Should Design Your Database to Optimise for Statistics

Should I Implement the Arcane Iterator.remove() Method? Yes You (Probably) Should

A Beginner’s Guide to the True Order of SQL Operations

Faster SQL Pagination with jOOQ Using the Seek Method

How to Prevent JDBC Resource Leaks with JDBC and with jOOQ

A beginner's Guide to the many different ways to JOIN tables in SQL

A Little Known SQL Feature: Use Logical Windowing to Aggregate Sliding Ranges

SQL, Streams, For Comprehension… It’s All the Same

The Java Ecosystem’s Obsession with NonNull Annotations

Probably the Coolest SQL Feature: Window Functions (2013)

The Inconvenient Truth About Dynamic vs. Static Typing

Avoid Using COUNT() in SQL When You Could Use EXISTS()

Why Most Programmers Get Pagination Wrong

Using jOOλ to Combine Several Java 8 Collectors into One

The Java JIT Compiler is Darn Good at Optimization

Say NO to Venn Diagrams When Explaining JOINs

Cyclops-react Organises the Cambrian Explosion of Java 8 Libraries

JSR-308 and the Checker Framework Add More Typesafety to jOOQ 3.9

SQL Tricks

jOOQ 4.0’s New API Will Use Annotations Only for Truly Declarative Java/SQL Programming

10 Easy Steps to a Complete Understanding of SQL

Ceylon Might Just be the Only Language that Got Nulls Right

How to Support Java 6, 8, 9 in a Single API

A Very Peculiar, but Possibly Cunning Kotlin Language Feature

An Ingenious Workaround to Emulate Sum Types in Java

Impress Your Coworkers by Using SQL UNPIVOT

More →