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.