DBMS release Duckdb 1.2.0 has been published, focusing on the implementation of analytical queries with a conceptual resemblance to SQLite. Duckdb combines properties of SQLite such as compactness, built-in library connection, storing databases in a single file, and a CLI interface with optimizations for executing analytical queries that cover a significant portion of stored data. The project code is written in C++ and is distributed under the MIT license. It provides an expanded dialect of the SQL language, offering enhanced capabilities for processing complex queries.
Duckdb supports complex types, correlating subqueries, simultaneous execution of multiple queries, direct querying from CSV files, and imports from Parquet. The project utilizes components from SQLite, PostgreSQL, MonetDB, and features its own queries optimizer, window functions implementation, and vectorized execution engine to process large datasets efficiently.
In the new version of Duckdb:
- Support for new compression methods has been added, allowing users to maintain compatibility with older database versions. A new feature allows linking databases to specific version numbers and converting between different formats.
- Support for the SQL command “Alter Table … Add Primary Key” has been included to add primary keys to existing tables.
- Some features have been removed.