Implemented
🧬
Cell-Interned MVCC
Every value is content-addressed. Identical cells across rows, versions, and tables share one physical representation — automatic deduplication without compression overhead. Segment-backed .rseg row storage is now the default serve mode.
Implemented
🔌
MySQL Wire Protocol
Connect with any MySQL client. SkeinDB speaks the MySQL binary protocol with 678 corpus-backed compatibility statements, window functions, user variables, prepared statements with projection-subquery metadata parity, broad COM_QUERY coverage, richer information_schema probes including plugins, partitions, constraints, parameters, tablespaces, privileges, and views, and WordPress admin parity including Users/Site Health query coverage, installer seed-query regressions, and a clean live admin sweep across the core screens.
Partial
🐘
PostgreSQL Wire Protocol
Connect with early PostgreSQL clients. SkeinDB now ships a partial PG v3 baseline on port 5432: trust/SCRAM auth, SSL rejection, simple and extended queries, transaction/savepoint state, virtual pg_catalog tables for tables/views, roles/users, indexes, tablespaces, sequences, statistics, and database health, plus common bootstrap probes like SHOW server_version and current_setting(...) backed by the shared engine.
Implemented
⚡
HTTP + QUIC Dual Transport
SkeinQL RPC runs over HTTP/1.1, HTTP/2, and QUIC from the same binary, with dedicated integration tests for transport parity and reconnect behavior.
Documented
📚
SkeinQL API Reference
The API surface now has a dedicated client reference: transports, envelopes, result formats, method families, and the current 147-method system.capabilities map are documented beside the full SkeinQL language spec.
Sample App
🧠
Vector RAG Retrieval
A new Vector RAG tutorial and samples/vector_rag_pipeline.py demonstrate deterministic embeddings, vector.insert, vector.search, and grounded prompt assembly without external credentials.
Signed
🔏
Signed macOS Artifacts
Tagged releases now build a macOS binary, seal it with codesign, verify the signature, and upload the archive, checksum, and signing metadata. The release packaging guide documents local Developer ID signing too.
Implemented
🖥️
Web Admin (SkeinAdmin)
27 interactive panels compiled into the binary, including a dedicated Help & Docs center with quick start, panel reference, R01-R20 research-track index, keyboard shortcuts, glossary, and direct links to the canonical documentation. Schema browsing, data manipulation, cluster control, dedicated telemetry/security centers, dialect-aware SQL workspaces, and dedicated panels for all 20 research features, including a click-first Easy Viewer with inline database creation plus live create-table preview/validation, expert control panels, a live Index Advisor page with ranked suggestions plus observed-before/expected-after scan reports, CDC lag and backpressure controls with pause/resume, average/p95/p99 query latency, plus per-fingerprint tail-latency histograms.
Prototype
🔬
20 Research Tracks (18 Hardened / 2 Prototype)
From learned ValueID indexes and differential privacy aggregate hardening to migration intent reports, NL-to-SkeinQL verification, and energy-aware compaction, 18 tracks are hardened with real algorithms and integration tests. R18 performance replay and R19 Wasm query operators remain prototype implemented while their remaining productionization work continues.
Prototype
🌐
Cluster Control-Plane
9 typed cluster methods for topology lifecycle: join tokens, node admission, shard placement, replica promotion, and RPC fanout replication with recursion suppression.