michabbb

#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

🧡 πŸ‘‡

Feb 28 at 2:06pmWeb
Show threadmichabbbFeb 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 threadmichabbbFeb 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 threadMichaΕ‚ FitaFeb 28
@michabbb When to expect #Diesel support?
Show threadmichabbbMar 6
@michalfita I'm not the developer of this project