duckdb 0.2.5

0.2.5 Preview Release "Falcata"

on Python PyPI

This preview release of DuckDB is named "Falcata" after the Falcated Duck (Mareca falcata). 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:

Engine

• #1356: Incremental Checkpointing
• #1422: Optimize Top N Implementation

SQL

• #1406, #1372, #1387: Many, many new aggregate functions
• #1460: QUANTILE aggregate variant that takes a list of quantiles & #1346: Approximate Quantiles
• #1461: JACCARD, #1441 LEVENSHTEIN & HAMMING distance scalar function
• #1370: FACTORIAL scalar function and ! postfix operator
• #1363: IS (NOT) DISTINCT FROM
• #1385: LIST_EXTRACT to get a single element from a list
• #1361: Aliases in the HAVING clause (fixes issue #1358)
• #1355: Limit clause with non constant values

APIs:

• #1430 & #1424: DuckDB WASM builds
• #1419: Exporting the appender api to C
• #1408: Add blob support to C API
• #1432, #1459 & #1456: Progress Bar
• #1440: Detailed profiler.