Skip to content
Hacker News front page

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: The DuckDB v2.0 preview adds client-server mode and a CONNECT statement that pushes SQL straight to PostgreSQL and MySQL, a shift from single-machine analytics tool toward shared database.

Read the original ↗Export Markdown