GROUP BY ALL in Bigquery
Introduces BigQuery's new GROUP BY ALL syntax, which automatically infers grouping keys from SELECT items to simplify complex SQL queries.
Introduces BigQuery's new GROUP BY ALL syntax, which automatically infers grouping keys from SELECT items to simplify complex SQL queries.
An introduction to ANSI SQL, covering its standardized syntax, key concepts like DDL, DML, joins, CTEs, and its importance for database interoperability.
Explains a performance optimization technique for checking multiple row existence in SQL using LIMIT clauses, with benchmarks across RDBMS.
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.
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.
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.
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.