Updated
Updated · InfoWorld · Aug 18
DuckDB to Launch 2.0 This Fall With Client/Server Mode and Up to 40x Faster Queries
Updated
Updated · InfoWorld · Aug 18

DuckDB to Launch 2.0 This Fall With Client/Server Mode and Up to 40x Faster Queries

3 articles · Updated · InfoWorld · Aug 18

Summary

  • Nightly previews of DuckDB 2.0 are already available ahead of a planned fall release, bringing a major shift from its single-process roots to a multi-client client/server mode.
  • Quack, previously an experimental extension, is being promoted to stable in 2.0, enabling that server setup and making remote queries to databases such as PostgreSQL and MySQL easier.
  • An asynchronous data engine lets I/O and query processing scale separately, helping deliver speedups of up to 40x depending on workload; a new storage format also opens wide tables and heavily indexed databases faster.
  • A stable C API replaces the extension ecosystem's unstable C++ interface, so extensions can be built from a single header file and avoid recompilation for each new DuckDB release.
  • DuckDB said no release-candidate or final date is set yet, but the 2.0 overhaul also includes a rewritten SQL parser and work on custom extension repositories.

Insights

Will DuckDB 2.0's leap into server mode compromise the lightweight, embedded identity that made it famous?
Can the new asynchronous data engine truly deliver 40x speedups without silently devouring massive amounts of RAM?
How will the strict new lambda syntax rules disrupt existing analytical pipelines when the update drops this fall?