SQL & Transaction Engine
ACID · ANSI SQL SubsetDDL / DML Support
CREATE/ALTER/DROP TABLE, indexes, views, CTE, window functions. INSERT/UPDATE/DELETE/UPSERT fully covered.
CREATE TABLE users (id INT PRIMARY KEY, name TEXT, score REAL); Complex JOINs
INNER/LEFT/RIGHT/CROSS JOIN, subqueries, GROUP BY / HAVING / ORDER BY / LIMIT.
- • Inner Join
- • Left/Right Join
- • Cross Join
ACID Transactions
WriteBatch atomic commit, WAL crash recovery. 1M rows PK query P95 < 0.02ms.
Vector & Full-Text Search
Unified IndexingHybrid Search
BM25 full-text + HNSW vector search with RRF fusion ranking. Pure Rust, zero JVM dependency.
Vector
Full-Text
HNSW Vector Index
Custom persistent HNSW, 100K vectors KNN P95 <10ms
SQ8 Quantization
Scalar quantization for reduced memory, cosine/L2/dot distances
AI-Native Capabilities
Agent ReadySession & LLM Config
Session CRUD with TTL, tags, archive. Configure LLM Providers (OpenAI/DeepSeek/Ollama) for auto-summarize and auto-embed.
Auto-Embed Memory
Auto-generate embeddings via configured provider. Hybrid Recall Pipeline: BM25+Vec dual-write, temporal decay, graph expansion, LLM rerank.
Smart Context & Token Count
Smart context window with auto-summarize. Precise BPE token counting (tiktoken). Execution trace and RAG doc versioning.
speed Performance Benchmarks
| Operation | Metric | Value |
|---|---|---|
| KV GET | Throughput | 625K ops/s |
| SQL INSERT | Write Rate | 165K rows/s |
| Vector KNN | P95 Latency | <10ms |
| MQ Publish | Throughput | 1.6M msg/s |
| TS Write | Write Rate | 353K pts/s |