Mastodawn

#Stoolap – A Modern Embedded #SQL #Database written in #Rust 🦀 #opensource #database #rust

🔐 Full #ACID compliance with #MVCC – Multi-Version Concurrency Control for safe, parallel transactions without locking conflicts

⏳ Time-Travel Queries: retrieve historical data at any past timestamp or specific transaction ID – a rare and powerful feature

📊 Four index types: B-Tree, Hash, Bitmap & Composite – chosen automatically by the optimizer or specified manually for peak performance

🧵 👇

Show thread

michabbb Feb 28

🪟 Full Window Function support: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE, FIRST_VALUE, LAST_VALUE & more for analytical workloads

🔄 Common Table Expressions including recursive CTEs for complex hierarchical and graph-style data queries

📈 Advanced aggregations: ROLLUP, CUBE & GROUPING SETS for multi-dimensional reporting and subtotal calculations

💾 Write-Ahead Logging (WAL) + periodic snapshots for crash-safe persistence – runs in both in-memory and file-based modes

Show thread

michabbb Feb 28

🔧 Cost-based query optimizer with full EXPLAIN / EXPLAIN ANALYZE support and table statistics via ANALYZE

📦 100+ built-in functions across string, math, date/time, JSON and aggregate categories – batteries fully included

🛠️ Simple integration via Cargo with a single dependency: stoolap = "0.1" – plus a CLI tool for REPL or direct query execution
https://github.com/stoolap/stoolap

GitHub - stoolap/stoolap: A Modern Embedded SQL Database written in Rust

A Modern Embedded SQL Database written in Rust. Contribute to stoolap/stoolap development by creating an account on GitHub.

GitHub

Show thread

Michał Fita Feb 28

@michabbb When to expect #Diesel support?

Show thread

michabbb

@michalfita I'm not the developer of this project