Imperative Loop or Functional Stream Pipeline? Beware of the Performance Impact!

Beware of Hidden PL/SQL to SQL Context Switches

How SQL DISTINCT and ORDER BY are Related

PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses

Truth First, or Why You Should Mostly Implement Database First Designs

Oracle’s OFFSET .. FETCH is Slower Than Classic ROWNUM Filtering

How to Patch Your IDE to Fix an Urgent Bug

jOOQ 3.11 Released With 4 New Databases (in Professional + Enterprise editions), Implicit Joins, Diagnostics, and Much More

Selecting All Columns Except One in PostgreSQL

How Functional Programming will (Finally) do Away With the GoF Patterns

Correct Reflective Access to Interface Default Methods in Java 8, 9, 10

Top 10 Useful, Yet Paranoid Java Programming Techniques

Calculating Tupper’s Self-Referential Formula with SQL

Type Safe Implicit JOIN Through Path Navigation in jOOQ 3.11

Top 5 Hidden jOOQ Features

The Cost of JDBC Server Roundtrips

A Common Mistake Developers Make When Caching Nullable Values

How to Ensure Your Code Works With Older JDKs

Squeezing Another 10% Speed Increase out of jOOQ using JMC and JMH

How to Write Efficient TOP N Queries in SQL

Benchmarking JDK String.replace() vs Apache Commons StringUtils.replace()

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

JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage

Finding all Palindromes Contained in Strings with SQL

Don’t Use the String Concatenation “Trick” in SQL Predicates

When to Use Bind Values, and When to Use Inline Values in SQL

How to Find Redundant Indexes in SQL

Are Java 8 Streams Truly Lazy? Not Completely!

10 Tips on How to be a Great Programmer

Say no to Venn diagrams when explaining JOINs

More →