A guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
A tutorial on using SQL with Apache Iceberg tables in the Dremio data lakehouse platform, covering setup and core operations.
Learn to export DynamoDB data to S3 and query it using SQL with AWS Athena, exploring serverless, scalable analytics solutions.
A guide explaining dbt macros, their purpose, benefits, and how to use them to write reusable, standardized SQL code in data transformation projects.
A tutorial on connecting to and querying SQL databases using the R programming language, including driver setup and error handling.
Explains how to use Amazon Q Developer's workspace context and @workspace hint to generate accurate SQL queries by providing relevant schema files.
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.
