Excellent write up. Especially the part about SQLite PRAGMAs is very helpful (my web application is also SQLite-based). Thanks for sharing your experience.
Author here. Would be happy to answer any questions people have. I learned a lot from making this, and think a lot of it would be interesting to others making web apps in Python.