Explores SQL array functions and the integration of lambda expressions in modern SQL dialects like ClickHouse and DuckDB for filtering and transforming array data.
A product manager argues against excessive documentation, explaining why linking unrelated features can create clutter and maintenance issues.
jOOQ 3.20 released with new SQL dialect support for ClickHouse and Databricks, expanded DuckDB features, and various new modules and improvements.
Explains how jOOQ 3.19's implicit joins can automatically eliminate unnecessary table joins from SQL queries, improving performance.
jOOQ 3.19 introduces new explicit and implicit to-many path joins, simplifying SQL query syntax and improving readability and correctness.
Explains a common MySQL UPDATE error and provides a workaround using a derived table or jOOQ to bypass the restriction.
jOOQ 3.19.0 release adds support for DuckDB, Trino, Oracle 23c, introduces join path improvements, an official Gradle plugin, and commercial Maven repositories.
Discusses the pros and cons of using jOOQ's DAO API versus writing explicit SQL, highlighting the risk of N+1 problems.
A guide on configuring jOOQ's code generator to produce package-private Java classes for better encapsulation.
A technical guide on using jOOQ to pass table-valued parameters (TVPs) to T-SQL functions from Java, with code examples.
A tutorial on converting flat data into hierarchical structures using SQL, Java, and the jOOQ library's new features.
jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
Explains a caveat with using jOOQ's ad-hoc converters in UNION operations and provides solutions for proper client-side type conversion.
A tutorial on writing derived tables in jOOQ, explaining syntax, type safety considerations, and questioning if a derived table is always necessary.
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 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.
