SQLite: Past, Present, and Future
https://vldb.org/pvldb/volumes/15/paper/SQLite%3A%20Past%2C%20Present%2C%20and%20FutureA very neat deep dive into SQLite performance on OLAP problems, including a surprise optimisation for star schema type workloads using bloomfilters! This paper shows that compared to DuckDB, SQLite is great at transactional workloads, but not so great at analytical workloads (not a surprise!).
Tags
Related By Tags
- 🔗 Duckdb - an embedded analytics database
- 🔗 Savepoints (SQLite)
- 🔗 Pragma statements supported by SQLite
- 🔗 Getting Started - Litestream
- 🔗 Simple declarative schema migration for SQLite
- 🔗 Datasette — Datasette documentation
- 🔗 Fast Dictionary-Based Compression for Inverted Indexes | Proceedings of the Twelfth ACM International Conference on Web Search and Data Mining
- 🔗 ClickHouse Playground
- 🔗 Some SQL Tricks of an Application DBA | Haki Benita
- 🔗 Performance is a UX problem | Clearleft
Details
- Revised
- Created
- Edited