DuckDB

DuckDB v2.0 replaces its PostgreSQL-derived SQL parser with a PEG-based parser that is easier to evolve and can be extended at runtime.

The next major version of the self-contained analytics database will offer async I/O, a new SQL parser, and much more.

DuckDB-native dataframes for Elixir, with distributed execution on the BEAM.

DuckDB v2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.

Learn about our experiment with DuckDB MySQL storage engine at scale factor 500 and its impressive query execution times.

DuckDB just reached 40000 stars on GitHub! Here's what happened since the last 10000-star milestone.

Nine months of telemetry from Query.Farm

A well-written, FAST data science database for your laptop.

Starting with v2.0, scheduled for fall 2026, DuckDB will support asynchronous reads of Parquet and CSV files. This can significantly speed up queries when synchronous I/O does not saturate the available bandwidth, as is typical in EC2/S3 compute-storage s

You have a large Parquet file and an API that has to return its contents, but responses have a size ceiling, so the caller pages through it. LIMIT/OFFSET is the obvious way to write that and it is the wrong one. I measured file_row_number against it: 2.53