Citadel v0.14.0

Encrypted-first embedded database engine that outperforms unencrypted SQLite.

New features

JSON / JSONB types - native JSON (lossless text) and JSONB (canonical streaming binary), PG-compatible
12 PG operators - ->, ->>, #>, #>>, @>, <@, ?, ?|, ?&, #-, @?, @@
SQL/JSON standard - JSON_TABLE (table-valued), JSON_EXISTS, JSON_VALUE, JSON_QUERY with full predicate path language ($.items[*] ? (@.x > 5))
16 scalar functions - jsonb_typeof, jsonb_extract_path, jsonb_set, jsonb_insert, jsonb_strip_nulls, jsonb_pretty, to_jsonb, json_build_object, etc.
4 aggregates - json_agg, jsonb_agg, json_object_agg, jsonb_object_agg
5 set-returning functions - jsonb_array_elements, jsonb_array_elements_text, jsonb_each, jsonb_each_text, jsonb_object_keys
GIN inverted indexes - CREATE INDEX ... USING gin (data) accelerates @> containment queries by >200x on selective predicates
Overflow page chains - large TEXT / BLOB / JSON / JSONB values transparently spill across chained overflow pages; multi-megabyte values round-trip cleanly
Schema version bumps 7 → 8 (JSON/JSONB type tags) and 8 → 9 (per-index kind for GIN). Forward-only.

Platform	CLI	FFI
Linux x86_64	`citadel-v0.14.0-x86_64-unknown-linux-musl.tar.gz`	`citadel-ffi-v0.14.0-x86_64-unknown-linux-gnu.tar.gz`
Linux aarch64	`citadel-v0.14.0-aarch64-unknown-linux-gnu.tar.gz`	`citadel-ffi-v0.14.0-aarch64-unknown-linux-gnu.tar.gz`
macOS x86_64	`citadel-v0.14.0-x86_64-apple-darwin.tar.gz`	`citadel-ffi-v0.14.0-x86_64-apple-darwin.tar.gz`
macOS aarch64	`citadel-v0.14.0-aarch64-apple-darwin.tar.gz`	`citadel-ffi-v0.14.0-aarch64-apple-darwin.tar.gz`
Windows x86_64	`citadel-v0.14.0-x86_64-pc-windows-msvc.zip`	`citadel-ffi-v0.14.0-x86_64-pc-windows-msvc.zip`

FIPS variants are prefixed with citadel-fips- / citadel-ffi-fips-.

All archives include SHA256 checksums.

cargo install citadeldb-cli

npm install @citadeldb/wasm