Announcing DuckDB 1.4.0
The DuckDB team · 7 min
TL;DR: We're releasing DuckDB version 1.4.0, codenamed “Andium”. This is an LTS release with one year of community support, and it packs several new features including database encryption, the MERGE statement and Iceberg writes.
We are proud to release DuckDB v1.4.0, named “Andium” after the Andean teal (Anas andium), which lives in the Andean highlands of Colombia, Venezuela and Ecuador.
In this blog post, we cover the most important updates for this release around support, features and extensions. DuckDB is moving rather quickly, and we could cover only a small fraction of the changes in this release. For the complete release notes, see the release page on GitHub.
To install the new version, please visit the installation page. Note that it can take a few days to release some client libraries (e.g., Go, R, Java) due to the extra changes and review rounds required.
We are delighted to see that DuckDB is used regularly in production environments and realize that such deployments often come with a requirement for long-term maintenance. In the past, we would automatically deprecate old DuckDB versions whenever the newer version was released. But we’re changing this today.
Starting with this release, every other DuckDB version is going to be a Long Term Support (LTS) edition. For LTS DuckDB versions, community support will last a year after the release (for now). DuckDB Labs is also starting to offer support for older LTS versions after their community support has expired.
Click to see the end-of-life (EOL) dates for DuckDB releases. Version Codename End of community support 0.* 2024-06-03 1.0.* Nivis 2024-09-09 1.1.* Eatoni 2025-02-05 1.2.* Histrionicus 2025-05-21 1.3.* Ossivalis 2025-09-16 1.4.* LTS Andium 2026-09-16
Being able to encrypt DuckDB database files has been a long-standing feature request. Starting with this release, DuckDB supports encryption of its files. Encryption keys are given using the ENCRYPTION_KEY parameter to ATTACH , like so:
... continue reading