DuckDB v0.2.4stable Released Feb 02, 2021
Impact Score: 5/10

DuckDB: 0.2.4 Preview Release "Jubata"

Source available โ€” automated, not human-reviewed

Component: duckdb ยท Channel: stable. Automated analysis, not a compatibility certification. How this works.

Analysis updated: 2026-11-01.

Compatibility not verified โ€” check source notes
๐Ÿ“„ .MD
โšก Executive Summary (TL;DR)

DuckDB v0.2.4. Source highlight: This preview release of DuckDB is named "Jubata" after the Australian Wood Duck (Chenonetta jubata). Binary builds are listed below. Feedback is very welcome.

Who Does This Impact? (Role-Based Analysis)

๐Ÿ’ป Software Engineers & Devs

Check the source notes against the package and APIs you use before upgrading.

๐Ÿ“Š Product & Engineering Leads

Use the documented changes to assess relevance to your product; release frequency alone is not a quality measure.

โš™๏ธ DevOps & Security

Verify the target version, runtime requirements and rollback procedure in the official documentation.

โœจ New Features & Capabilities (3)

  • #1301: `CHR` and `ASCII` functions & #1252: Add `GAMMA` and `LGAMMA` functions
  • #1230: Add support for parallel scanning of pandas data frames
  • #1204: Add support for blobs to the R API and #1202: Add blob support to the python api

โšก Performance & Enhancements (2)

  • #1287 and #1275: Improving JDBC compatibility
  • #1260: Rework client API and prepared statements, and improve DuckDB -> Pandas conversion

๐Ÿ”ง Bug Fixes & Patches (1)

  • #1209: Write shell history to file when added to allow crash recovery, and fix crash when .importing file with invalid
๐Ÿ“„ View Raw Release Notes (Original Developer Log)
This preview release of DuckDB is named "Jubata" after the [Australian Wood Duck](https://en.wikipedia.org/wiki/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: `SAMPLE` Operator - #1244: `SHOW` select queries - #1301: `CHR` and `ASCII` functions & #1252: Add `GAMMA` and `LGAMMA` functions Engine - #1211: (Mostly) Lock-Free Buffer Manager - #1325: Unsigned Integer Types Support - #1229: Filter Pull Up Optimizer - #1296: Optimizer that removes redundant `DELIM_GET` and `DELIM_JOIN` operators - #1219: `DATE`, `TIME` and `TIMESTAMP` rework: 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