Stoolap - High-performance embedded SQL database in Rust

A Modern Embedded SQL Database in Pure Rust

Full ACID transactions with MVCC, cost-based query optimizer, multiple index types (B-tree, Hash, Bitmap), parallel execution, and zero unsafe code.

Get Started GitHub

Why Stoolap?

Modern database design for today's application demands

High Performance

Row-based storage with multiple index types (B-tree, Hash, Bitmap) and parallel query execution deliver exceptional speed for analytical and transactional workloads.

Memory-First

Designed with in-memory operation in mind while providing optional persistence for durability. Ideal for both high-throughput and real-time applications.

Cost-Based Optimizer

PostgreSQL-style cost-based query optimizer with adaptive execution, cardinality feedback, and intelligent join ordering for optimal performance.

Pure Rust

Built entirely in Rust with zero unsafe code, providing memory safety guarantees and enabling simple deployment without runtime dependencies.

MVCC Transactions

Multi-Version Concurrency Control provides high isolation with minimal locking. Optimistic concurrency enables high throughput for mixed workloads.

SQL Standard

Supports modern SQL including JOINs, window functions, and advanced query features. Built for compatibility with existing SQL knowledge and tools.

Get Started in Minutes

Simple to install, easy to use

terminal

$ cargo install stoolap
$ stoolap
Stoolap SQL Database
Connected to in-memory database
stoolap> CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
Table created.
stoolap> INSERT INTO users VALUES (1, 'John Doe');
1 row inserted.
stoolap> SELECT * FROM users;
+----+----------+
| id | name     |
+----+----------+
| 1  | John Doe |
+----+----------+
1 row in set.