Optimizing a large SQLite database for reading (jacobfilipp.com)

While doing some searching in conjunction with a recent front-page thread about using SQLite for hyper-scaling (one database per user or product), I bumped into this blog entry that got very few eyeballs when it was initially posted.

See also https://news.ycombinator.com/item?id=43244307