SoliDB is a multi-model database in a single Rust binary.

# metrics is a columnar collection, hosts a document one
FOR m IN metrics
  FILTER m.cpu > 50
  FOR h IN hosts
    FILTER h._key == m.host
    RETURN {region: h.region, cpu: m.cpu}

→ [{"cpu": 58.0, "region": "eu-west"},
   {"cpu": 72.5, "region": "eu-west"},
   {"cpu": 90.0, "region": "us-east"}]

LET per_day = COUNT_BY((FOR o IN orders RETURN o),
                       o -> DATE_TRUNC(o.at, "day"))
FOR d IN DATE_SERIES("2024-03-01", "2024-03-04", "day")
  RETURN {day: LEFT(d, 10), orders: per_day[d] || 0}

→ [{"day": "2024-03-01", "orders": 2},
   {"day": "2024-03-02", "orders": 0},
   {"day": "2024-03-03", "orders": 1},
   {"day": "2024-03-04", "orders": 0}]

POST /_api/auth/users/bob/roles
  {"role":"editor","database":"v"}
→ 201 {"username":"bob","role":"editor","database":"v", …}

bob reads   v                → 200
bob writes  v                → 200
bob reads   other            → 403
bob writes  other            → 403
bob creates a database       → 403

# ana holds the editor role
curl -X POST …/_api/database/blog/document/_scripts \
  -H "authorization: Bearer $T" \
  -d '{"name":"pwn","path":"pwn","code":"return 1"}'

→ HTTP 403
{"code": 403,
 "error": "Access denied: '_scripts' is managed by the
   server and is not writable through this API; use
   the dedicated admin endpoints",
 "type": "Forbidden"}

# n2 log
Sent join request to 127.0.0.1:6923
Successfully joined cluster. Received 2 peers.
Starting full sync: 1 databases, 7 documents
Full sync complete, final sequence: 5

# query on n2
FOR n IN notes RETURN {key: n._key, from: n.from}
→ [{"from": "n1", "key": "hello"}]