Support
Search Shortcut cmd + k | ctrl + k

Engineering Blog

Category
Category
Reconciling JSON in DuckDB, One Patch at a Time

Reconciling JSON in DuckDB, One Patch at a Time

2026-08-18
12 min
Mustafa Khan
A Preview of DuckDB v2.0

A Preview of DuckDB v2.0

2026-08-17
15 min
Mark Raasveldt and Hannes Mühleisen
Thank You for 40 000 Stars on GitHub

Thank You for 40 000 Stars on GitHub

2026-08-05
4 min
The DuckDB team
Asynchronous I/O in DuckDB: Work, Thread, Work

Asynchronous I/O in DuckDB: Work, Thread, Work

2026-07-31
21 min
Pedro Holanda
Announcing DuckDB 1.5.5

Announcing DuckDB 1.5.5

2026-07-22
2 min
The DuckDB team
Announcing DuckDB 1.5.4 (Variegata)

Announcing DuckDB 1.5.4 (Variegata)

2026-06-17
3 min
The DuckDB team
Announcing DuckDB 1.4.5 LTS (Andium)

Announcing DuckDB 1.4.5 LTS (Andium)

2026-06-17
1 min
The DuckDB team
New DuckDB-Iceberg Features in v1.5.3

New DuckDB-Iceberg Features in v1.5.3

2026-05-29
5 min
Tom Ebergen, Thijs Bruineman
Test-Driving the Lance Lakehouse Format in DuckDB

Test-Driving the Lance Lakehouse Format in DuckDB

2026-05-21
11 min
LanceDB team and Guillermo Sanchez
DuckDB 1.5.3: Not an Ordinary Patch Release

DuckDB 1.5.3: Not an Ordinary Patch Release

2026-05-20
4 min
The DuckDB team
Quack: The DuckDB Client-Server Protocol

Quack: The DuckDB Client-Server Protocol

2026-05-12
20 min
The DuckDB team
Announcing the Program of DuckCon #7 Amsterdam

Announcing the Program of DuckCon #7 Amsterdam

2026-05-08
30 sec
Gábor Szárnyas
Delta Grows Up: Writes, Unity Catalog and Time Travel

Delta Grows Up: Writes, Unity Catalog and Time Travel

2026-05-07
10 min
Ben Fleis
The DuckLake Spec Is so Simple, Even a Clanker Can Build One for Dataframes

The DuckLake Spec Is so Simple, Even a Clanker Can Build One for Dataframes

2026-05-04
DuckLake
Pedro Holanda, Dr. Peter van Holland
DuckLake v1.0: The Lakehouse Format Built on SQL Reaches Production-Readiness

DuckLake v1.0: The Lakehouse Format Built on SQL Reaches Production-Readiness

2026-04-13
DuckLake
The DuckDB team
Announcing DuckDB 1.5.2

Announcing DuckDB 1.5.2

2026-04-13
3 min
The DuckDB team
Data Inlining in DuckLake: Unlocking Streaming for Data Lakes

Data Inlining in DuckLake: Unlocking Streaming for Data Lakes

2026-04-02
DuckLake
Pedro Holanda
DuckDB Now Speaks Dutch!

DuckDB Now Speaks Dutch!

2026-04-01
1 min
Daniël ten Wolde
Announcing DuckDB 1.5.1

Announcing DuckDB 1.5.1

2026-03-23
2 min
The DuckDB team
DuckDB.ExtensionKit: Building DuckDB Extensions in C#

DuckDB.ExtensionKit: Building DuckDB Extensions in C#

2026-03-20
9 min
Giorgi Dalakishvili
Big Data on the Cheapest MacBook

Big Data on the Cheapest MacBook

2026-03-11
7 min
Gábor Szárnyas
Announcing DuckDB 1.5.0

Announcing DuckDB 1.5.0

2026-03-09
16 min
The DuckDB team
Announcing DuckDB 1.4.4 LTS

Announcing DuckDB 1.4.4 LTS

2026-01-26
1 min
The DuckDB team
Announcing Vortex Support in DuckDB

Announcing Vortex Support in DuckDB

2026-01-23
8 min
Guillermo Sanchez, SpiralDB Team
DuckDB on LoongArch

DuckDB on LoongArch

2026-01-06
6 min
Hannes Mühleisen
Iceberg in the Browser

Iceberg in the Browser

2025-12-16
5 min
Carlo Piovesan, Tom Ebergen, Gábor Szárnyas
Announcing DuckDB 1.4.3 LTS

Announcing DuckDB 1.4.3 LTS

2025-12-09
3 min
The DuckDB team
Writes in DuckDB-Iceberg

Writes in DuckDB-Iceberg

2025-11-28
5 min
Tom Ebergen
Data-at-Rest Encryption in DuckDB

Data-at-Rest Encryption in DuckDB

2025-11-19
22 min
Lotte Felius, Hannes Mühleisen
Announcing DuckDB 1.4.2 LTS

Announcing DuckDB 1.4.2 LTS

2025-11-12
5 min
The DuckDB team
Relational Charades: Turning Movies into Tables

Relational Charades: Turning Movies into Tables

2025-10-27
14 min
Hannes Mühleisen
Frozen DuckLakes for Multi-User, Serverless Data Access

Frozen DuckLakes for Multi-User, Serverless Data Access

2025-10-24
DuckLake
Mark Harrison (Madhive Data Engineering)
Uncovering Financial Crime with DuckDB and Graph Queries

Uncovering Financial Crime with DuckDB and Graph Queries

2025-10-22
12 min
Daniël ten Wolde
Streaming Patterns with DuckDB

Streaming Patterns with DuckDB

2025-10-13
10 min
Guillermo Sanchez
Adoption Metrics and Benchmark Results for DuckDB v1.4 LTS

Adoption Metrics and Benchmark Results for DuckDB v1.4 LTS

2025-10-09
2 min
The DuckDB team
Announcing DuckDB 1.4.1 LTS

Announcing DuckDB 1.4.1 LTS

2025-10-07
2 min
The DuckDB team
Redesigning DuckDB's Sort, Again

Redesigning DuckDB's Sort, Again

2025-09-24
16 min
Laurens Kuiper
DuckLake 0.3 with Iceberg Interoperability and Geometry Support

DuckLake 0.3 with Iceberg Interoperability and Geometry Support

2025-09-17
DuckLake
Guillermo Sanchez, Gábor Szárnyas
Announcing DuckDB 1.4.0 LTS

Announcing DuckDB 1.4.0 LTS

2025-09-16
7 min
The DuckDB team
Solving Letter Scramble Puzzles with DuckDB

Solving Letter Scramble Puzzles with DuckDB

2025-09-11
4 min
Gábor Szárnyas
Big Data on the Move: DuckDB on the Framework Laptop 13

Big Data on the Move: DuckDB on the Framework Laptop 13

2025-09-08
9 min
Gábor Szárnyas
Basic Feature Engineering with DuckDB

Basic Feature Engineering with DuckDB

2025-08-15
9 min
Petrica Leuca
Spatial Joins in DuckDB

Spatial Joins in DuckDB

2025-08-08
22 min
Max Gabrielsson
DuckLake 0.2

DuckLake 0.2

2025-07-04
DuckLake
Mark Raasveldt
Discovering DuckDB Use Cases via GitHub

Discovering DuckDB Use Cases via GitHub

2025-06-27
8 min
Petrica Leuca
Lightweight Text Analytics Workflows with DuckDB

Lightweight Text Analytics Workflows with DuckDB

2025-06-13
9 min
Petrica Leuca
30 000 Stars on GitHub

30 000 Stars on GitHub

2025-06-06
1 min
The DuckDB team
Faster Dashboards with Multi-Column Approximate Sorting

Faster Dashboards with Multi-Column Approximate Sorting

2025-06-06
19 min
Alex Monahan
DuckLake: SQL as a Lakehouse Format

DuckLake: SQL as a Lakehouse Format

2025-05-27
DuckLake
Mark Raasveldt, Hannes Mühleisen
USING KEY in Recursive CTEs

USING KEY in Recursive CTEs

2025-05-23
18 min
Björn Bamberg, Torsten Grust
Arrow IPC Support in DuckDB

Arrow IPC Support in DuckDB

2025-05-23
10 min
Pedro Holanda (DuckLabs), Ian Cook (Columnar), Dewey Dunnington (Wherobots), Bryce Mecum (Voltron Data)
Announcing DuckDB 1.3.0

Announcing DuckDB 1.3.0

2025-05-21
12 min
The DuckDB team
The Lost Decade of Small Data?

The Lost Decade of Small Data?

2025-05-19
9 min
Hannes Mühleisen
Machine Learning Prototyping with DuckDB and scikit-learn

Machine Learning Prototyping with DuckDB and scikit-learn

2025-05-16
7 min
Petrica Leuca
Sorting on Insert for Fast Selective Queries

Sorting on Insert for Fast Selective Queries

2025-05-14
13 min
Alex Monahan
Temporal Analysis with Stream Windowing Functions in DuckDB

Temporal Analysis with Stream Windowing Functions in DuckDB

2025-05-02
7 min
Petrica Leuca, Gábor Szárnyas
DuckDB's CSV Reader and the Pollock Robustness Benchmark: Into the CSV Abyss

DuckDB's CSV Reader and the Pollock Robustness Benchmark: Into the CSV Abyss

2025-04-16
16 min
Pedro Holanda, Gábor Szárnyas (DuckLabs); Gerardo Vitagliano (MIT)
Fully Local Data Transformation with dbt and DuckDB

Fully Local Data Transformation with dbt and DuckDB

2025-04-04
7 min
Petrica Leuca
Using DuckDB in Streamlit

Using DuckDB in Streamlit

2025-03-28
9 min
Petrica Leuca
Maximizing Your Delta Scan Performance in DuckDB

Maximizing Your Delta Scan Performance in DuckDB

2025-03-21
15 min
Sam Ansmink
Preview: Amazon S3 Tables in DuckDB

Preview: Amazon S3 Tables in DuckDB

2025-03-14
5 min
Sam Ansmink, Tom Ebergen, Gábor Szárnyas
The DuckDB Local UI

The DuckDB Local UI

2025-03-12
6 min
Jeff Raymakers, Gábor Szárnyas
Parquet Bloom Filters in DuckDB

Parquet Bloom Filters in DuckDB

2025-03-07
10 min
Hannes Mühleisen
Gems of DuckDB 1.2

Gems of DuckDB 1.2

2025-03-06
4 min
The DuckDB team
Reading and Writing Google Sheets in DuckDB

Reading and Writing Google Sheets in DuckDB

2025-02-26
10 min
Alex Monahan, Archie Wood
Prefix Aliases in SQL

Prefix Aliases in SQL

2025-02-25
4 min
Hannes Mühleisen
Planning AsOf Joins

Planning AsOf Joins

2025-02-19
10 min
Richard Wesley
Flying Through Windows

Flying Through Windows

2025-02-14
11 min
Richard Wesley
Catching up with Windowing

Catching up with Windowing

2025-02-10
8 min
Richard Wesley
Announcing DuckDB 1.2.0

Announcing DuckDB 1.2.0

2025-02-05
9 min
The DuckDB team
Query Engines: Gatekeepers of the Parquet File Format

Query Engines: Gatekeepers of the Parquet File Format

2025-01-22
8 min
Laurens Kuiper
TPC-H on a Raspberry Pi

TPC-H on a Raspberry Pi

2025-01-17
6 min
Gábor Szárnyas
Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME

Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME

2025-01-10
15 min
Alex Monahan
DuckDB Node Neo Client

DuckDB Node Neo Client

2024-12-18
7 min
Jeff Raymakers
25 000 Stars on GitHub

25 000 Stars on GitHub

2024-12-16
2 min
The DuckDB team
The DuckDB Avro Extension

The DuckDB Avro Extension

2024-12-09
9 min
Hannes Mühleisen
DuckDB: Running TPC-H SF100 on Mobile Phones

DuckDB: Running TPC-H SF100 on Mobile Phones

2024-12-06
7 min
Gábor Szárnyas, Laurens Kuiper, Hannes Mühleisen
CSV Files: Dethroning Parquet as the Ultimate Storage File Format — or Not?

CSV Files: Dethroning Parquet as the Ultimate Storage File Format — or Not?

2024-12-05
13 min
Pedro Holanda
DuckDB Tricks – Part 3

DuckDB Tricks – Part 3

2024-11-29
7 min
Andra Ionescu, Gábor Szárnyas
Runtime-Extensible SQL Parsers Using PEG

Runtime-Extensible SQL Parsers Using PEG

2024-11-22
18 min
Hannes Mühleisen, Mark Raasveldt
Optimizers: The Low-Key MVP

Optimizers: The Low-Key MVP

2024-11-14
17 min
Tom Ebergen
Analytics-Optimized Concurrent Transactions

Analytics-Optimized Concurrent Transactions

2024-10-30
17 min
Mark Raasveldt, Hannes Mühleisen
Fast Top N Aggregation and Filtering with DuckDB

Fast Top N Aggregation and Filtering with DuckDB

2024-10-25
13 min
Alex Monahan
What's New in the Vector Similarity Search Extension?

What's New in the Vector Similarity Search Extension?

2024-10-23
8 min
Max Gabrielsson
Driving CSV Performance: Benchmarking DuckDB with the NYC Taxi Dataset

Driving CSV Performance: Benchmarking DuckDB with the NYC Taxi Dataset

2024-10-16
13 min
Pedro Holanda
DuckDB Tricks – Part 2

DuckDB Tricks – Part 2

2024-10-11
5 min
Gábor Szárnyas
Analyzing Open Government Data with duckplyr

Analyzing Open Government Data with duckplyr

2024-10-09
8 min
Hannes Mühleisen
DuckDB User Survey Analysis

DuckDB User Survey Analysis

2024-10-04
7 min
Gábor Szárnyas
DuckDB in Python in the Browser with Pyodide, PyScript, and JupyterLite

DuckDB in Python in the Browser with Pyodide, PyScript, and JupyterLite

2024-10-02
8 min
Alex Monahan
Creating a SQL-Only Extension for Excel-Style Pivoting in DuckDB

Creating a SQL-Only Extension for Excel-Style Pivoting in DuckDB

2024-09-27
22 min
Alex Monahan
Changing Data with Confidence and ACID

Changing Data with Confidence and ACID

2024-09-25
18 min
Hannes Mühleisen, Mark Raasveldt
Announcing DuckDB 1.1.0

Announcing DuckDB 1.1.0

2024-09-09
13 min
The DuckDB team
DuckDB Tricks – Part 1

DuckDB Tricks – Part 1

2024-08-19
5 min
Gábor Szárnyas
Friendly Lists and Their Buddies, the Lambdas

Friendly Lists and Their Buddies, the Lambdas

2024-08-08
9 min
Tania Bogatsch, Maia de Graaf
Memory Management in DuckDB

Memory Management in DuckDB

2024-07-09
8 min
Mark Raasveldt
DuckDB Community Extensions

DuckDB Community Extensions

2024-07-05
7 min
The DuckDB team
Benchmarking Ourselves over Time at DuckDB

Benchmarking Ourselves over Time at DuckDB

2024-06-26
23 min
Alex Monahan
20 000 Stars on GitHub

20 000 Stars on GitHub

2024-06-22
2 min
The DuckDB team
Command Line Data Processing: Using DuckDB as a Unix Tool

Command Line Data Processing: Using DuckDB as a Unix Tool

2024-06-20
19 min
Gábor Szárnyas
Native Delta Lake Support in DuckDB

Native Delta Lake Support in DuckDB

2024-06-10
14 min
Sam Ansmink
Announcing DuckDB 1.0.0

Announcing DuckDB 1.0.0

2024-06-03
7 min
Mark Raasveldt, Hannes Mühleisen
Analyzing Railway Traffic in the Netherlands

Analyzing Railway Traffic in the Netherlands

2024-05-31
11 min
Gábor Szárnyas
Access 150k+ Datasets from Hugging Face with DuckDB

Access 150k+ Datasets from Hugging Face with DuckDB

2024-05-29
6 min
The Hugging Face and DuckDB teams
Vector Similarity Search in DuckDB

Vector Similarity Search in DuckDB

2024-05-03
8 min
Max Gabrielsson
duckplyr: dplyr Powered by DuckDB

duckplyr: dplyr Powered by DuckDB

2024-04-02
20 min
Hannes Mühleisen
No Memory? No Problem. External Aggregation in DuckDB

No Memory? No Problem. External Aggregation in DuckDB

2024-03-29
17 min
Laurens Kuiper
42.parquet – A Zip Bomb for the Big Data Age

42.parquet – A Zip Bomb for the Big Data Age

2024-03-26
5 min
Hannes Mühleisen
Dependency Management in DuckDB Extensions

Dependency Management in DuckDB Extensions

2024-03-22
12 min
Sam Ansmink
SQL Gymnastics: Bending SQL into Flexible New Shapes

SQL Gymnastics: Bending SQL into Flexible New Shapes

2024-03-01
18 min
Alex Monahan
Announcing DuckDB 0.10.0

Announcing DuckDB 0.10.0

2024-02-13
13 min
Mark Raasveldt, Hannes Mühleisen
Multi-Database Support in DuckDB

Multi-Database Support in DuckDB

2024-01-26
6 min
Mark Raasveldt
Extensions for DuckDB-Wasm

Extensions for DuckDB-Wasm

2023-12-18
8 min
Carlo Piovesan
Updates to the H2O.ai db-benchmark!

Updates to the H2O.ai db-benchmark!

2023-11-03
6 min
Tom Ebergen
DuckDB's CSV Sniffer: Automatic Detection of Types and Dialects

DuckDB's CSV Sniffer: Automatic Detection of Types and Dialects

2023-10-27
19 min
Pedro Holanda
Announcing DuckDB 0.9.0

Announcing DuckDB 0.9.0

2023-09-26
9 min
Mark Raasveldt, Hannes Mühleisen
DuckDB's AsOf Joins: Fuzzy Temporal Lookups

DuckDB's AsOf Joins: Fuzzy Temporal Lookups

2023-09-15
20 min
Richard Wesley
Even Friendlier SQL with DuckDB

Even Friendlier SQL with DuckDB

2023-08-23
18 min
Alex Monahan
DuckDB ADBC – Zero-Copy Data Transfer via Arrow Database Connectivity

DuckDB ADBC – Zero-Copy Data Transfer via Arrow Database Connectivity

2023-08-04
7 min
Pedro Holanda
From Waddle to Flying: Quickly Expanding DuckDB's Functionality with Scalar Python UDFs

From Waddle to Flying: Quickly Expanding DuckDB's Functionality with Scalar Python UDFs

2023-07-07
10 min
Pedro Holanda, Thijs Bruineman, Phillip Cloud
Correlated Subqueries in SQL

Correlated Subqueries in SQL

2023-05-26
9 min
Mark Raasveldt
Announcing DuckDB 0.8.0

Announcing DuckDB 0.8.0

2023-05-17
7 min
Mark Raasveldt, Hannes Mühleisen
10 000 Stars on GitHub

10 000 Stars on GitHub

2023-05-12
1 min
Mark Raasveldt, Hannes Mühleisen
PostGEESE? Introducing The DuckDB Spatial Extension

PostGEESE? Introducing The DuckDB Spatial Extension

2023-04-28
16 min
Max Gabrielsson
Introducing DuckDB for Swift

Introducing DuckDB for Swift

2023-04-21
5 min
Tristan Celder
The Return of the H2O.ai Database-like Ops Benchmark

The Return of the H2O.ai Database-like Ops Benchmark

2023-04-14
8 min
Tom Ebergen
Shredding Deeply Nested JSON, One Vector at a Time

Shredding Deeply Nested JSON, One Vector at a Time

2023-03-03
14 min
Laurens Kuiper
JupySQL Plotting with DuckDB

JupySQL Plotting with DuckDB

2023-02-24
9 min
Guest post by Eduardo Blancas
Announcing DuckDB 0.7.0

Announcing DuckDB 0.7.0

2023-02-13
6 min
Mark Raasveldt
Announcing DuckDB 0.6.0

Announcing DuckDB 0.6.0

2022-11-14
11 min
Mark Raasveldt
Lightweight Compression in DuckDB

Lightweight Compression in DuckDB

2022-10-28
15 min
Mark Raasveldt
Modern Data Stack in a Box with DuckDB

Modern Data Stack in a Box with DuckDB

2022-10-12
12 min
Guest post by Jacob Matson
Querying Postgres Tables Directly from DuckDB

Querying Postgres Tables Directly from DuckDB

2022-09-30
14 min
Hannes Mühleisen
Persistent Storage of Adaptive Radix Trees (ART) in DuckDB

Persistent Storage of Adaptive Radix Trees (ART) in DuckDB

2022-07-27
22 min
Pedro Holanda
Range Joins in DuckDB

Range Joins in DuckDB

2022-05-27
23 min
Richard Wesley
Friendlier SQL with DuckDB

Friendlier SQL with DuckDB

2022-05-04
11 min
Alex Monahan
Parallel Grouped Aggregation in DuckDB

Parallel Grouped Aggregation in DuckDB

2022-03-07
21 min
Hannes Mühleisen, Mark Raasveldt
DuckDB Time Zones: Supporting Calendar Extensions

DuckDB Time Zones: Supporting Calendar Extensions

2022-01-06
12 min
Richard Wesley
DuckDB Quacks Arrow: A Zero-Copy Data Integration between Apache Arrow and DuckDB

DuckDB Quacks Arrow: A Zero-Copy Data Integration between Apache Arrow and DuckDB

2021-12-03
10 min
Pedro Holanda, Jonathan Keane
DuckDB – Lord of the Enums: The Fellowship of the Categorical and Factors

DuckDB – Lord of the Enums: The Fellowship of the Categorical and Factors

2021-11-26
6 min
Pedro Holanda
Fast Moving Holistic Aggregates

Fast Moving Holistic Aggregates

2021-11-12
12 min
Richard Wesley
DuckDB-Wasm: Efficient Analytical SQL in the Browser

DuckDB-Wasm: Efficient Analytical SQL in the Browser

2021-10-29
15 min
André Kohn, Dominik Moritz
Windowing in DuckDB

Windowing in DuckDB

2021-10-13
15 min
Richard Wesley
Fastest Table Sort in the West – Redesigning DuckDB’s Sort

Fastest Table Sort in the West – Redesigning DuckDB’s Sort

2021-08-27
31 min
Laurens Kuiper
Querying Parquet with Precision Using DuckDB

Querying Parquet with Precision Using DuckDB

2021-06-25
10 min
Hannes Mühleisen, Mark Raasveldt
Efficient SQL on Pandas with DuckDB

Efficient SQL on Pandas with DuckDB

2021-05-14
17 min
Mark Raasveldt, Hannes Mühleisen
Testing Out DuckDB's Full Text Search Extension

Testing Out DuckDB's Full Text Search Extension

2021-01-25
4 min
Laurens Kuiper