Skip to content

HeliosDB Nano Feature Index (v3.19.1)

HeliosDB Nano Feature Index (v3.19.1)

Canonical feature × tutorial coverage map. Every shipped feature from v3.6 onwards has a documented entry here with a UVP and a link to a hands-on tutorial or quick reference.

For full version history, see ../releases/CHANGELOG.md.


Coverage Status Legend

  • ⭐⭐⭐⭐⭐ Long-form tutorial + quick reference + UVP messaging
  • ⭐⭐⭐⭐ Tutorial OR multiple references with code examples
  • ⭐⭐⭐ Reference page with examples
  • ⭐⭐ Brief mention in release notes / README
  • ⭐ Mentioned only in CHANGELOG

SQL / DML / Query Execution

FeatureVersionUVPCoverageDoc
Full SQL Core3.6+JOINs, CTEs, subqueries, set ops, aggregates, CASE⭐⭐⭐⭐SQL_REFERENCE
Aggregate expressions3.7SUM(a)+SUM(b), CAST(AVG()), CASE on COUNT⭐⭐⭐SQL_FEATURES
Window functions3.7+Full SQL:2003 frame spec⭐⭐⭐WINDOW_FUNCTIONS_QUICKREF
Common table expressions3.7+WITH RECURSIVE depth control⭐⭐⭐SQL_FEATURES
Subqueries3.6+Scalar, derived, IN/EXISTS⭐⭐⭐SQL_FEATURES
String concatenation ||3.7NULL propagation, auto-cast⭐⭐CHANGELOG
EXTRACT / date functions3.14EPOCH, YEAR, MONTH, etc.⭐⭐⭐RELEASE_NOTES_v3.14.0
INSERT … SELECT3.7FK/trigger/RLS-aware bulk insert⭐⭐⭐SQL_FEATURES
ON CONFLICT (Upsert)3.9.5DO UPDATE SET … EXCLUDED + MySQL ON DUPLICATE KEY⭐⭐⭐UPSERT_QUICKREF
Parameterized LIMIT/OFFSET3.14.8LIMIT $1 OFFSET $2 with type coercion⭐⭐⭐RELEASE_NOTES_v3.14.0
Keyset pagination3.6 / 3.12Constant-time deep pagination (~30 µs)⭐⭐⭐⭐⭐KEYSET_PAGINATION_QUICKREF, RELEASE_NOTES_v3.12.0
Top-K sort optimization3.12LIMIT-driven early termination, O(N log k)⭐⭐⭐RELEASE_NOTES_v3.12.0
Generate_series / unnest3.7Table-valued functions⭐⭐CHANGELOG
EXPLAIN / cost planner3.6+JSON/XML/YAML output, ANALYZE⭐⭐⭐⭐EXPLAIN_AND_OPTIMIZATION
Implicit comma-joins3.10FROM t1, t2 WHERE … (WordPress compat)⭐⭐CHANGELOG
Recursive CTEs3.7Depth-limited graph traversal in SQL⭐⭐⭐SQL_FEATURES
gen_random_uuid / uuid_generate_v43.14UUID generation⭐⭐RELEASE_NOTES_v3.14.0

DDL / Schema

FeatureVersionUVPCoverageDoc
CREATE TABLE3.6+All constraints + DEFAULT expressions + CHECK⭐⭐⭐⭐SQL_REFERENCE
PRIMARY KEY (inline + table)3.9.3Both syntaxes⭐⭐⭐primary-keys
Foreign keys3.7+CASCADE, SET NULL, RESTRICT⭐⭐⭐⭐foreign-keys
UNIQUE constraints3.8–3.9Per-column + multi-column; ON CONFLICT detection⭐⭐⭐SQL_FEATURES
CHECK constraints3.6+Expression-based row validation⭐⭐⭐SQL_FEATURES
GENERATED ALWAYS AS IDENTITY3.14SQL:2016 identity columns⭐⭐⭐RELEASE_NOTES_v3.14.0
SERIAL / BIGSERIAL / AUTO_INCREMENT3.6+PG + MySQL alias⭐⭐⭐SQL_REFERENCE
DEFAULT expressions3.14.3DEFAULT now(), DEFAULT CURRENT_USER⭐⭐⭐CHANGELOG
ALTER TABLE3.6+Multiple ops in single stmt⭐⭐⭐SQL_REFERENCE
CREATE INDEX3.6+B-tree, ART, HNSW, GIN⭐⭐⭐⭐vector-search, STORAGE_FILTERING
CREATE SEQUENCE / nextval3.14Process-scoped sequence store⭐⭐⭐RELEASE_NOTES_v3.14.0
CREATE EXTENSION hdb_code3.16Code-graph bootstrap (opt-in)⭐⭐⭐CODE_GRAPH_TUTORIAL
CREATE SEMANTIC HASH INDEX3.19Merkle-tree subtree invalidation⭐⭐⭐SEMANTIC_HASH_INDEX_QUICKREF
TRUNCATE3.7+Fast clear with ART purge⭐⭐⭐SQL_FEATURES
Per-column storage modes3.6+Dictionary / Content-Addressed / Columnar⭐⭐⭐⭐per-column-storage
FeatureVersionUVPCoverageDoc
Adaptive Radix Tree (ART)3.6+Zero-copy PK lookups, O(k)⭐⭐⭐PRODUCT_QUANTIZATION_IMPLEMENTATION
HNSW vector search3.6+Native k-NN, 8–16× PQ⭐⭐⭐⭐⭐VECTOR_SEARCH_TUTORIAL
BM25 full-text search3.13tsvector / tsquery / @@ / ts_rank_cd⭐⭐⭐⭐FULL_TEXT_SEARCH
Hybrid search3.12+BM25 + vector via RRF/MMR⭐⭐⭐⭐FULL_TEXT_SEARCH
GIN indexes (FTS)3.13ORM/migration compat (no-op currently)⭐⭐RELEASE_NOTES_v3.13.0
SIMD predicate pushdown3.6+Storage-level filtering via bloom/zone-map/SIMD⭐⭐⭐STORAGE_FILTERING
Centrality-biased HNSW3.19Post-rerank with centrality weighting⭐⭐⭐RELEASE_NOTES_v3.19.0
UUID literal coercion3.19.1PK lookup with UUID columns⭐⭐⭐RELEASE_NOTES_v3.19.1

Transactions / Concurrency / MVCC

FeatureVersionUVPCoverageDoc
ACID transactions3.6+Snapshot isolation, all-or-nothing⭐⭐⭐⭐SQL_REFERENCE
Explicit transactions3.6+BEGIN / COMMIT / ROLLBACK⭐⭐⭐SQL_REFERENCE
Savepoints3.7+Nested rollback boundaries⭐⭐⭐SQL_FEATURES
MVCC3.6+Snapshot iso, read-your-writes⭐⭐⭐⭐../architecture/multi_user_transactions.md
Optimistic conflict detection3.17+ (sync-experimental)Vector clocks, field-level merge⭐⭐CHANGELOG

Time-Travel / Branching

FeatureVersionUVPCoverageDoc
Git-like branches3.6+COW isolation for dev/test/A-B⭐⭐⭐⭐⭐PHASE3_TUTORIAL, branching
Selective branch sync3.19+Replicate specific branches to remotes⭐⭐⭐RELEASE_NOTES_v3.19.0
AS OF TIMESTAMP3.6+Query historical snapshots⭐⭐⭐⭐⭐time-travel, PHASE3_TUTORIAL
AS OF TRANSACTION3.6+Query by txn ID⭐⭐⭐⭐time-travel
MERGE BRANCH / DROP BRANCH3.6+Branch lifecycle⭐⭐⭐⭐branching
ON BRANCH override3.19Per-call branch redirect (MCP/LSP)⭐⭐⭐RELEASE_NOTES_v3.19.0

Encryption / Security / Compliance

FeatureVersionUVPCoverageDoc
AES-256-GCM TDE3.6+Database-level transparent encryption⭐⭐⭐⭐⭐ENCRYPTION_TUTORIAL, ENCRYPTION
FIPS 140-33.6+ (feature flag)AWS-LC FIPS provider, Cert #4816⭐⭐⭐⭐FIPS_COMPLIANCE_TUTORIAL
SCRAM-SHA-256 auth3.8+PG-standard password hashing⭐⭐⭐SCRAM_SHA256_AUTHENTICATION
TLS / SSL3.8+Encrypted wire (PG + MySQL)⭐⭐⭐POSTGRESQL_SSL_QUICK_REFERENCE
Row-Level Security (RLS)3.6+Per-tenant isolation via policies⭐⭐⭐⭐RLS_POLICY_MANAGEMENT_TUTORIAL, rls
JWT sessions3.8+Stateless auth⭐⭐⭐JWT_AUTH_QUICK_REFERENCE
OAuth2 (Google/GitHub)3.8+PKCE, auto user creation⭐⭐⭐⭐AUTH_AND_OAUTH
Audit logging3.6+Tamper-proof SHA-256 chain⭐⭐⭐⭐⭐AUDIT_LOGGING_TUTORIAL, AUDIT_LOGGING
Argon2id KDF3.6+Memory-hard password hashing⭐⭐⭐ENCRYPTION_TUTORIAL

Stored Procedures / Triggers / Functions

FeatureVersionUVPCoverageDoc
PL/pgSQL procedures3.6+DECLARE / IF / LOOP / WHILE / FOR / RAISE⭐⭐⭐procedural-language
Triggers3.6+BEFORE/AFTER INSERT/UPDATE/DELETE⭐⭐⭐⭐triggers, TRIGGER_EXECUTION_QUICK_REFERENCE
Scalar functions3.6+100+ built-in⭐⭐⭐⭐SQL_REFERENCE
Aggregate functions3.6+COUNT, SUM, AVG, MIN, MAX, STDDEV⭐⭐⭐⭐SQL_REFERENCE
User-defined functions3.6+Composite types via JSON⭐⭐⭐SQL_REFERENCE

JSON / JSONB

FeatureVersionUVPCoverageDoc
JSONB type3.6+Schemaless docs⭐⭐⭐⭐SQL_REFERENCE
JSONB operators3.6+->, ->>, @>, ?, #-⭐⭐⭐⭐SQL_REFERENCE
JSON path queries3.6+Nested navigation⭐⭐⭐SQL_REFERENCE
json_agg3.4JSON array aggregation⭐⭐⭐CHANGELOG

Backend-as-a-Service (BaaS)

FeatureVersionUVPCoverageDoc
REST API (PostgREST-compat)3.8+19 filter operators on /rest/v1/{table}⭐⭐⭐⭐⭐BAAS_REST_API_TUTORIAL
Auth signup/token3.8+/auth/v1/signup, /auth/v1/token⭐⭐⭐⭐AUTH_AND_OAUTH
OAuth2 Google/GitHub3.8+PKCE flow⭐⭐⭐⭐AUTH_AND_OAUTH
RLS on REST3.8+JWT claims → session context⭐⭐⭐BAAS_REST_API_TUTORIAL
Realtime WebSocket3.8+Phoenix-protocol channels⭐⭐⭐⭐⭐REALTIME_WEBSOCKET
ChangeNotifier3.8+Internal DML event broadcast⭐⭐CHANGELOG
Swagger UI3.8+Auto-generated /docs⭐⭐⭐SWAGGER_UI_QUICKSTART

Protocol Compatibility

FeatureVersionUVPCoverageDoc
PostgreSQL Wire v33.6+psql, libpq, psycopg2, pg, JDBC⭐⭐⭐⭐⭐POSTGRESQL_WIRE_PROTOCOL
PG Extended Query3.14.1+Parse / Bind / Execute / Describe⭐⭐⭐PARAMETERIZED_QUERIES
MySQL Wire v103.8+mysql, JDBC, mysql2, mysqli, WordPress⭐⭐⭐⭐⭐MYSQL_WIRE
MySQL Prepared Stmts3.8+$N substitution, COM_STMT_PREPARE⭐⭐⭐MYSQL_WIRE
Unix Domain Sockets3.6+Zero-TCP for same-host⭐⭐⭐⭐UNIX_SOCKETS_QUICKSTART
Flush message (H)3.14.2Pipelined queries⭐⭐CHANGELOG
Multi-statement queries3.14;-separated stmts⭐⭐⭐RELEASE_NOTES_v3.14.0
MySQL SHOW commands3.8–3.9SHOW TABLES/COLUMNS/INDEX⭐⭐⭐CHANGELOG
MySQL date/time functions3.8DATE_FORMAT, DATE_ADD, UNIX_TIMESTAMP⭐⭐⭐CHANGELOG
MySQL identifier quoting3.14Backtick / double-quote / case-folding⭐⭐⭐RELEASE_NOTES_v3.14.0
heliosdb_capability_report()3.14.1Migration tool discovery⭐⭐⭐RELEASE_NOTES_v3.14.0

Materialized Views

FeatureVersionUVPCoverageDoc
MV creation3.6+Persistent query results⭐⭐⭐⭐⭐MATERIALIZED_VIEWS_TUTORIAL
Refresh MV3.6+Full recompute⭐⭐⭐⭐materialized-views
Incremental MV3.15+Delta computation⭐⭐⭐⭐INCREMENTAL_MATERIALIZED_VIEWS
Concurrent MV refresh3.6+Multi-MV in parallel⭐⭐⭐CONCURRENT_MV_REFRESH_QUICK_REF
MV scheduler3.6+CPU-aware auto refresh⭐⭐⭐MATERIALIZED_VIEWS_TUTORIAL
MV dependency tracking3.6+Cascading invalidation⭐⭐⭐INCREMENTAL_MV_IMPLEMENTATION_SUMMARY

Code-Graph (opt-in --features code-graph)

FeatureVersionUVPCoverageDoc
Code-graph bootstrap3.15+Tree-sitter AST for 8 languages⭐⭐⭐⭐CODE_GRAPH_TUTORIAL
Symbol extraction3.15+Functions, classes, methods, types⭐⭐⭐CODE_GRAPH_TUTORIAL
Reference resolution3.16+Cross-file linking (exact/heuristic)⭐⭐⭐RELEASE_NOTES_v3.16.0
lsp_definition3.15+“Where is X defined?”⭐⭐⭐⭐CODE_GRAPH_TUTORIAL
lsp_references3.15+“Who uses X?”⭐⭐⭐⭐CODE_GRAPH_TUTORIAL
lsp_call_hierarchy3.15+BFS over CALLS edges⭐⭐⭐⭐CODE_GRAPH_TUTORIAL
lsp_hover3.15+Signature lookup⭐⭐⭐CODE_GRAPH_TUTORIAL
lsp_document_symbols3.19File outline⭐⭐⭐RELEASE_NOTES_v3.19.0
lsp_rename_preview/apply3.19Identifier-boundary write-back⭐⭐⭐RELEASE_NOTES_v3.19.0
Symbol embeddings3.19body_vec VECTOR(n) lazy column⭐⭐⭐CODE_GRAPH_TUTORIAL
Pluggable embedders3.15+NoopEmbedder + HttpEmbedder⭐⭐⭐CODE_GRAPH_TUTORIAL
code-embed feature3.19fastembed-rs (BGESmallENV15, 384-dim)⭐⭐⭐CODE_GRAPH_TUTORIAL
Runtime grammar registry3.16+Dynamic grammar loading⭐⭐CHANGELOG
Pluggable extractors3.19Per-language runtime registration⭐⭐CHANGELOG
Semantic Hash Index3.19Merkle-tree subtree invalidation⭐⭐⭐SEMANTIC_HASH_INDEX_QUICKREF
_hdb_code_languages view3.19List static + runtime grammars⭐⭐CHANGELOG

Graph-RAG (opt-in --features graph-rag)

FeatureVersionUVPCoverageDoc
Universal node/edge schema3.17+_hdb_graph_nodes & _hdb_graph_edges plain tables⭐⭐⭐⭐GRAPH_RAG_TUTORIAL
Symbol projection3.17+graph_rag_project_symbols()⭐⭐⭐GRAPH_RAG_TUTORIAL
BFS graph search3.17+Seed → expand → subgraph⭐⭐⭐⭐GRAPH_RAG_TUTORIAL
Centrality weighting3.19Post-rerank scoring bias⭐⭐⭐GRAPH_RAG_TUTORIAL
Vector entity linker3.19Cross-modal MENTIONS via cosine⭐⭐⭐GRAPH_RAG_TUTORIAL
Docling PDF/Office ingestion3.19graph_rag_ingest_*⭐⭐⭐⭐DOCLING_INGESTION
Graph traversal tools3.12+heliosdb_graph_traverse / _path / _add_edge⭐⭐⭐RELEASE_NOTES_v3.11.0

MCP Endpoint (opt-in --features mcp-endpoint)

FeatureVersionUVPCoverageDoc
MCP JSON-RPC dispatcher3.18+Native server for Claude Code/Cursor/Aider⭐⭐⭐⭐⭐MCP_ENDPOINT
16-tool catalogue3.18+10 DB-backed + 6 RAG⭐⭐⭐⭐MCP_ENDPOINT
MCP resource URIs3.18+heliosdb://schema/{table} etc.⭐⭐⭐MCP_ENDPOINT
WebSocket transport3.19Real-time tool calls⭐⭐⭐MCP_ENDPOINT
Stdio transport3.19Subprocess mode⭐⭐⭐MCP_ENDPOINT
SSE transport3.19Server-sent events⭐⭐⭐MCP_ENDPOINT
Progress notifications3.19Streaming notifications/progress⭐⭐⭐MCP_ENDPOINT
HTTP POST + SSE pairing3.19Forward progress to SSE⭐⭐RELEASE_NOTES_v3.19.0
Verbose tool discovery3.19tools/list?verbose=true + helios/info⭐⭐⭐MCP_ENDPOINT

Persistence / WAL / Replication

FeatureVersionUVPCoverageDoc
RocksDB LSM storage3.6+Write-optimised KV store⭐⭐⭐../architecture
Write-ahead log3.6+Durability guarantee⭐⭐⭐WAL_QUICK_REFERENCE
WAL streaming replication3.18+ (default)Warm standby, async repl⭐⭐⭐⭐HA_HANDS_ON_TUTORIAL
Branch-based replication3.19+ (ha-tier2/branch-replication)Selective branch sync⭐⭐⭐RELEASE_NOTES_v3.19.0
Multi-primary active-active3.19+ (ha-tier2)Vector-clock conflict resolution⭐⭐⭐high-availability
Sharding3.19+ (ha-tier3)Consistent hash ring⭐⭐⭐high-availability
Content-addressed dedup3.19+ (ha-dedup)Cross-node BLAKE3 dedup⭐⭐⭐high-availability
In-memory mode3.6+--memory for tests/CI⭐⭐⭐IN_MEMORY_MODE_QUICKREF

Backup / Restore / Dump

FeatureVersionUVPCoverageDoc
Database dump3.6+zstd / gzip / brotli / lz4⭐⭐⭐⭐BACKUP_RESTORE
Selective export3.6+Per-table/schema⭐⭐⭐BACKUP_RESTORE
Import/export formats3.6+CSV, JSON, JSONL, Parquet, Arrow, SQL⭐⭐⭐BACKUP_RESTORE
SQLite import3.6+One-shot .sqlite conversion⭐⭐⭐features/sqlite/

Observability

FeatureVersionUVPCoverageDoc
Tracing / structured logging3.7+tracing macros⭐⭐⭐TRACING_GUIDE
EXPLAIN ANALYZE3.6+Cost-based plans, JSON/XML/YAML⭐⭐⭐⭐EXPLAIN_AND_OPTIMIZATION
CPU monitoring (sysinfo)3.6+MV scheduler awareness⭐⭐CHANGELOG
Result cache3.6+128-entry LRU + dml/ddl invalidation⭐⭐⭐CHANGELOG
Audit log3.6+Tamper-proof SHA-256⭐⭐⭐⭐⭐AUDIT_LOGGING_TUTORIAL

Embedded Rust API

FeatureVersionUVPCoverageDoc
In-process database3.6+Zero-network, no daemon⭐⭐⭐⭐API_REFERENCE, docs.rs
Async runtime (Tokio)3.6+Non-blocking I/O⭐⭐⭐API_REFERENCE
Code indexing API3.15+code_index(opts) idempotent⭐⭐⭐CODE_GRAPH_TUTORIAL
Branch operations3.6+create/switch/list/merge⭐⭐⭐API_REFERENCE
Transaction control3.6+begin/commit/rollback/savepoint⭐⭐⭐API_REFERENCE

SDKs & Bindings

LanguageUVPDoc
Rust (heliosdb-nano)Embedded APIdocs.rs
Python (@heliosdb/client-equiv)psycopg2 + REST + Realtimeapi/python-sdk.md, PYTHON_VECTOR_APP
TypeScript (@heliosdb/client)REST + Realtime + Auth fluent APIapi/typescript-sdk.md, NODEJS_BAAS_APP
Gopgx-style + RESTapi/go-sdk.md, GO_EMBEDDED_APP
ORMs (any)SQLAlchemy / Django / Prisma / Drizzle / TypeORM / Sequelize / Hibernate / GORM / SeaORM / DieselORM_SUPPORT, DRIZZLE_PRISMA_COMPAT

Tooling / CLI

FeatureVersionUVPCoverageDoc
heliosdb-nano binary3.6+~47 MB single executable⭐⭐⭐⭐README
REPL3.6+Zero-setup interactive SQL⭐⭐⭐⭐REPL_COMMAND_REFERENCE
npm / Homebrew / Docker / binary3.6+All packaging vectors⭐⭐⭐⭐README

Status: Coverage Gates

  • Coverage gate: every CHANGELOG entry should map to a row in this table. Run python scripts/check_feature_index.py (TBD) to lint.
  • Hands-on gate: every “tutorial” link must include runnable SQL/Rust/Python/TS that executes against v3.19.1 binary.
  • UVP gate: every tutorial begins with a ## UVP block ≤ 100 words.

Last updated: 2026-04-26 | Version: v3.19.1