https://a2zfacts.net/articles/sqlite-past-present-and-future/
SQLite: Past, Present, and Future
Saturday, September 24, 2022
“Being designed as an OLTP database, SQLite employs row-oriented execution… However, there is a growing need for efficient in-process online analytical processing (OLAP)…. This paper… delves into analytical data processing on SQLite…”