This release makes binary-only changes. Once installed and loaded, any existing use of chdb and chdb_hook v0.1 will get the v0.1.2 benefits without needing to ALTER EXTENSION UPDATE.
⚡ Improvements
- Added mappings for additional chDB data types: * The Interval family maps to Postgres interval or bigint * A Map maps to a two-dimensional array of key/value pairs or a custom two-field composite type * A Tuple maps to an array of its values or composite type * An unflattened Nested column maps to a two-dimensional array or composite type array * All LowCardinality types now map to their Postgres equivalents, not just
LowCardinality(String)* Parameterized JSON (JSON(...)) now maps to jsonb or json - Added the
encoding_checkoption toCOPY. Valid values arefail,replace,remove, andtruncate. See the COPY docs for details (#96). - Linking to libchdb v26.9.0 fixes the CVS format with NULL geometric types.
🐞 Bug Fixes
- Reject
COPY FROMa URL with aWHEREclause, preventing imports from silently ignoring row filters (#86). - Fix
CREATE TABLEinference to usetext[]forTupleandtext[][]forMapandNestedinstead oftext. Reuse source types fromDESCRIBEwhen loading rows, keepingNestedfields in one column (#89). - The
installtarget no longer installslibchdb.awhen usingLIBCHDB_BUILD=static. Since we statically link it, we do not need to install it.
🏗️ Build Setup
- Added the
NO_FILE_SCHEMEoption tomake. When set, chd_hook will be built without support for thefile://scheme, which may be useful for Postgres hosting providers (#85). - The
installtarget no longer installslibchdb.awhen usingLIBCHDB_BUILD=static. Since we statically link it, we do not need to install it (#87). - Added the
MAX_CONCURRENT_TESTSvariable to minimize the number of concurrent tests in resource-constrained environments, such as CI runners (#91). - Added macOS testing to the CI workflow and adopted the PGXN actions for the CI and release workflows.
⬆️ Dependencies
- Added testing for chDB v26.7.3 and v26.9.0.
- Updated to support PostgreSQL 19 beta 4.
📚 Documentation
- Added missing links to the README and docs and simplified the list of files to load in a single command.
- Document manual enum and composite type mappings for
Enum,Tuple,Map, andNestedcolumns (#89).