Stoolap: A Modern Embedded SQL Database Built in Rust with Advanced Features
By
murat3ok
Slow-proofed and worth the wait. Worth its weight in flour.
Summary
Stoolap is a modern embedded SQL database written in Rust that targets low-latency transactional workloads and real-time analytical queries. It offers advanced features including AS OF time-travel queries, MVCC transactions, hot/cold columnar storage, cost-based optimizer, adaptive query execution, semantic query caching, and parallel query execution. The article compares Stoolap's capabilities against SQLite, DuckDB, and PostgreSQL, highlighting its unique features for embedded database applications.
Key quotes
· 5 pulledStoolap is a feature-rich embedded SQL database built in pure Rust.
It targets low-latency transactional workloads and real-time analytical queries, with modern SQL features and no external server process.
Stoolap is designed around practical embedded database needs.
AS OF Time-Travel Queries: ✅ Stoolap, ❌ SQLite, ❌ DuckDB, ❌ PostgreSQL*
MVCC Transactions: ✅ Stoolap, ❌ SQLite, ✅ DuckDB, ✅ PostgreSQL
You might also wanna read
PgQue: Zero-Bloat Postgres Queue System Using Pure SQL and pg_cron
PgQue is a zero-bloat Postgres queue system that revives the PgQ architecture originally designed at Skype for handling messaging for hundre
github.com·1mo ago
Lux: A Multi-threaded Redis-Compatible Key-Value Store with Vector Search and 10x Performance Gains
Lux is a Redis-compatible key-value store written in Rust that offers up to 10x faster performance than Redis. It addresses Redis's single-t
github.com·2mo ago
SNKV: A Lightweight, Crash-Safe Embedded Key-Value Store Built on SQLite's Storage Engine
SNKV is a lightweight, crash-safe embedded key-value store built directly on SQLite's storage engine without the SQL layer. It provides a cl
github.com·3mo ago
HelixDB: Open-Source OLTP Graph-Vector Database Built in Rust Now Generally Available
HelixDB, an open-source OLTP graph-vector database built in Rust, has been released after more than a year of development. The database is d
Product Hunt·3mo ago
Alibaba's AliSQL: Enterprise MySQL Branch with DuckDB OLAP and Vector Search
AliSQL is Alibaba's enterprise-grade MySQL branch that combines traditional InnoDB OLTP reliability with DuckDB's columnar OLAP engine and n
github.com·3mo ago
Arc Core: High-Performance Time-Series Data Warehouse Built on DuckDB and Parquet
Arc Core is a high-performance time-series data warehouse built on DuckDB, Parquet, and MinIO, currently in alpha release as a technical pre
github.com·7mo ago