Correctness first
Each timed request is checked against an independent Python model and a 2,038-check PostgreSQL oracle. A fast wrong answer scores zero.
Alpha · Pure Sig · Zero allocators
SQL at the speed
of memory.
RamSQL is an in-memory SQL server written entirely in Sig. PostgreSQL wire protocol, MVCC snapshots, durable WAL, and no heap allocator on the hot path.
0point reads / s, single worker, 1M rows
0vs IRDB 1.10.821, uniform reads at 1M rows
0vs PostgreSQL 18.3, filtered scan, 100k rows
Measured head-to-head against
PostgreSQL 18.3IRDB 1.10.821PostgreSQL 16
Performance
Built to out-run the field.
Operations per second on identical data, same host, same checks. Every request is validated against an independent model before it counts.
| Workload | RamSQL | IRDB |
|---|---|---|
| Uniform key lookup | 1,425,602 | 2,920 |
| Range page | 166,535 | 93 |
| Mixed 50/50 | 1,412,211 | 149 |
| Filtered SUM | 5,830 | 1,167 |
| Grouped aggregate | 1,251 | 628 |
| Top-k sort | 51 | 18 |
Latency
From text to rows in microseconds.
- Wire-compatible. Connect with
psql, JDBC and standard PostgreSQL drivers. - Allocator-free. Fixed-capacity, caller-owned storage. No GC pauses, no malloc on the query path.
- Columnar fast paths. Vectorized predicate masks and grouped COUNT/SUM kernels over committed column projections.
- Snapshot isolation. Shared MVCC storage. Readers never block writers.
Evidence
Every number is reproducible.
Benchmarks run from published harnesses in public GitHub Actions and local runs, with raw logs, binary hashes and source snapshots retained. We publish the cases where we are not first, too.
Latest versions
PostgreSQL 16 and 18 and the newest stable IRDB, verified against the live NuGet feed, run on the same host with matched settings.
Open methodology
Warmup, alternating engine order, five-trial medians, equal JVM heap. Commands and harnesses are in the repository.
Where we are still climbing
On a one-million-row analytic mix with eight clients IRDB currently leads. Joins, large working sets and recovery speed are in active qualification.
Engine
A database with nothing to waste.
⚡
Pure Sig
The whole runtime is Sig. No C libraries, no SQLite, no language runtime to load.
🔒
Durable by design
Flush-before-publication WAL, exclusive writer locking and fail-closed recovery.
🔑
SCRAM auth
PostgreSQL SCRAM credentials are required by default on the server.
⚖
Atomic statements
Statement atomicity and resource ownership on every error path.
📦
Bounded memory
Explicit capacity profiles. Inspect capacity before loading, no surprise growth.
🔄
Offline backup
Validated backups that never overwrite a destination.
Licensing
Free to learn on. Licensed to ship.
Personal & research
Free
- Personal, non-revenue projects
- Academic and non-profit research
- Teaching and evaluation
- Full engine, no feature limits
Business & all other use
Contact us
- Production and company use
- Hosting, redistribution and embedding
- Granted by SB0 LTD only
- Priority support and tuning
