[PDF] SQLite: Past, Present, and Future - VLDB Endowment

tinues to be the most widely used database engine in the world, the drastic changes in both hardware capabilities and software demands have exposed SQLite to a unique set of challenges. The expansion of hardware capabilities calls for a deeper evalua- tion into the underlying implementation of SQLite. Notably, SQLite generally does not use multiple threads, which limits its ability … use cases of embeddable database engines, they are representative of the most common workloads. We identify key bottlenecks in SQLite’s OLAP performance, discuss the tradeoffs of potential so- lutions, and present the performance impact of our optimizations. Finally, we discuss the “footprint” of SQLite: the amount of memory