HeliosDB Full v7.2.0 Release Notes

Release Date: 2026-03-26 Theme: Feature exposure — complete platform surface across all 193 crates

Highlights

v7.2.0 closes the long-standing “shipped but not exposed” gap. 25+ features that were already present in the workspace get formal SQL / REPL / REST surfaces. EXPLAIN gets seven output formats. The Redis adapter expands to 96+ commands. CDC events become first-class.

What’s New

Feature Exposure (Complete Platform Surface)

100+ SHOW commands covering every domain: storage, compute, protocols, security, cluster, AI/ML, observability, advanced features.
REPL-to-SQL bridge — 35+ backslash commands now route through the PostgreSQL wire protocol against real data (no mock returns).
16 REST admin endpoints at /api/v1/admin/* for storage, WAL, protocols, cache, locks, cluster, CDC, backup.
EXPLAIN enhancements — seven output formats: Text, JSON, YAML, XML, HTML, GraphViz, Mermaid. New options: VERBOSE, FEATURES, WHY_NOT, STORAGE.
25 previously-unexposed features wired:
- CREATE DATABASE / DROP DATABASE
- REFRESH MATERIALIZED VIEW
- FLUSH (caches)
- WASM functions (registration, listing)
- Encryption key rotation
- CDC connectors
- Snapshots (create / restore / list)
- Tenants (create / drop / list)
- Failover (manual / automatic)
- Compliance policies
- Data sovereignty rules
psql / pgAdmin / DBeaver compatibility — session parameters, startup-query handling, system views aligned with PostgreSQL expectations.

Redis Protocol — 96+ Commands

Up from 71 in v7.1:

Lists: LMOVE, BLMOVE, RPOPLPUSH
Sets: SUNION, SDIFF, SINTER, SRANDMEMBER
Sorted sets: ZRANGEBYSCORE, ZREVRANGE, ZRANGEBYLEX
Keys: RENAME, COPY, RANDOMKEY, OBJECT
Server: CONFIG, CLIENT, COMMAND (stubs for client compatibility)
Protocol: RESP2 auto-detection in the protocol router
Multi-connection: shared keyspace / pubsub / cluster state across connections
Auth: AUTH enforcement with catalog-based credential verification
INFO: enhanced with server, clients, memory, keyspace sections

Storage & CDC

CDC event emission on INSERT / UPDATE / DELETE from both indexed and full-scan paths.
SHOW CDC EVENTS [LIMIT n] for change-log queries from the SQL surface.
Storage tiering CLI — new flags: --enable-tiering, --warm-tier-path, --cold-tier-path.
ALTER TABLE SET STORAGE HOT|WARM|COLD for per-table tier overrides.

Pre-existing v7.2 Baseline (carried forward)

135/135 E2E SQL conformance (100%).
PL/pgSQL interpreter: DECLARE, IF / ELSIF, WHILE, RETURN, SELECT INTO.
Stored procedures, triggers (BEFORE / AFTER × INSERT / UPDATE / DELETE).
Window functions, CTEs, UNION / INTERSECT / EXCEPT.
PostgreSQL benchmark: HeliosDB wins 7/7 vs PostgreSQL 16.11.
4,880+ unit tests passing across 28 parent crates.

Migration

Wire-compatible with v7.1.x. New SHOW / EXPLAIN / REPL surfaces are additive — existing tooling continues to work unchanged. Operators who scrape /api/v1/* may want to add the new admin endpoints to their dashboards.

Compatibility Matrix

Component	Version
PostgreSQL wire	v3
MySQL wire	v10
Redis protocol	RESP2 + RESP3, 96+ commands
EXPLAIN formats	Text, JSON, YAML, XML, HTML, GraphViz, Mermaid
Build (minimal)	Rust 1.85+
Crate count	193

See CHANGELOG.md for the workspace-level entry.