Support
Search Shortcut cmd + k | ctrl + k

Blog

Discovering DuckDB Use Cases via GitHub
using DuckDB

Discovering DuckDB Use Cases via GitHub

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

Lightweight Text Analytics Workflows with DuckDB

2025-06-13
Petrica Leuca
30 000 Stars on GitHub
release

30 000 Stars on GitHub

2025-06-06
The DuckDB team
Faster Dashboards with Multi-Column Approximate Sorting
deep dive

Faster Dashboards with Multi-Column Approximate Sorting

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

DuckLake: SQL as a Lakehouse Format

2025-05-27
Mark Raasveldt and Hannes Mühleisen
USING KEY in Recursive CTEs
deep dive

USING KEY in Recursive CTEs

2025-05-23
Björn Bamberg and Torsten Grust
Arrow IPC Support in DuckDB
extensions

Arrow IPC Support in DuckDB

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

Announcing DuckDB 1.3.0

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

The Lost Decade of Small Data?

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

Machine Learning Prototyping with DuckDB and scikit-learn

2025-05-16
Petrica Leuca
Sorting on Insert for Fast Selective Queries
deep dive

Sorting on Insert for Fast Selective Queries

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

Temporal Analysis with Stream Windowing Functions in DuckDB

2025-05-02
Petrica Leuca, Gabor Szarnyas
DuckDB's CSV Reader and the Pollock Robustness Benchmark: Into the CSV Abyss
benchmark

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

2025-04-16
Pedro Holanda, Gabor Szarnyas (DuckDB Labs); Gerardo Vitagliano (MIT)
Fully Local Data Transformation with dbt and DuckDB
using DuckDB

Fully Local Data Transformation with dbt and DuckDB

2025-04-04
Petrica Leuca
Using DuckDB in Streamlit
using DuckDB

Using DuckDB in Streamlit

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

Maximizing Your Delta Scan Performance in DuckDB

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

Preview: Amazon S3 Tables in DuckDB

2025-03-14
Sam Ansmink, Tom Ebergen, Gabor Szarnyas
The DuckDB Local UI
using DuckDB

The DuckDB Local UI

2025-03-12
Jeff Raymakers and Gabor Szarnyas
Parquet Bloom Filters in DuckDB
deep dive

Parquet Bloom Filters in DuckDB

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

Gems of DuckDB 1.2

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

Reading and Writing Google Sheets in DuckDB

2025-02-26
Alex Monahan and Archie Wood
Prefix Aliases in SQL
using DuckDB

Prefix Aliases in SQL

2025-02-25
Hannes Mühleisen
Planning AsOf Joins
deep dive

Planning AsOf Joins

2025-02-19
Richard Wesley
Flying Through Windows
deep dive

Flying Through Windows

2025-02-14
Richard Wesley
Catching up with Windowing
using DuckDB

Catching up with Windowing

2025-02-10
Richard Wesley
Announcing DuckDB 1.2.0
release

Announcing DuckDB 1.2.0

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

Query Engines: Gatekeepers of the Parquet File Format

2025-01-22
Laurens Kuiper
TPC-H SF300 on a Raspberry Pi
benchmark

TPC-H SF300 on a Raspberry Pi

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

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

2025-01-10
Alex Monahan
DuckDB Node Neo Client
using DuckDB

DuckDB Node Neo Client

2024-12-18
Jeff Raymakers
25 000 Stars on GitHub
release

25 000 Stars on GitHub

2024-12-16
The DuckDB team
The DuckDB Avro Extension
extensions

The DuckDB Avro Extension

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

DuckDB: Running TPC-H SF100 on Mobile Phones

2024-12-06
Gabor Szarnyas, Laurens Kuiper, Hannes Mühleisen
CSV Files: Dethroning Parquet as the Ultimate Storage File Format — or Not?
benchmark

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

2024-12-05
Pedro Holanda
DuckDB Tricks – Part 3
using DuckDB

DuckDB Tricks – Part 3

2024-11-29
Andra Ionescu and Gabor Szarnyas
Runtime-Extensible SQL Parsers Using PEG
deep dive

Runtime-Extensible SQL Parsers Using PEG

2024-11-22
Hannes Mühleisen and Mark Raasveldt
Optimizers: The Low-Key MVP
deep dive

Optimizers: The Low-Key MVP

2024-11-14
Tom Ebergen
Analytics-Optimized Concurrent Transactions
deep dive

Analytics-Optimized Concurrent Transactions

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

Fast Top N Aggregation and Filtering with DuckDB

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

What's New in the Vector Similarity Search Extension?

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

Driving CSV Performance: Benchmarking DuckDB with the NYC Taxi Dataset

2024-10-16
Pedro Holanda
DuckDB Tricks – Part 2
using DuckDB

DuckDB Tricks – Part 2

2024-10-11
Gabor Szarnyas
Analyzing Open Government Data with duckplyr
using DuckDB

Analyzing Open Government Data with duckplyr

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

DuckDB User Survey Analysis

2024-10-04
Gabor Szarnyas
DuckDB in Python in the Browser with Pyodide, PyScript, and JupyterLite
using DuckDB

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

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

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

2024-09-27
Alex Monahan
Changing Data with Confidence and ACID
using DuckDB

Changing Data with Confidence and ACID

2024-09-25
Hannes Mühleisen and Mark Raasveldt
Announcing DuckDB 1.1.0
release

Announcing DuckDB 1.1.0

2024-09-09
The DuckDB team
DuckDB Tricks – Part 1
using DuckDB

DuckDB Tricks – Part 1

2024-08-19
Gabor Szarnyas
Friendly Lists and Their Buddies, the Lambdas
deep dive

Friendly Lists and Their Buddies, the Lambdas

2024-08-08
Tania Bogatsch and Maia de Graaf
Memory Management in DuckDB
deep dive

Memory Management in DuckDB

2024-07-09
Mark Raasveldt
DuckDB Community Extensions
extensions

DuckDB Community Extensions

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

Benchmarking Ourselves over Time at DuckDB

2024-06-26
Alex Monahan
20 000 Stars on GitHub
release

20 000 Stars on GitHub

2024-06-22
The DuckDB Team
Command Line Data Processing: Using DuckDB as a Unix Tool
using DuckDB

Command Line Data Processing: Using DuckDB as a Unix Tool

2024-06-20
Gabor Szarnyas
Native Delta Lake Support in DuckDB
extensions

Native Delta Lake Support in DuckDB

2024-06-10
Sam Ansmink
Announcing DuckDB 1.0.0
release

Announcing DuckDB 1.0.0

2024-06-03
Mark Raasveldt and Hannes Mühleisen
Analyzing Railway Traffic in the Netherlands
using DuckDB

Analyzing Railway Traffic in the Netherlands

2024-05-31
Gabor Szarnyas
Access 150k+ Datasets from Hugging Face with DuckDB
extensions

Access 150k+ Datasets from Hugging Face with DuckDB

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

Vector Similarity Search in DuckDB

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

duckplyr: dplyr Powered by DuckDB

2024-04-02
Hannes Mühleisen
Placeholder
deep dive

No Memory? No Problem. External Aggregation in DuckDB

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

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

2024-03-26
Hannes Mühleisen
Placeholder
extensions

Dependency Management in DuckDB Extensions

2024-03-22
Sam Ansmink
SQL Gymnastics: Bending SQL into Flexible New Shapes
using DuckDB

SQL Gymnastics: Bending SQL into Flexible New Shapes

2024-03-01
Alex Monahan
Announcing DuckDB 0.10.0
release

Announcing DuckDB 0.10.0

2024-02-13
Mark Raasveldt and Hannes Mühleisen
Multi-Database Support in DuckDB
extensions

Multi-Database Support in DuckDB

2024-01-26
Mark Raasveldt
Extensions for DuckDB-Wasm
extensions

Extensions for DuckDB-Wasm

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

Updates to the H2O.ai db-benchmark!

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

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

2023-10-27
Pedro Holanda
Announcing DuckDB 0.9.0
release

Announcing DuckDB 0.9.0

2023-09-26
Mark Raasveldt and Hannes Mühleisen
DuckDB's AsOf Joins: Fuzzy Temporal Lookups
deep dive

DuckDB's AsOf Joins: Fuzzy Temporal Lookups

2023-09-15
Richard Wesley
Placeholder
using DuckDB

Even Friendlier SQL with DuckDB

2023-08-23
Alex Monahan
Placeholder
using DuckDB

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

2023-08-04
Pedro Holanda
Placeholder
using DuckDB

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

2023-07-07
Pedro Holanda, Thijs Bruineman and Phillip Cloud
Placeholder
using DuckDB

Correlated Subqueries in SQL

2023-05-26
Mark Raasveldt
Announcing DuckDB 0.8.0
release

Announcing DuckDB 0.8.0

2023-05-17
Mark Raasveldt and Hannes Mühleisen
10 000 Stars on GitHub
release

10 000 Stars on GitHub

2023-05-12
Mark Raasveldt and Hannes Mühleisen
Placeholder
extensions

PostGEESE? Introducing The DuckDB Spatial Extension

2023-04-28
Max Gabrielsson
Placeholder
using DuckDB

Introducing DuckDB for Swift

2023-04-21
Tristan Celder
Placeholder
benchmark

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

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

Shredding Deeply Nested JSON, One Vector at a Time

2023-03-03
Laurens Kuiper
Placeholder
using DuckDB

JupySQL Plotting with DuckDB

2023-02-24
Guest post by Eduardo Blancas
Placeholder
release

Announcing DuckDB 0.7.0

2023-02-13
Mark Raasveldt
Placeholder
release

Announcing DuckDB 0.6.0

2022-11-14
Mark Raasveldt
Placeholder
deep dive

Lightweight Compression in DuckDB

2022-10-28
Mark Raasveldt
Placeholder
using DuckDB

Modern Data Stack in a Box with DuckDB

2022-10-12
Guest post by Jacob Matson
Placeholder
extensions

Querying Postgres Tables Directly from DuckDB

2022-09-30
Hannes Mühleisen
Placeholder
deep dive

Persistent Storage of Adaptive Radix Trees in DuckDB

2022-07-27
Pedro Holanda
Placeholder
deep dive

Range Joins in DuckDB

2022-05-27
Richard Wesley
Placeholder
using DuckDB

Friendlier SQL with DuckDB

2022-05-04
Alex Monahan
Placeholder
deep dive

Parallel Grouped Aggregation in DuckDB

2022-03-07
Hannes Mühleisen and Mark Raasveldt
Placeholder
extensions

DuckDB Time Zones: Supporting Calendar Extensions

2022-01-06
Richard Wesley
Placeholder
using DuckDB

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

2021-12-03
Pedro Holanda and Jonathan Keane
Placeholder
using DuckDB

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

2021-11-26
Pedro Holanda
Placeholder
using DuckDB

Fast Moving Holistic Aggregates

2021-11-12
Richard Wesley
Placeholder
using DuckDB

DuckDB-Wasm: Efficient Analytical SQL in the Browser

2021-10-29
André Kohn and Dominik Moritz
Placeholder
using DuckDB

Windowing in DuckDB

2021-10-13
Richard Wesley
Placeholder
deep dive

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

2021-08-27
Laurens Kuiper
Placeholder
using DuckDB

Querying Parquet with Precision Using DuckDB

2021-06-25
Hannes Mühleisen and Mark Raasveldt
Placeholder
using DuckDB

Efficient SQL on Pandas with DuckDB

2021-05-14
Mark Raasveldt and Hannes Mühleisen
Placeholder
extensions

Testing Out DuckDB's Full Text Search Extension

2021-01-25
Laurens Kuiper