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:
  • Enthusiastic users excited about Quack client/server mode for their existing DuckDB workflows
  • General appreciation for DuckDB as a transformative, portable tool for data processing
  • Questions about suitability for specific concurrent multi-client use cases
  • Skepticism about the high commit velocity possibly being AI-driven
  • ~Cautious interest from users of competing databases considering revisiting DuckDB