AetheriusDB Feature Summary
This page summarises every capability area in AetheriusDB in one place. Each section says what the feature is and links to its full documentation. For which features are on by default versus opt-in, see Configuration & Availability.
What is AetheriusDB in one sentence?
Section titled “What is AetheriusDB in one sentence?”AetheriusDB is a high-performance database that serves SQL, vector search, graph traversal, and time-travel queries from a single engine over the same data, and lets you run your own logic inside the database as WASM compute cells instead of shipping rows out to an application server.
What are the main features of AetheriusDB?
Section titled “What are the main features of AetheriusDB?”AetheriusDB’s capabilities fall into ten areas:
| Area | What you get |
|---|---|
| Data modelling | Relational tables, ANSI SQL, schema-as-code, catalog metadata |
| Data loading | Continuous ingestion, bulk Arrow, CDC bridge, source connectors |
| Query execution | JIT compilation, morsel parallelism, adaptive execution, indexing |
| Vectors & AI | TENSOR(n) types, kNN search, semantic NLP, AI constraints |
| Graph & time | Graph traversal, knowledge graph, temporal tables, replay |
| In-database compute | WASM cells, logic registry, compute push |
| Transactions | Isolation levels, group tables, Raft coordination |
| Security | RBAC, row-level security, wire protocols, FHE engine |
| Storage | Multi-tier residency, pinning, caching, crash recovery |
| Tooling | aesql CLI, Studio, REPL, AetherScript |
What SQL and data-modelling features does AetheriusDB have?
Section titled “What SQL and data-modelling features does AetheriusDB have?”AetheriusDB provides strictly typed relational tables with a broad ANSI SQL
surface — joins, subqueries, GROUP BY, HAVING, window functions, and CTEs.
Schemas can be managed as code and version-controlled rather than applied by
hand, and the full catalog is queryable as ordinary tables.
Beyond standard SQL it adds hardware-aware semantic types, user-defined functions and stored procedures, and a cognitive schema layer. See Define Your Data and SQL Grammar.
How do I get data into AetheriusDB?
Section titled “How do I get data into AetheriusDB?”AetheriusDB supports several ingestion paths: continuous streaming ingestion, bulk loading via Apache Arrow, a native high-throughput ingest protocol, a change-data-capture bridge for replicating from an existing database, and source connectors for external systems.
Producer and ingest statistics are exposed so you can see throughput and back pressure while loading. Measured ingest rates are on the Benchmarks page. See Load Data.
What query-performance features does AetheriusDB have?
Section titled “What query-performance features does AetheriusDB have?”AetheriusDB compiles hot query plans to native code with whole-query JIT, and executes them with morsel-driven parallelism across cores. Adaptive query execution re-plans mid-flight when the data does not match the estimate, and a deep-RL optimizer can learn plan choices over time.
For indexing it offers PTI aggregate mirrors, B-Tree, Hash, HNSW, IVFFLAT, and graph indexes — see Index Types. It also supports approximate query processing, native multidimensional pivots, and horizon materialization. See Query Data.
What AI and vector features does AetheriusDB have?
Section titled “What AI and vector features does AetheriusDB have?”AetheriusDB has native fixed-dimension TENSOR(n) columns with HNSW and IVFFLAT
indexes for k-nearest-neighbour search, so vector retrieval runs in the same
engine and the same query as your relational filters — no separate vector store
to synchronise.
It also provides semantic NLP and text encoding, AI quality constraints that validate rows against a model at insert time, a multimodal fabric, and a cognitive kernel. See Vectors, AI & ML.
What graph and time-travel features does AetheriusDB have?
Section titled “What graph and time-travel features does AetheriusDB have?”Relationships in AetheriusDB are followed by direct link hops rather than rebuilt with join tables on every query, and the same data is addressable both relationally and as a graph. A knowledge-graph layer and spectral foreign keys build on that.
For time, AetheriusDB supports SQL:2011 system-versioned temporal tables — query any table as of an earlier moment — plus a chrono replay debugger for stepping through history. See Graph & Time-Travel.
Can I run my own code inside AetheriusDB?
Section titled “Can I run my own code inside AetheriusDB?”Yes. AetheriusDB runs user logic as WASM compute cells deployed into the database, executing next to the data and returning only the final result. This replaces the pattern of pulling rows over the network into an application server to reshape them.
Supporting this are a logic registry for deploying and versioning cells, Logic Loom orchestration, and compute-push distribution that moves the computation to where the data lives. See In-Database Compute.
What transaction and concurrency guarantees does AetheriusDB provide?
Section titled “What transaction and concurrency guarantees does AetheriusDB provide?”AetheriusDB provides configurable transaction isolation, group tables with a high-throughput batched commit path, and Raft-based coordination for distributed consensus.
Note that concurrency and multi-client scaling have not been benchmarked — all published performance figures come from single-client runs. See Transactions & Concurrency.
What security features does AetheriusDB have?
Section titled “What security features does AetheriusDB have?”AetheriusDB includes role-based access control, row-level security policies, multiple wire protocols (PostgreSQL pgwire, native Aether-Sync, and Arrow Flight SQL), and a zero-trust FHE engine for computing over encrypted data.
What storage and durability features does AetheriusDB have?
Section titled “What storage and durability features does AetheriusDB have?”AetheriusDB manages data across multiple residency tiers, moving cold data down and keeping hot data in memory. You can pin a table — or a predicate-scoped subset of one — to keep it permanently resident. Caching and memory compaction run underneath.
Durability comes from the persistence engine and a crash-recovery path that verifies committed state on restart. See Storage & Durability.
What tools and clients does AetheriusDB ship with?
Section titled “What tools and clients does AetheriusDB ship with?”AetheriusDB ships aesql, a SQL CLI with export/import, bulk CSV ingest,
benchmarking, and live table watching; Aether Studio, a graphical client; Aether
Term, a REPL; and AetherScript for scripting.
For application code it speaks PostgreSQL wire protocol (so psycopg, asyncpg,
and SQLAlchemy work), its own native protocol, and Arrow Flight SQL. See
Tools & Clients and
Connect a Client.
What is AetheriusDB not?
Section titled “What is AetheriusDB not?”AetheriusDB is not a document database, and it is not a drop-in PostgreSQL replacement — it speaks the PostgreSQL wire protocol so existing clients connect, but its SQL surface and behaviour are its own.
Feature maturity varies. Pages carry a stable, opt-in, beta, or roadmap badge, and Configuration & Availability is the source of truth for which is which.