A Preview of DuckDB v2.0
DuckDB 2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.
DuckDB is a SQL OLAP database management system. Simple, feature-rich, fast & open source.
Visit duckdb.org → On Hacker News Jun 2021 – Oct 2026
Databases & Data 26Software Engineering 16Web & Frontend 2Systems & Performance 2Security & Privacy 1Open Source 1
DuckDB 2.0 is coming this fall. In this post, we preview its headline features: DuckDB as a server, triggers, the VARIANT type, asynchronous I/O, a new SQL parser, a new storage format, and much more.
The DuckDB team is happy to announce that today we're releasing DuckDB version 2.0.0 LTS, codenamed “Cinnamon Teal” (Spatula cyanoptera). This is our biggest feature release so far, and it ships a polished version of the Quack protocol, asynchronous I/O, a first-class VARIANT type, agent mode, triggers, an extensible…
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
We recently improved DuckDB's JSON extension so JSON files can be directly queried as if they were tables.
DuckDB can attach MySQL, Postgres, and SQLite databases in addition to databases stored in its own format. This allows data to be read into DuckDB and moved between these systems in a convenient manner.
The DuckDB team is happy to announce that today we're releasing DuckDB version 1.1.0, codenamed “Eatoni”.
The H2O.ai db-benchmark has been updated with new results. In addition, the AWS EC2 instance used for benchmarking has been changed to a c6id.metal for improved repeatability and fairness across libraries. DuckDB is the fastest library for both join and group by queries at almost every data size.
The DuckDB team is happy to announce the latest DuckDB release (0.8.0). This release is named “Fulvigula” after the Mottled Duck (Anas Fulvigula) native to the Gulf of Mexico. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many…
The DuckDB team is very happy to announce that today we’re releasing DuckDB version 1.0.0, codename “Snow Duck” (anas nivis).
The DuckDB team is happy to announce the latest DuckDB release (0.9.0). This release is named Undulata after the Yellow-billed duck native to Africa. To install the new version, please visit the installation guide. The full release notes can be found on GitHub. There have been too many changes to discuss them each in…
We are releasing DuckDB version 1.5.2, a patch release with bugfixes, performance improvements, and support for the DuckLake 1.0 lakehouse format.
DuckDB can now directly query tables stored in PostgreSQL and speed up complex analytical queries without duplicating data.
DuckDB, a free and open source analytical data management system, can run SQL queries directly on Parquet files and automatically take advantage of the advanced features of the Parquet format.
The query optimizer is an important part of any analytical database system as it provides considerable performance improvements compared to hand-optimized queries, even as the state of your data changes.
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
The DuckDB team is happy to announce the latest DuckDB version (0.7.0) has been released. This release of DuckDB is named “Labradorius” after the Labrador Duck (Camptorhynchus labradorius) that was native to North America. To install the new version, please visit the installation guide. The full release notes can be…