Excellent write up. Especially the part about SQLite PRAGMAs is very helpful (my web application is also SQLite-based). Thanks for sharing your experience.
Thanks! Glad you found it useful. SQLite actually works really well for tons of applications where people often assume you need Postgres, and the simplicity of setting it up and backing it up is extremely compelling.
You can really help things a lot with the PRAGMAs, and if that doesn't work, you can use something like an async DB write queue pattern to deal with the simultaneous write limitations (and also by doing more stuff with transactions and bulk insertions).
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.
Excellent write up. Especially the part about SQLite PRAGMAs is very helpful (my web application is also SQLite-based). Thanks for sharing your experience.
Thanks! Glad you found it useful. SQLite actually works really well for tons of applications where people often assume you need Postgres, and the simplicity of setting it up and backing it up is extremely compelling.
You can really help things a lot with the PRAGMAs, and if that doesn't work, you can use something like an async DB write queue pattern to deal with the simultaneous write limitations (and also by doing more stuff with transactions and bulk insertions).
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.