v0.13.0
Citadel v0.13.0
Encrypted-first embedded database engine that outperforms unencrypted SQLite.
New features
- FULL OUTER JOIN -
SELECT ... FROM a FULL OUTER JOIN b ON a.id = b.a_idemits matched rows + left-only (NULL right) + right-only (NULL left) - LATERAL joins -
FROM a, LATERAL (SELECT ... WHERE p.x = a.x)andLEFT JOIN LATERAL ... ON true(top-N-per-group pattern) - COLLATE -
BINARY/NOCASE/RTRIMat column / expression /ORDER BY/ index level - STRICT tables -
CREATE TABLE ... STRICTrejects lossy cross-type INSERT/UPDATE (e.g.'xyz'→ INTEGER,'000123'→ INTEGER) - Schema version bump 6 → 7 (forward-only; v0.12 binaries cannot read v0.13 DBs)
Downloads
| Platform | CLI | FFI |
|---|---|---|
| Linux x86_64 | citadel-v0.13.0-x86_64-unknown-linux-musl.tar.gz |
citadel-ffi-v0.13.0-x86_64-unknown-linux-gnu.tar.gz |
| Linux aarch64 | citadel-v0.13.0-aarch64-unknown-linux-gnu.tar.gz |
citadel-ffi-v0.13.0-aarch64-unknown-linux-gnu.tar.gz |
| macOS x86_64 | citadel-v0.13.0-x86_64-apple-darwin.tar.gz |
citadel-ffi-v0.13.0-x86_64-apple-darwin.tar.gz |
| macOS aarch64 | citadel-v0.13.0-aarch64-apple-darwin.tar.gz |
citadel-ffi-v0.13.0-aarch64-apple-darwin.tar.gz |
| Windows x86_64 | citadel-v0.13.0-x86_64-pc-windows-msvc.zip |
citadel-ffi-v0.13.0-x86_64-pc-windows-msvc.zip |
FIPS variants are prefixed with citadel-fips- / citadel-ffi-fips-.
All archives include SHA256 checksums.
Install
cargo install citadeldb-clinpm install @citadeldb/wasm