One of the best write ups I’ve seen on using SQLite in production is Consider SQLite: https://blog.wesleyac.com/posts/consider-sqlite https://blog.wesleyac.com/

One of the best write ups I’ve seen on using SQLite in production is Consider SQLite: https://blog.wesleyac.com/posts/consider-sqlite https://blog.wesleyac.com/posts/consider-sqlite I also use SQLite in production and it’s been pretty great so far. Serves about 50 requests per second from a single threaded Node app on a low tier DigitalOcean machine. To be fair, most of those are cache hits but it’s still be nice. It’s saved me money by not needing a separate db server and the operational simplicity is great. Biggest speed up I found was turning on memory mapping (which is different from an in-memory database that the article talks about).