3 ms·
Sqlite is amazing performant and scalable, as long as you don't need high availability or horizontal scaling. While I don't recommend using sqlite in productio
by freedomben 8y ago
Sqlite is amazing performant and scalable, as long as you don't need high availability or horizontal scaling. While I don't recommend using sqlite in production, I have done it before and had a similar experience. Millions of rows with excellent performance. Just hope you never have to scale beyond what a single machine can handle tho :-)
- hobs 8y agoAgreed, I use SQL Server in my day job and always reached for PG when doing OSS stuff, was just blown away how well SQLite managed to hold up. Generally sharding/HA/DR are difficult problems with any db tech, so yeah, you are definitely right there.
- Quarrelsome 8y agoproduction isn't the issue, multi-user is the issue.