Mon Sep 09 15:33:14 UTC 2024: ## DuckDB 1.1.0 “Eatoni” Released: Faster Queries, Easier Extensions, and Spatial Data Support

**[City, State] – [Date]** The DuckDB team is excited to announce the release of DuckDB 1.1.0, codenamed “Eatoni.” This release brings numerous enhancements and new features designed to improve query performance, simplify extension development, and introduce support for spatial data.

**Key Features:**

* **Performance Boost:** DuckDB 1.1.0 boasts significant performance improvements, including:
* **Optimized Join Operations:** The join optimizer now automatically creates filters for larger tables, drastically reducing query execution times.
* **Parallel Streaming Results:** Query results can now be streamed in parallel, leveraging all available threads for faster data retrieval.
* **Improved Window Function Performance:** Window function modifiers (DISTINCT and FILTER) now operate in streaming mode, significantly reducing execution time for large intermediate results.
* **Faster Foreign Key Operations:** Enhanced index structure dramatically improves insertion and deletion performance for foreign keys.
* **Enhanced Extension Development:**
* **Community Extensions:** New tools and APIs make it easier to build and distribute community extensions for DuckDB.
* **Stable API:** Extensions can now be built against a stable API, ensuring compatibility across different DuckDB versions.
* **Spatial Data Support:**
* **GeoParquet Integration:** DuckDB now supports reading GeoParquet files, automatically converting geometry columns to the GEOMETRY type.
* **R-Tree Spatial Indexes:** Support for R-Tree indexes enables efficient spatial queries, allowing fast retrieval of geometries intersecting specific regions.

**Additional Enhancements:**

* **IEEE-754 Semantics:** Division by zero now returns “inf” according to the IEEE-754 floating point standard.
* **Scalar Subquery Error Handling:** Scalar subqueries now raise an error if they return multiple values.
* **SQL Variables:** New support for defining and using variables in SQL queries.
* **COLUMNS Expression:** Improved dynamic SQL capabilities with the COLUMNS expression, allowing for more flexible column selection.
* **CTE Materialization:** DuckDB automatically decides whether to materialize common table expressions (CTEs) for better performance.

The release notes and installation guide are available on the DuckDB website: [Link to Website]. This release marks another significant step forward for DuckDB, and the team looks forward to continued contributions from the vibrant community.

Read More