DuckDB 2.0.0 LTS “Cinnamon Teal”
Points and comments are a snapshot, not live.
DuckDB 2.0.0 LTS adds a server protocol, async I/O, triggers, a VARIANT type, and a new SQL parser.
DuckDB 2.0.0 LTS, codenamed "Cinnamon Teal", introduces the Quack protocol for client-server operation, asynchronous I/O for Parquet and CSV files, a first-class VARIANT type with shredded execution, and triggers with FOR EACH ROW and FOR EACH STATEMENT support. The new PEG-based SQL parser becomes the default. Other features include agent mode for CLI, a revamped C API v2, and custom extension repositories. DuckDB 2.0 is an LTS release supported until October 2027.
What commenters are saying
Commenters are enthusiastic about DuckDB 2.0, particularly the new client-server architecture and async I/O. One user reports that 2.0 enables faster computation on high-core-count EC2 instances, scaling well up to 192 vCPUs, and that this allowed their record-linkage tool Splink to process 1 billion records in 10 minutes. Several note the simplicity of the server model versus Spark, with one recommending DuckDB over Spark for most workloads due to lower complexity. A developer clarifies that async I/O does support DuckDB's native storage format, contrary to an older blog post.