50+ documents covering everything from first install to enterprise clustering, vector search, security, and compliance.
What Absolute DB is, why it exists, the unified multi-model approach, key differentiators, and the 7 target classes.
Get running in 60 seconds — one-line install, first SQL query, first vector search, connect with psql or Python.
Fresh-server setup, prerequisites, all platforms (Linux/macOS/ARM64/Docker/K8s), one-line installer, service setup.
Build from source — prerequisites, make targets, binary outputs (~154 KB CLI / ~230 KB server / ~154 KB lite), platform notes.
Storage layers, LIRS buffer pool, MVCC, SQL engine pipeline, SIMD, JIT, network stack, Raft consensus, and AI/vector subsystems.
Parser → planner → optimizer → executor pipeline. 142+ keywords, SQL:2023 conformance, cost-based optimizer, JIT compilation.
B+Tree, LSM-Tree, PAX columnar, LIRS buffer pool, Direct I/O, io_uring, bloom filters, BRIN index, WAL, crash recovery.
Cost-based optimizer, selectivity estimation, index selection, adaptive re-optimisation mid-execution, parallel query planning.
Since v9.0.2 "Project ZENITH": MySQL clients connect on port 3306 — mysql CLI, Workbench, Sequelize, JDBC, mysql-connector-python/j, go-sql-driver, Rails ActiveRecord. Clean-room, zero dependencies.
Since v9.0.2 "Project ZENITH": browser admin UI — schema browser, paginated data grid with inline edit, full SQL editor with syntax highlighting, EXPLAIN tree SVG, backup/restore. Zero external JS.
One-click replacement of MariaDB on a cPanel host with Absolute DB. Sub-100 ms atomic flip, 7-day rollback, WHMCS billing driver. Zero application code changes.
Full SQL:2023 — CTEs, window functions, 4 JOIN types, subqueries, MERGE/UPSERT, arrays, JSONB, stored procedures, temporal.
HNSW index (<0.05 ms top-10), L2/cosine/inner product, PQ/SQ/BQ quantisation, Matryoshka dims, sparse vectors, hybrid BM25+vec, ColBERT.
BM25 with snippet highlighting, BM25F field-weighted, trigram similarity (pg_trgm), hybrid RRF ranking, ColBERT MaxSim.
RELATE syntax, BFS/DFS/shortest path, 1.3B traversals/sec, PageRank, Louvain, betweenness centrality, VecGraph, property graph.
Full ACID, 4 isolation levels, MVCC snapshot isolation, 4,096 concurrent transactions, savepoints, advisory locks, SSI.
LISTEN/NOTIFY, WebSocket live queries (29.2M+ notifications/sec), CDC streaming, CREATE STREAMING VIEW, NL2SQL.
Full PG wire v3 on port 5433. Compatible with psql, pgAdmin, psycopg2, JDBC, node-postgres, Prisma, Django ORM, Rails, Npgsql.
HTTP REST on port 8080. JSON responses, SQL execution, health check, metrics, OpenAPI spec at /openapi.json, 8-panel web console.
Native gRPC/HTTP2 on port 9090. Unary, server-streaming, bidirectional streaming. No external grpc-c library. Protobuf encoding.
GraphQL endpoint at /graphql. Auto-schema from SQL tables. Query, mutation, subscription. Apollo/Relay compatible, introspection.
Measured benchmarks: 704K–736K inserts/sec, 0.14 µs point queries, <0.05 ms vector search, 29.2M+ notifications/sec.
B+Tree, Hash, BRIN, GIN, HNSW, partial, expression, covering indexes. Auto-indexing advisor. Online non-blocking creation.
EXPLAIN, cost-based planner, adaptive re-optimisation, parallel query (up to 64 workers), SIMD vectorisation, JIT compilation.
LIRS buffer pool, prepared statement plan cache (1,024 plans, hash-keyed), query result cache (1,024 entries, 256 MB, TTL).
Raft clustering (up to 31 nodes), C-RAID sharding (RAID-0/1/5), consistent hashing DHT, multi-region, 16M virtual connections.
Native TLS 1.3, post-quantum cryptography (FIPS 203/204/205), zero-trust mTLS+SPIFFE, RBAC/ABAC/RLS, LDAP, OAuth2/OIDC JWT.
AES-256-GCM column encryption, KMS-managed DEKs, Argon2id KDF, TLS 1.3, ML-KEM-768 + ML-DSA-65 + SLH-DSA post-quantum.
RBAC, ABAC, Row-Level Security (RLS), dynamic data masking, SSO/JWT, LDAP/Active Directory, OAuth2/OIDC, per-tenant DEKs.
systemd service, Docker Compose, Kubernetes Operator + Helm + Terraform, Nginx reverse proxy, SSL termination, prod checklist.
9 first-party integration plugins — cPanel, Docker, Helm, Kubernetes CRD, Terraform (AWS/GCP/Azure/Hetzner/DigitalOcean), Proxmox, DirectAdmin, Plesk, CyberPanel. All SHIPPED, 478 shape tests, Absolute-Mode compliant.
Server flags, environment variables, buffer pool tuning, WAL retention, connection limits, TLS cert setup, licence key activation.
PITR, incremental backup, WAL streaming, S3/GCS/Azure targets, data versioning (branch/clone/diff), tenant export/import.
Raft log replication, C-RAID mirroring/parity, WAL streaming replicas, auto-rebalancer, dirty-shutdown self-heal, CDC streaming.
Deep-dive into LIRS, MVCC undo-log, JIT machine-code emission, SIMD kernel dispatch, Raft pre-vote + joint consensus.
CRC-32C records, group-commit (64/fsync), LSN addressing, WAL streaming, WAL tap for CDC, PITR walkthrough, archiving.
B+Tree 4 KB pages, PAX 64 KB columnar pages, LSM SSTables, binary COPY, Arrow IPC, Parquet (LZ4+Zstd), WAL record layout.
# One-line install
curl -fsSL https://downloads.absolutedb.com/install.sh | bash
# Or build from source
git clone https://github.com/supportcall/AbsoluteDB
cd AbsoluteDB
make release # CLI ~154 KB · server ~230 KB · lite ~154 KB
# Run
./bin/absdb # interactive CLI
./bin/absdb-server # PG wire port 5433 + REST 8080
# PostgreSQL client (port 5433)
psql -h localhost -p 5433 -U $(whoami)
# Health check
curl http://localhost:8080/health
# Python
import psycopg2
conn = psycopg2.connect(host='localhost', port=5433, user='myapp')
# Vector search
SELECT id, title FROM docs
ORDER BY embedding <-> '[0.1,0.2,...]'::vector
LIMIT 10;
~154 KB binary · zero external dependencies · 2,737 tests passing · SQL:2023 100%