Use Cases

One Database.
Every Workload.

From a Raspberry Pi running predictive maintenance on factory floors to hyperscale AI platforms processing millions of embeddings per second — Absolute DB handles it all without reaching for another tool.

🤖
Use case 01

AI & Machine Learning Platforms

The first database built for the AI era from the ground up — not retrofitted. Store, search, and reason over vectors, documents, and structured data in a single query, without stitching together three separate systems.

  • Vector similarity search: HNSW index with sub-0.1 ms top-10 retrieval across millions of embeddings — no separate vector database needed.
  • Hybrid search: combine full-text BM25 scoring with vector cosine similarity in one query for retrieval quality that neither approach achieves alone.
  • RAG pipelines: chunk, embed, and retrieve in a single workflow — no orchestration layer, no Redis sidecar, no Pinecone subscription.
  • Agent memory: persistent agent state with TTL and automatic consolidation, designed for long-running LLM agents.
sql — hybrid search: BM25 + vector cosine in one query
SELECT id, title, HYBRID_SEARCH('customer refund policy', embedding_col) AS score
FROM knowledge_base
ORDER BY score DESC
LIMIT 5;
Sub-0.1 ms top-10 vector search • Auto-embedding on INSERT/UPDATE • ColBERT multi-vector MaxSim
🏥
Use case 02

Healthcare & Life Sciences

HIPAA-compliant by default. PHI stays protected without compromising query performance — compliance is enforced at the database layer so your application code stays clean.

  • Automatic PHI tagging: mark columns as protected health information and every read and write is recorded in a tamper-evident audit trail.
  • Column-level AES-256-GCM encryption: SSN, date-of-birth, and diagnosis codes encrypted independently — a breach of one field exposes nothing else.
  • Row-level security: clinicians see only their own patients' records; researchers see only de-identified cohorts — enforced by the database, not the application.
  • Instant audit reports: comprehensive HIPAA access reports generated in seconds for any date range, ready for OCR compliance reviews.
sql — PHI tagging and HIPAA access report
ALTER TABLE patients ALTER COLUMN ssn SET (hipaa_phi = true);
ALTER TABLE patients ALTER COLUMN diagnosis_code SET (hipaa_phi = true);

SELECT * FROM absdb_hipaa_access_report('2026-01-01', '2026-03-31');
136 security tests • Zero failures • Every release
📡
Use case 03

IoT & Edge Computing

The only production-grade database that fits in 154 KB and runs on a Raspberry Pi Zero with 512 MB RAM. Full SQL, time-series, full-text search, and vector search — all in one binary, on the device.

  • Genuinely tiny: 154 KB stripped binary — smaller than most JPEG thumbnails. No runtime installation, no dependency resolution, no package manager.
  • Runs everywhere: ARM Cortex-A (Raspberry Pi), x86 embedded, and WebAssembly (browser, Cloudflare Workers) from the same source build.
  • Time-series primitives: automatic downsampling, gap-filling, sliding-window aggregates for sensor data, telemetry, and machine readings.
  • Offline-first sync: local writes continue when connectivity drops; Raft-based replication syncs to cloud clusters when the connection returns, with automatic conflict resolution.
sql — sliding-window aggregate on sensor data
SELECT
  time_bucket('5 minutes', recorded_at) AS bucket,
  AVG(temperature)                       AS avg_temp,
  MAX(vibration_hz)                      AS peak_vibration
FROM machine_telemetry
WHERE recorded_at > NOW() - INTERVAL '1 hour'
GROUP BY bucket
ORDER BY bucket DESC;
< 1.5 MB RAM at idle • 154 KB binary • No installation prerequisites
🚀
Use case 04

SaaS Platforms

Replace eight specialised database tools with one. Eliminate database sprawl before it starts — vector search, full-text, time-series, graph, and OLTP in a single deployment that your existing ORM already speaks.

  • Multi-tenancy: row-level security isolates tenant data at the database layer — no separate schema per tenant, no application-layer filtering that can be bypassed.
  • Drop-in compatibility: PostgreSQL wire protocol means existing drivers, ORMs, and tooling work on day one — no client code changes required.
  • Live query push: WebSocket subscriptions deliver changes to clients in real time at 14.9M+ notifications/sec — no polling, no message queue, no Redis pub/sub.
  • Compliance built-in: GDPR right-to-erasure, column-level data lineage, and tamper-evident audit logs for regulated SaaS without a compliance sidecar.
Works with Prisma, Django ORM, Rails ActiveRecord, Sequelize, JDBC, node-postgres, psycopg2 — no code changes
sql — tenant isolation with row-level security
-- Each tenant can only see their own rows — enforced by the database
CREATE POLICY tenant_isolation ON orders
  USING (tenant_id = current_setting('app.tenant_id')::uuid);

-- Live push to subscribed clients
SUBSCRIBE TO TABLE orders WHERE tenant_id = $1 AND status = 'pending';
🏢
Use case 05

Enterprise OLTP

Full ACID transactions, high availability, zero-downtime operations. All the capability of Oracle or enterprise PostgreSQL — without the licence tax, the mandatory consultants, or the weekend upgrade windows.

  • Full ACID transactions: snapshot isolation, savepoints, and full rollback — correct behaviour under every failure mode, verified by 168 distributed tests.
  • Raft-based high availability: automatic leader election and failover, zero data loss on node failure, read-only replicas for query offload.
  • Online schema changes: ALTER TABLE runs non-blocking in the background — production tables stay fully available during column additions, index builds, and type changes.
  • Continuous replication: streaming CDC to read replicas, disaster-recovery sites, and downstream consumers via Debezium-compatible JSON.
sql — ACID transaction with savepoints
BEGIN;
  INSERT INTO orders (customer_id, total) VALUES ($1, $2) RETURNING id;
  SAVEPOINT order_created;

  INSERT INTO order_items (order_id, sku, qty) VALUES ($3, $4, $5);

  -- Something went wrong with this item only
  ROLLBACK TO SAVEPOINT order_created;

  -- Retry with corrected data
  INSERT INTO order_items (order_id, sku, qty) VALUES ($3, $6, $5);
COMMIT;
≥ 650,000 inserts/sec • < 2 µs point query latency • Direct API
🧑‍💻
Use case 06

Developer Tools & Embedded Applications

The SQLite upgrade path that doesn't require a separate server. Embed Absolute DB in any C/C++ application with a two-line include — and get vector search, full-text, graph traversal, JSON, and time-series that SQLite simply doesn't have.

  • Zero configuration: open an in-process database with a single call — no server, no setup, no config file, no background process to manage.
  • Richer than SQLite: vector search, full-text BM25, graph traversal, JSONB, time-series aggregates, and full SQL:2023 support all built in.
  • Server mode on demand: expose the same embedded database as a PostgreSQL-compatible server with one flag change — your psql, pgAdmin, and Prisma clients connect immediately.
  • WASM target: compile to WebAssembly and run in the browser or Cloudflare Workers with IndexedDB persistence — same API, same SQL, same data.
c — embed Absolute DB in any C/C++ application
#include "absolute.h"

int main(void) {
    absdb_t *db;
    absdb_result_t *res;

    /* Open an in-process database — no server required */
    absdb_open(":memory:", &db);

    absdb_exec(db, "CREATE TABLE events (id INTEGER PRIMARY KEY, payload TEXT)");
    absdb_exec(db, "INSERT INTO events (payload) VALUES ('hello, world')");

    absdb_query(db, "SELECT * FROM events", &res);
    while (absdb_result_next(res)) {
        printf("id=%lld  payload=%s\n",
               absdb_result_int64(res, 0),
               absdb_result_text(res, 1));
    }
    absdb_result_free(res);

    /* Expose as a PostgreSQL-compatible server — one flag */
    /* absdb_serve(db, "0.0.0.0", 5432); */

    absdb_close(db);
    return 0;
}
Single header include • 154 KB binary • Zero runtime dependencies
Ready to consolidate?

Stop managing eight databases. Use one.

Download the binary and have a working database in under two minutes — or talk to us about a deployment that fits your stack.