Ask HN: Have you used SQLite as a primary database?
Here's an all-time great post about why you might consider SQLite in production with data about performance: <a href="https://blog.wesleyac.com/posts/consider-sqlite" rel="nofollow">https://blog.wesleyac.com/posts/consider-sqlite</a><p>I use SQLite in production for my SaaS[1]. It's really great — saves me money, required basically no setup/configuration/management, and has had no scaling issues whatsoever with a few million hits a month. SQLite is really blazing fast for typical SaaS workloads. And will be easy to scale by vertically scaling the vm it's hosted on.<p>Litestream was the final piece of the missing puzzle that helped me use it in production — continuous backups for SQLite like other database servers have: <a href="https://litestream.io/" rel="nofollow">https://litestream.io/</a> With Litestream, I pay literally $0 to back up customer data and have confidence nothing will be lost. And it took like 5 minutes to set up.<p>I'm so on-board the SQLite train you guys.<p>[1] <a href="https://extensionpay.com" rel="nofollow">https://extensionpay.com</a> — Lets developers take payments in their browser extensions.