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
A tutorial on writing derived tables in jOOQ, explaining syntax, type safety considerations, and questioning if a derived table is always necessary.
Analyzes the performance difference between SQL's FILTER clause and CASE expressions in aggregate functions, using PostgreSQL benchmarks.
A guide to emulating window functions in MySQL 5.7 using local variables, highlighting the limitations and risks of this approach.
Explains the benefits of executing database queries with jOOQ's API instead of extracting SQL for use with other tools like JdbcTemplate.
jOOQ introduces a LoggingConnection for R2DBC to log all reactive SQL statements, useful for debugging in reactive applications.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
Explains how to call stored procedures with default parameters using jOOQ and JDBC, covering syntax for Oracle, PostgreSQL, and other databases.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
An overview of the most important types in the jOOQ Java SQL library, including Configuration, Scopes, Settings, and the DSL API.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
A technical guide demonstrating how to fetch hierarchical DTO projections in Spring Data JPA using jOOQ's MULTISET operator for type-safe queries.
Explains and resolves the 'Cannot resolve symbol VERSION_3_17' compilation error in jOOQ generated code due to version mismatches.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
jOOQ 3.17 now treats SQL Conditions as Boolean Fields, simplifying queries and improving SQL standard compliance across dialects.
Explores various SQL dialects and jOOQ methods for returning data from INSERT, UPDATE, and DELETE statements using the RETURNING clause.
A guide on using jOOQ and Testcontainers to write integration tests for database stored procedures in Java, replacing manual JDBC calls.
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.
