| A Preview of DuckDB v2.0(duckdb.org) | |
| 703 points by ibotty 4 days ago | 126 comments | |
tl;dr: DuckDB v2.0 ("Cyanoptera"), shipping this fall, adds client/server mode via the Quack extension and CONNECT statement (with query pushdown to Postgres/MySQL), first-class VARIANT type, SQL triggers, and asynchronous I/O for much faster object-store reads. Under the hood it introduces a new PEG-based SQL parser, a new default storage format, drops ICU in favor of a native 45KB timezone/collation implementation, and expands the stable C API so extensions built once keep working across versions. Recursive CTE queries benchmark ~40× faster than v1.5. | |
HN Discussion:
| |