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.
53 articles from this blog
Explores using the H2 in-memory database for testing with jOOQ, covering SQL standardisation and H2's compatibility modes.
Explains how to use jOOQ to call stored procedures from Java, highlighting benefits over raw JDBC for type safety and maintainability.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
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.
