Lukas Eder is a SQL expert and creator of jOOQ who writes in-depth articles on SQL standards, database performance, and advanced query design. His blog focuses on practical and theoretical aspects of modern relational databases.
50 articles from this blog
jOOQ 3.17.0 release introduces client-side computed columns, audit columns, pattern matching, reactive transactions, and Kotlin coroutine support.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
Benchmark comparing performance of jOOQ's MULTISET emulation vs. other approaches for nesting to-many relationships in SQL queries.
Discusses why SQL's SELECT..FROM syntax order isn't a flaw to be 'fixed' by FROM..SELECT, comparing it to logical execution order and language design.
Explores various data fetching methods in jOOQ, including iterable, single-record, and resourceful fetching techniques.
Explores whether setting JDBC Statement.setFetchSize(1) for single-row queries improves performance, with benchmark results across databases.
A tutorial on using jOOQ's MULTISET operator and type-safe conversion to map nested SQL query results into a nested Java Map structure.
Explains how to use SQL's NATURAL FULL JOIN to concatenate data from unrelated tables, like actor, customer, and staff, into a single result set.
Explains jOOQ's API for managing nested transactions, comparing it to JDBC defaults and Spring's @Transactional behavior.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
