This preview release of DuckDB is named "Serrator" after the Red-breasted merganser (Mergus serrator). Binary builds are listed below. Feedback is very welcome.

Note: This release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

Major changes:

SQL:

• #1179: Interval Cleanup & Extended INTERVAL Syntax
• #1147: Add exact MEDIAN and QUANTILE functions
• #1129: Support scalar functions with CREATE FUNCTION
• #1137: Add support for (NOT) ILIKE, and optimize certain types of LIKE expressions

Engine

• #1160: Perfect Aggregate Hash Tables
• #1133: Statistics Rework & Statistics Propagation
• #1144: Common Aggregate Optimizer, #1143: CSE Optimizer and #1135: Optimizing expressions in grouping keys
• #1138: Use predication in filters
• #1071: Removing string null termination requirement

Clients

• #1112: Add DuckDB node.js API
• #1168: Add support for Pandas category types
• #1181: Extend DuckDB::LibraryVersion() to output dev version in format 0.2.3-devXXX & #1176: Python binding: Add module attributes for introspecting DuckDB version

Parquet Reader:

• #1183: Filter pushdown for Parquet reader
• #1167: Exporting Parquet statistics to DuckDB
• #1162: Add support for compression codec in Parquet writer & #1163: Add ZSTD Compression Code and add ZSTD codec as option for Parquet export
• #1103: Add object cache and Parquet metadata cache

This is a preview release of DuckDB.
Starting from this release, releases get named as well. Names are chosen from species of ducks (of course). We start with "Clypeata".

Note: This release introduces a backwards-incompatible change to the on-disk storage format. We suggest you use the EXPORT DATABASE command with the old version followed by IMPORT DATABASE with the new version to migrate your data. See the documentation for details.

Binary builds are listed below. Feedback is very welcome. Major changes:

SQL

• #1057: Add PRAGMA for enabling/disabling optimizer & extend output for query graph
• #1048: Allow CTEs in subqueries (including CTEs themselves) and #987: Allow CTEs in CREATE VIEW statements
• #1046: Prettify Explain/Query Profiler output
• #1037: Support FROM clauses in UPDATE statements
• #1006: STRING_SPLIT and STRING_SPLIT_REGEX SQL functions
• #1000: Implement MD5 function
• #936: Add GLOB support to Parquet & CSV readers
• #899: Table functions information_schema_schemata() and information_schema_tables() and #903: Add table function information_schema_columns()

Engine

• #984: Parallel grouped aggregations and #1045: Some performance fixes for aggregate hash table
• #1008: Index Join
• #991: Local Storage Rework: Per-morsel version info and flush intermediate chunks to the base tables
• #906: Parallel scanning of single Parquet files and #982: ZSTD Support in Parquet library
• #883: Unify Table Scans with Table Functions
• #873: TPC-H Extension
• #884: Remove NFC-normalization requirement for all data and add COLLATE NFC

Client

• #1001: Dynamic Syntax Highlighting in Shell
• #933: Upgrade shell.c to 3330000
• #918: Add in support for Python datetime types in bindings
• #950: Support dates and times output into arrow
• #893: Support for Arrow NULL columns

This is a preview release of DuckDB. Binary builds are listed below. Feedback is very welcome. Major changes:

Engine

• #770: Enable Inter-Pipeline Parallelism
• #835: Type system updates with #779: INTERVAL Type, #858: Fixed-precision DECIMAL types & #819: HUGEINT type
• #790: Parquet write support

API

• #866: Initial Arrow support
• #809: Aggregate UDF support with #843: Generic CreateAggregateFunction() & #752: CreateVectorizedFunction() using only template parameters

SQL

• #824: strftime and strptime
• #858: EXPORT DATABASE and IMPORT DATABASE
• #832: read_csv(_auto) improvements: optional parameters, configurable sample size, line number info

This is a preview release of DuckDB. Binary builds are listed below. Feedback is very welcome.

SQL:

• #730: FULL OUTER JOIN Support
• #732: Support for NULLS FIRST/NULLS LAST
• #698: Add implementation of the LEAST/GREATEST functions
• #772: Implement TRIM function and add optional second parameter to RTRIM/LTRIM/TRIM
• #771: Extended Regex Options

Clients:

• Python: #720: Making Pandas optional and add support for PyPy
• C++: #712: C++ UDF API

This is a preview release of DuckDB. Binary are listed below. Feedback is very welcome. Major changes:
New website woo-ho!

Engine

• #653: Parquet reader integration

SQL

• #685: Case insensitive binding of column names
• #662: add EPOCH_MS function and test cases

Clients

• #681: JDBC Read-only mode for and #677 duplicate()` method to allow multiple connections to same database

This is a preview release of DuckDB. Feedback is very welcome.

SQL

• SQL functions IF and IFNULL #644
• SQL string functions LEFT #620 and RIGHT #631
• #641: BLOB type support
• #640: LIKE escape support

Clients

• #627: Insertion support for Python relation API

This is the sixth preview release of DuckDB. Feedback is very welcome.
Binary builds are available as well.

SQL

• Add / remove columns, change default values & column type #612
• Collation support
• CSV sniffer READ_CSV_AUTO for dialect, data type and header detection #582
• SHOW & DESCRIBE Tables #501
• String function CONTAINS #488
• String functions LPAD / RPAD, LTRIM / RTRIM, REPEAT, REPLACE & UNICODE #597
• Bit functions BIT_LENGTH, BIT_COUNT, BIT_AND, BIT_OR, BIT_XOR & BIT_AGG #608

Engine

• LIKE optimization rules #559
• Adaptive filters in table scans #574
• ICU Extension for extended Collations & Extension Support #594
• Extended zone map support in scans #551
• Disallow NaN/INF in the system #541
• Use UTF Grapheme Cluster Breakers in Reverse and Shell #570

Clients

• Relation API for C++ #509 and Python #598
• Java (TM) JDBC (R) Client for DuckDB #492 #520 #550

This is the fifth preview release of DuckDB. Feedback is very welcome.
Binary builds can be found here: http://download.duckdb.org/alias/v0.1.6/

SQL

• #455 Table renames ALTER TABLE tbl RENAME TO tbl2
• #457 Nested list type can be created using LIST aggregation and unpacked with the new UNNEST operator
• #463 INSTR string function, #477 PREFIX string function, #480 SUFFIX string function

Engine

• #442 Optimized casting performance to strings
• #444 Variable return types for table-producing functions
• #453 Rework aggregate function interface
• #474 Selection vector rework
• #478 UTF8 NFC normalization of all incoming strings
• #482 Skipping table segments during scan based on min/max indices

Python client

• #451 date / datetime support
• #467 description field for cursor
• #473 Adding read_only flag to connect
• #481 Rewrite of Python API using pybind11

R client

• #468 Support for prepared statements in R client
• #479 Adding automatic CSV to table function read_csv_duckdb
• #483 Direct scan operator for R data.frame objects

This is the fourth preview release of DuckDB. Feedback is very welcome. Note: The v0.1.4 version was skipped because of a Python packaging issue.

Binary builds can be found here:
http://download.duckdb.org/rev/59f8907b5d89268c158ae1774d77d6314a5c075f/

Major changes:

• #409 Vector Overhaul
• #423 Remove individual vector cardinalities
• #418 DATE_TRUNC SQL function
• #424 REVERSE SQL function
• #416 Support for SELECT table.* FROM table
• #414 STRUCT types in query execution
• #431 Changed internal string representation
• #433 Rename internal type index_t to idx_t
• #439 Support for temporary structures in read-only mode
• #440 Builds on Solaris & OpenBSD

Note: This release contains a bug in the Python API that leads to crashes when fetching strings to NumPy/Pandas #447

This is the third preview release of DuckDB. Feedback is very welcome.
Binary builds can be found here:
http://download.duckdb.org/rev/59f8907b5d89268c158ae1774d77d6314a5c075f/

Major changes:

• #388 Major updates to shell
• #390 Unused Column & Column Lifetime Optimizers
• #402 String and compound keys in indices/primary keys
• #406 Adaptive reordering of filter expressions