The SQLite developers seem to be experimenting with a solution to that: https://sqlite.org/hctree https://sqlite.org/hctree The announcement blog post: https

The SQLite developers seem to be experimenting with a solution to that: https://sqlite.org/hctree https://sqlite.org/hctree The announcement blog post: https://sqlite.org/forum/forumpost/d9b3605d7ff40cf4 https://sqlite.org/forum/forumpost/d9b3605d7ff40cf4 HN thread about it from a few months ago: https://news.ycombinator.com/item?id=34434025 https://news.ycombinator.com/item?id=34434025