Hacker News front pageAug 17, 2026, 21:46 UTC+8

A Preview of DuckDB v2.0: From In-Process Analytics to Server Mode

A Preview of DuckDB v2.0

DuckDB v2.0 ships this fall, and the headline is client/server support. The Quack extension and the new CONNECT statement let any DuckDB process serve databases over the network, while another DuckDB can attach and push queries to it. CONNECT also pushes SQL directly to PostgreSQL and MySQL instead of pulling tables over the wire. The VARIANT type becomes a first-class citizen, auto-detecting common structure in semi-structured data for fast compressed execution—ideal for real-time log ingestion. The release also adds full trigger support, asynchronous I/O, a new SQL parser, and a new default storage format, built from over 10,000 commits.

Why it matters: DuckDB v2.0 is one of the most significant database releases to watch this fall. The client/server mode fills its biggest deployment gap, while VARIANT and async I/O directly address semi-structured data and latency-sensitive workloads. Score stays at 78 because this is a prev...

Read the original ↗Export Markdown

Take

The reason to click: DuckDB is no longer just an embedded analytics library. v2.0 ships the Quack extension and a CONNECT statement that lets any DuckDB process serve databases over the network, while another DuckDB can attach and push queries to it. The more practical bit is CONNECT pushing SQL directly to PostgreSQL and MySQL—no more pulling entire tables over the wire, which saves real pain for cross-database analysis.

The VARIANT type becomes a first-class citizen, auto-detecting common structure in semi-structured data for fast compressed execution, ideal for real-time log ingestion. Add triggers, async I/O, a new SQL parser, and a new default storage format, and you're looking at over 10,000 commits of change.

I'd discount the server hype slightly: client/server mode just hit stable, and the post itself notes they're still beefing up metrics, logs, and observability. If you're thinking of swapping it in for PostgreSQL today, wait for the community to fill out the operational tooling around it.

Source: Hacker News front page · duckdb.org
Published: Aug 17, 2026, 21:46 UTC+8 · Aug 17, 2026