Sam Hames

Currently: “Oh good, change is coming.”

SQLite: Past, Present, and Future

https://vldb.org/pvldb/volumes/15/paper/SQLite%3A%20Past%2C%20Present%2C%20and%20Future

A 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

Details

Revised
Created
Edited