Introducing sql-compare, a tool for managing and testing SQL database migrations, born from the challenges of evolving PostgreSQL schemas at Mergify.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
HeavyIQ is an AI-powered English-to-SQL interface from HEAVY.AI, using a fine-tuned LLM to query and visualize massive datasets like flight records.
Explains how to compare dates by ignoring the time component in PostgreSQL queries, using the DATE() function.
A tutorial on building a simple database with MVCC to implement and understand the five major SQL transaction isolation levels in 400 lines of code.
A tutorial on using Dremio and Docker to run SQL queries directly on Excel files from your local machine.
A monthly roundup of news and resources on stream processing, Apache Flink, Kafka, and data engineering from industry experts.
Argues against using LLMs to generate SQL queries for novel business questions, highlighting the importance of human analysts for precision.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
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.
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.
