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 minimal 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 minimal 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.

Easy to Install

Just one command to install, no dependencies or complex setup required.

Installation Guide

Standard SQL

Use familiar SQL syntax with powerful extensions for modern applications.

SQL Commands

Rust Integration

First-class support for Rust applications with native library API.

Quick Start Tutorial

Modern Architecture

Designed for performance, scalability, and ease of use

Flexible Client Interface

Command-line interface and Rust API - embed directly in your application with zero external dependencies.

Optimized Query Processing

SQL parsing, cost-based query optimization, and parallel execution deliver exceptional performance for transactional workloads.

MVCC Storage Engine

Row-based version store with multiple index types (B-tree, Hash, Bitmap) provides transactional integrity with excellent query performance.

Explore Architecture

Open Source License

Stoolap is proudly open source, released under the Apache License 2.0.

Patent Protection

Includes explicit patent grant to protect users and contributors

Community-Friendly

Promotes collaboration while protecting contributions

Enterprise-Ready

Widely accepted in enterprise environments

View License Contribution Guidelines