DuckDB 1.4.0 LTS
6 hours ago
- #release
- #database
- #open-source
- DuckDB 1.4.0, codenamed 'Andium', is released as an LTS version with one year of community support.
- New features include database encryption, MERGE statement support, and Iceberg writes.
- Database encryption uses AES-256 with GCM mode, covering main files, WAL, and temporary files.
- MERGE INTO statement allows for upsert functionality without requiring primary keys.
- Iceberg writes are now supported, enabling data transfer between DuckDB and Iceberg.
- CLI improvements include an ETA feature for progress estimation using a Kalman filter.
- New FILL window function interpolates missing values in ordered windows.
- Teradata Connector introduced, with a dedicated blog post forthcoming.
- Performance optimizations include a reworked sorting implementation and materialized CTEs by default.
- MacOS binaries now come with notarization, improving download and usage experience.
- Python client moved to its own repository, duckdb/duckdb-python.