Stoolap: High-performance embedded SQL database in pure Rust
2 days ago
- #rust
- #database
- #sql
- Stoolap is an embedded SQL database written in Rust with MVCC transactions and ACID compliance.
- Supports both in-memory and persistent storage modes.
- Easy integration via Cargo.toml or building from source.
- Provides a REPL interface for interactive SQL queries.
- Offers two isolation levels: Read Committed and Snapshot Isolation.
- Allows querying historical data at specific timestamps or transactions.
- Supports automatic and explicit index selection (B-tree, Hash, Bitmap).
- Full support for analytical queries, including window functions and recursive CTEs.
- Includes various subquery types (scalar, correlated, EXISTS, IN).
- Features a cost-based optimizer with statistics collection.
- Supports a wide range of data types and built-in functions.
- Uses write-ahead logging (WAL) with periodic snapshots for durability.
- Open-source under the Apache License 2.0.