DuckDB 2.0 Turns the In-Process Database into a Server
A Preview of DuckDB v2.0
DuckDB v2.0, code-named Cyanoptera, introduces a client/server mode via the Quack extension and the new CONNECT statement, allowing any DuckDB process to serve databases over the network. The release also brings triggers, a first-class VARIANT type, asynchronous I/O, a new SQL parser, and a new storage format. Performance gains are dramatic: a recursive query benchmark runs 40× faster than v1.5.4.
Where last year was the year of the lakehouse, this release kicks off the year of DuckDB as a server.