A lightweight, high-performance multi-document database with live query and blob support, written in Rust.

Full documentation available at: https://solidb.solisoft.net/docs/

• 🚀 Fast & Efficient — Built with Rust for maximum performance
• 📄 JSON Document Storage — Store and query JSON documents with ease
• 📊 Columnar Storage — Column-oriented storage for analytics workloads with LZ4 compression and specialized indexes (Sorted, Hash, Bitmap, MinMax, Bloom)
• 🗃️ Blob Storage — Native support for storing and retrieving binary files
• 💾 RocksDB Storage — Production-grade persistence with automatic crash recovery

• 🔍 SDBQL Query Language — Familiar query syntax inspired by ArangoDB, plus as-of joins, lambdas, sketches, and time-travel scans
• 📊 Indexing — Hash, persistent, geo, and fulltext indexes
• 🌍 Geo Queries — Spatial indexes and distance functions
• 📝 Graph Traversals — Native graph queries and shortest path algorithms
• 📋 Common Table Expressions — WITH clauses for composable, reusable subqueries
• 📦 COLLECT AGGREGATE — GROUP BY with inline aggregations (COUNT, SUM, AVG, MIN, MAX)
• ⚡ Prepared Statement Cache — Parse once, execute many with automatic LRU eviction

• ⏱️ Time Series — TIME_BUCKET, DELTA, RATE, FILL, RESAMPLE, and ASOF JOIN
• 🌊 Stream Processing — CREATE STREAM with tumbling/sliding WINDOW clauses for continuous aggregations

• 🧠 Vector Indexes — Create and query vector indexes for ML/AI workloads
• 🔗 Hybrid Search — Combined vector similarity + fulltext search in a single query
• 📐 Vector Functions — VECTOR_DISTANCE, VECTOR_NORMALIZE, quantization/dequantization

• ⚡ Live Queries — Real-time subscriptions via WebSocket
• 🖥️ Lua Scripting — Server-side scripts for custom API endpoints (--no-lua / SOLIDB_NO_LUA=1 skips the VM pool)

• 🔄 Multi-Node Replication — Peer-to-peer replication with automatic sync
• 🧩 Sharding — Horizontal data partitioning with configurable shard count
• ⚖️ Auto-Rebalancing — Automatic data redistribution when nodes change
• ⚡ Hybrid Logical Clocks — Consistent ordering across distributed nodes
• 🔀 Distributed Transactions — Two-phase commit (2PC) for ACID guarantees across shards
• 📈 Replication Lag Metrics — Per-peer lag monitoring via Prometheus

• 🔭 OpenTelemetry Tracing — W3C traceparent propagation for distributed tracing
• ⚡ Regex Caching — Compiled regex patterns cached globally (~8000x speedup on repeated patterns)

• 🔐 JWT Authentication — Secure API access with Bearer tokens
• 🔑 API Keys — Non-expiring keys for server-to-server communication
• 💳 Transactions — ACID transactions via X-Transaction-ID header
• 🖥️ Web Dashboard — Built-in admin UI for managing the database

SoliDB provides native client libraries for multiple languages. See Client Documentation for installation and usage details.

• Node.js (solidb-client)
• Python (solidb)
• Go (solidb-go-client)
• PHP (solidb/php-client)
• Ruby (solidb)
• Elixir (solidb)

# Clone and build
git clone https://github.com/solisoft/solidb
cd solidb
cargo install --path .

# Start the server
solidb

The server starts on http://localhost:6745 with a web dashboard.

Note: A default admin user is created on startup with a randomly generated password displayed in the logs.

Prebuilt binaries are published for each release:

On Linux and macOS, install.sh fetches and installs the right one. On Windows, extract the .zip and add the folder to your PATH, then run solidb.exe --port 6745 --data-dir .\data.

Two Windows caveats: --daemon is Unix-only and exits with an error — run SoliDB in a console, or wrap it with a service manager such as NSSM or sc.exe. And the generated .admin_password file under the data directory is written with default ACLs rather than the owner-only permissions used on Unix, so restrict the data directory yourself on a shared machine.

sudo apt-get install -y build-essential clang libclang-dev pkg-config libzstd-dev

sudo pacman -S base-devel clang gcc pkg-config zstd

Requires the MSVC build tools, CMake, and LLVM (RocksDB's bindgen needs libclang):

winget install Microsoft.VisualStudio.2022.BuildTools Kitware.CMake LLVM.LLVM

Expect a long first build — RocksDB is a large C++ tree.

Visit the full documentation for:

• Getting started guide
• API reference
• SDBQL query syntax
• Cluster setup
• Lua scripting
• And much more!

O'Saasy License