Gems of DuckDB 2.0.0
The DuckDB 2.0.0 Python client now includes an appender for efficient bulk data insertion. This allows users to collect rows and write them in a single operation.
Also onPaydays(Pay schedule)
The DuckDB 2.0.0 Python client now includes an appender for efficient bulk data insertion. This allows users to collect rows and write them in a single operation.
DuckDB 2.0.0 is a new long-term support release focused on new features. It includes support until at least October 2027 and introduces various breaking changes.
DuckDB introduced Agent Mode in its CLI to optimize query output for LLMs and AI agents. By removing visual borders and column padding, Agent Mode reduces token consumption by around 60% during automated queries.
DuckDB version 1.5.6 is now available, featuring bug fixes, performance improvements, and security patches. The release addresses issues with Parquet handling, window functions, and integer literal processing.
dbt v2 now ships with a native DuckDB adapter built on its Rust Fusion engine, enabling users to execute local SQL model transformations against DuckDB out of the box.
DuckDB released `duckdb-skills`, a plugin for Claude Code that allows AI tools to query local files, web URLs, and Iceberg tables directly via the DuckDB CLI.
DuckDB announced a feature freeze and released preview builds for DuckDB v2.0-alpha Cyanoptera across command-line and Python clients.
The upcoming DuckDB v2.0 introduces physical execution changes to run recursive CTEs faster. By explicitly assigning scopes and reusing pipeline executors, the engine avoids repeatedly paying for pipeline scheduling and operator setup across iterations.
Version 1.5.3.0 of the DuckDB Java driver introduces an alternative to the row-by-row JDBC ResultSet API, allowing applications to retrieve query results in columnar chunks. This update avoids the overhead of slicing columnar data into rows and reassembling it.
DuckDB v2.0 will completely replace its SQL parser. The update aims to improve how the database tokenizes, parses, and transforms SQL queries into internal abstract syntax trees.
The upcoming DuckDB v2.0 release will add four new scalar functions to its JSON extension: json_merge_patch_diff, json_deep_merge, json_normalize, and json_strip_nulls. These functions allow data pipelines to reconcile state and handle JSON updates directly in SQL.
This is a bug fix release for various issues discovered after we released v1.5.4. backport the out-of-bounds security fixes made in #23100 Remove checked_array_iterator from fmt dep (1.4) Remove checked_array_iterator from fmt dep (1.4) [Dev] Add LLDB scripts to help with debugging Add support for test config extending bump iceberg again Correctly get typed...
This is a bug fix release for various issues discovered after we released v1.4.4. Please also refer to the announcement blog post: https://duckdb.org/2026/06/17/announcing-duckdb-145.html Internal #7212 : FILL Empty Chunk Secret Manager: Ensure secrets are created exactly once Use FileSystem APIs in QueryProfiler::Write Fix escape handling in AddEscapes...
This is a bugfix release for various issues discovered after we released v1.5.2. Please also refer to the announcement blog post: https://duckdb.org/2026/05/20/announcing-duckdb-153 Use DB serialization compatibility for json_serialize_sql DuckLake Bump fix: resolve current catalog in ADBC Ingest to avoid temp table shadowing Fix TIMESTAMPFORMAT being...
This is a bug fix release for various issues discovered after we released v1.5.1 Backport various race condition fixes to v1.4 bump ref to azure for v1.4.4 (rebuild) Internal #7584 : AsOf Simple Joins Do not write ccache to github cache for v1.4-andium Disable extension caching for v1.4 to free github cache space Disable save_cache for v1.4-andium Backport...
This is a bug fix release for various issues discovered after we released v1.5.0. Please also refer to the announcement blog post: https://duckdb.org/2026/03/23/announcing-duckdb-151 [Extensions] Preserve require order in InterpretedBenchmark CLI: Make help entry uppercase Restore view's bind_state when binding fails [Regression v1.5] Fix INTERNAL Error in...
This release of DuckDB is named "Variegata" after the paradise shelduck Tadorna Variegata, also known as the paradise duck, a species of Shelduck (a group of goose-like ducks), endemic to New Zealand.
This is a bug fix release for various issues discovered after we released 1.4.3. Please excuse the erroneous release earlier. Cast Fix: Correctly handle negative exponent with a number with a decimal in VARCHAR -> INTEGER cast [Storage] Fix NULL filter check for constant segments fixing staged upload for install.duckdb.org - hopefully Remove undefined loop...
This is a bug fix release for various issues discovered after we released 1.4.2. implement proper equals for table functions Fix behavior for HAVING clause without a GROUP BY Remove httpfs patches and bump Correctly use a lock when accessing the EncryptionKeyManager Bump iceberg to now default available extension Extract all column bindings of json each...
This is a bug fix release for various issues discovered after we released 1.4.1. PR #19716 addresses the issues raised in CVE-2025-64429 . Users of the DuckDB encryption feature are encouraged to update.
| Release-notes page | Site | Feed |
|---|---|---|
| Changelog r.duckdb.org | r.duckdb.org | None |