Loading...

Tag trends are in beta. Feedback? Thoughts? Email me at [email protected]

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

Null Is Not the Billion Dollar Mistake. A Counter-Rant (2015)

10 Cool SQL Optimisations That do not Depend on the Cost Model

jOOQ 3.19.0 Released with DuckDB, Trino, Oracle 23c support, join path improvements, an official gradle plugin, commercial maven repositories, policies, UDT paths, trigger meta data, hierarchies…

How to turn a list of flat elements into a hierarchy in Java, SQL, or jOOQ

How to Write a Multiplication Aggregate Function in SQL

The second best way to fetch a Spring Data JPA DTO Projection

jOOQ 3.17.0 release with client side computed columns, audit columns, pattern matching, reactive transactions and kotlin coroutine support

Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries

Various Meanings of SQL’s PARTITION BY Syntax

Fun with PostGIS: Mandelbrot set, game of life, and more

Java’s Checked Exceptions Are Just Weird Union Types

SQL optimisations that do not depend on the cost model (2017)

10 things you didn’t know about jOOQ

3.15.0 Release with support for R2DBC, nested ROW, ARRAY, and MULTISET types, 5 new SQL dialects, CREATE PROCEDURE, FUNCTION, and TRIGGER support and much more

Never Again Forget to Call .execute() in jOOQ

Calculating Pagination Metadata Without Extra Roundtrips in SQL or with jOOQ

Implementing a generic REDUCE aggregate function with SQL

jOOQ 3.14 Released With SQL/XML and SQL/JSON Support

5 Ways to Better Understand SQL by Adding Optional Parentheses

Why Most Programmers Get Pagination Wrong

What’s Faster? COUNT(*) or COUNT(1)?

jOOQ 3.12 Released With a new Procedural Language API

How to Write a Simple, yet Extensible API

Using IGNORE NULLS With SQL Window Functions to Fill Gaps

The Difference Between SQL’s Join –. On Clause and the Where Clause

The Cost of Useless Surrogate Keys in Relationship Tables

How to Calculate a Cumulative Percentage in SQL

Say NO to Venn Diagrams When Explaining JOINs

How to Unit Test Your Annotation Processor using jOOR

More →