tspof on Nostr: DuckDB has released version 2.0.0 LTS, codenamed "Cinnamon Teal," marking its largest ...
DuckDB has released version 2.0.0 LTS, codenamed "Cinnamon Teal," marking its largest feature upgrade with nearly 20,000 commits since version 1.5. Key enhancements include a refined Quack protocol for client-server setups, asynchronous I/O for parallel reads from files like Parquet and CSV, and the full integration of a performant VARIANT data type for semi-structured data. The release introduces agent mode in the CLI to optimize output for coding assistants, an extensible PEG-based SQL parser replacing the legacy one, a revamped C API, and support for triggers enabling features like audit tables and incremental materialized views. DuckDB 2.0 requires a C++17 compiler and has deprecated the ICU library, implementing timezone and collation features natively. It also drops support for the single-arrow lambda syntax and begins phasing out the amalgamation build and OSX AMD64 platform support. The new version is a long-term support release with maintenance until at least October 2027. Users are advised to test 2.0 before migrating production environments due to storage format changes incompatible with earlier versions. Detailed release notes and migration guides are available on GitHub.
Source:
https://duckdb.org/2026/10/21/announcing-duckdb-200 
#news_en #database #opensource #softwareupdate #duckdb_org
Published at
2026-10-21 17:16:00 UTCEvent JSON
{
"id": "c16f0b2f6d4689031257a3cb02a8463537f04cc7f95bd05f355e7b62d213581c",
"pubkey": "616d6bbeb8c1f02b67271e8039aeb0eb1e83e1c9ec5cac4655002ae25f10bb8f",
"created_at": 1792602960,
"kind": 1,
"tags": [
[
"t",
"cosmoport.org"
],
[
"t",
"news_en"
],
[
"t",
"database"
],
[
"t",
"opensource"
],
[
"t",
"softwareupdate"
],
[
"t",
"duckdb_org"
]
],
"content": "DuckDB has released version 2.0.0 LTS, codenamed \"Cinnamon Teal,\" marking its largest feature upgrade with nearly 20,000 commits since version 1.5. Key enhancements include a refined Quack protocol for client-server setups, asynchronous I/O for parallel reads from files like Parquet and CSV, and the full integration of a performant VARIANT data type for semi-structured data. The release introduces agent mode in the CLI to optimize output for coding assistants, an extensible PEG-based SQL parser replacing the legacy one, a revamped C API, and support for triggers enabling features like audit tables and incremental materialized views. DuckDB 2.0 requires a C++17 compiler and has deprecated the ICU library, implementing timezone and collation features natively. It also drops support for the single-arrow lambda syntax and begins phasing out the amalgamation build and OSX AMD64 platform support. The new version is a long-term support release with maintenance until at least October 2027. Users are advised to test 2.0 before migrating production environments due to storage format changes incompatible with earlier versions. Detailed release notes and migration guides are available on GitHub.\n\nSource: https://duckdb.org/2026/10/21/announcing-duckdb-200\n\nhttps://duckdb.org/images/blog/thumbs/duckdb-release-2-0-0.png\n\n#news_en #database #opensource #softwareupdate #duckdb_org",
"sig": "c198635c071228cde5f7cf482b1efac1e0e5407d1d51781f9f2503fd489dd464100a31970dce3c65aece4da26c87df83458f2c88b08056263c504c180cb0a95a"
}