SQL and planner
CTEs, windows, grouping sets, navigable references, statistics, and physical operator selection.
RadixDB 1.2.25 · architectural fit
The hybrid data path remains the core, now connected to catalog 6.2, protocol 18, database-scoped authentication, Application SDK codegen, and a validated native plugin ABI.
The data path
CTEs, windows, grouping sets, navigable references, statistics, and physical operator selection.
MVCC, READ COMMITTED and SNAPSHOT, savepoints, statement atomicity, ACL, and routine authority.
Current changes remain available without rewriting cold blocks.
Immutable compressed segments for sequential and selective reads.
Write-ahead logging, checkpoints, physical backup, logical export, and verified post-crash startup.
Catalog 6.2, protocol 18, schema descriptors, typed errors, and explicit upgrade boundaries.
SQL
The documented contract includes CTEs, window functions, ROLLUP, CUBE, GROUPING SETS, RETURNING, UUIDv7, routines, triggers, jobs, and ACL. It is its own SQL dialect, not PostgreSQL emulation.
BEGIN ISOLATION LEVEL SNAPSHOT;
UPDATE stock_balances
SET quantity = quantity - 4
WHERE product_id = :product
AND revision = :expected
RETURNING quantity, revision;
COMMIT;Where RadixDB is strongest
Index access
Application interfaces
Open databases and run queries directly in-process.
Use protocol 18 over TLS 1.3 with database-scoped authentication and typed errors.
A typed application interface over queries, records, schema descriptors, and async transport.
Generate schema-bound tables and procedure calls with fingerprints, deadlines, cancellation, and bounded results.
Functions, procedures, transactional triggers, durable jobs, and invoker/definer security run beside the data.
Trusted Rust packages add bounded external types, scalar and batch functions, operators, and planner-aware index classes through stable C ABI 1.0. Code runs in-process and is not sandboxed.