This preview release of DuckDB is named "Jubata" after the Australian Wood Duck (Chenonetta jubata). 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
- #1231: Full Text Search extension
- #1309: Filter Clause for Aggregates
- #1195:
SAMPLEOperator - #1244:
SHOWselect queries - #1301:
CHRandASCIIfunctions & #1252: AddGAMMAandLGAMMAfunctions
Engine
- #1211: (Mostly) Lock-Free Buffer Manager
- #1325: Unsigned Integer Types Support
- #1229: Filter Pull Up Optimizer
- #1296: Optimizer that removes redundant
DELIM_GETandDELIM_JOINoperators - #1219:
DATE,TIMEandTIMESTAMPrework: move to epoch format & microsecond support
Clients
- #1287 and #1275: Improving JDBC compatibility
- #1260: Rework client API and prepared statements, and improve DuckDB -> Pandas conversion
- #1230: Add support for parallel scanning of pandas data frames
- #1256: JNI appender
- #1209: Write shell history to file when added to allow crash recovery, and fix crash when .importing file with invalid
- #1204: Add support for blobs to the R API and #1202: Add blob support to the python api
Parquet
- #1314: Refactor and nested types support for Parquet Reader