A Preview of DuckDB v2.0

DuckDB v2.0 is set to launch this fall, offering several headline features. The new server mode, triggers, variant type, asynchronous I/O, a revamped SQL parser, a new storage format, and additional improvements are part of this major release. DuckDB v2.0 will be named "Cyanoptera," after the cinnamon teal, a striking duck native to western Americas.

Since v1.5, DuckDB has undergone over 10,000 commits, with this version marking a significant step towards the database as a server concept. This release is a feature-driven update, built upon a robust foundation and submitting new SQL parser, default storage format, and a revised C API. The inclusion of features like triggers, VARIANT type, asynchronous I/O, and a new SQL parser showcases the database's adaptability and performance enhancements.