Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
How to use DuckDB's COLUMNS expression to automatically rename fields when using SELECT * across joined tables, avoiding ambiguous column names.
An overview of Apache Flink CDC, its declarative pipeline feature, and how it simplifies data integration from databases like MySQL to sinks like Elasticsearch.
Essential Linux skills for SQL Database Administrators to improve efficiency and marketability in modern IT environments.
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.
