Getting Started with ScramDB
ScramDB is an adaptive HTAP SQL database that compiles queries to native machine code. It speaks the PostgreSQL wire protocol - connect with psql or any PostgreSQL driver.
Why ScramDB?
Most databases force you to choose: fast analytics or easy SQL. ScramDB gives you both.
| Traditional OLAP | ScramDB | |
|---|---|---|
| Query language | Proprietary or limited SQL | Full PostgreSQL-compatible SQL |
| Query execution | Interpreted or vectorized | JIT-compiled to native machine code |
| Parallelism | Thread pool | Core-pinned morsel-driven (linear scaling) |
| Storage | Row-store or external files | Purpose-built columnar engine (Tundra) |
| Vector search | Separate system | Built-in pgvector-compatible |
| GPU acceleration | Not available | Built-in for NVIDIA, AMD, Apple Metal |
| Client compatibility | Custom drivers needed | Any PostgreSQL driver works |
| Transactions | Often missing | Full MVCC with serializable isolation |
No new query language. No proprietary SDK. No vendor lock-in. Just connect with psql and run SQL.
What is ScramDB?
ScramDB is a high-performance analytical database written in Rust, designed for:
- OLAP analytics - Sub-second complex queries over millions of rows
- HTAP workloads - Mix transactional and analytical queries on the same data
- Vector search - pgvector-compatible similarity search
- Real-time dashboards - Streaming query results with backpressure
Key Capabilities
| Feature | Details |
|---|---|
| Query execution | JIT compilation, morsel-driven parallelism |
| SQL support | 72+ functions, window functions, CTEs, subqueries |
| Storage | Tundra columnar engine with zone maps |
| Transactions | MVCC (Read Committed → Serializable) |
| Protocol | PostgreSQL wire protocol |
| Indexing | ART, B+Tree, Hash |
| Vector search | pgvector-compatible VECTOR(n) type |
Quick Links
🚀 Quick Start
Get running with Docker in 2 minutes
📚 SQL Reference
Complete SQL compatibility reference
Next Steps
- Quick Start - Docker setup and first connection
- First Queries - Create tables and run SQL
- SQL Reference - Full SQL compatibility
- Benchmarks - TPC-H performance results