A technical guide to solving the One Billion Row Challenge (1BRC) using SQL and DuckDB, including data loading and aggregation.
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.
A tutorial on converting flat data into hierarchical structures using SQL, Java, and the jOOQ library's new features.
Entity Framework Core 8 introduces raw SQL queries that can return unmapped types, a highly anticipated feature for .NET developers.
A quick guide on using DuckDB's SQL commands to efficiently convert CSV files to the Parquet format, including schema modifications.
jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
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.
Explores using the M4 macro processor to make SQL code more modular, reusable, and composable for managing large, complex codebases.
A guide for developers on when to use the jOOQ API versus writing native SQL, comparing pros and cons for each approach.
A tutorial on building a basic embedded SQL database in Zig using RocksDB, covering lexing, parsing, storage, and execution.
Explains how to use the SQL LATERAL keyword to create local column variables and simplify complex queries, improving readability.
Analyzing conference session ratings using DuckDB and Jupyter Notebooks to demonstrate data wrangling and SQL on raw CSV data.
A technique for future-proofing SQL code by intentionally adding errors to catch unexpected changes in data or logic.
Explains pagination concepts, formulas, and implementation in C#/SQL, comparing it to infinite scrolling for efficient data loading.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
