5 ms·
> I’d like to use a web service or app backed primarily by SQLite and see how it goes. We've been doing this in production for over half a decade now. It goes
by bob1029 4y ago
> I’d like to use a web service or app backed primarily by SQLite and see how it goes.
We've been doing this in production for over half a decade now. It goes so well it becomes boring very quickly.
- endisneigh 4y agoStats on your service/app and workload?
- bob1029 4y agoWe shard out to 1 SQLite database per user's working session, so there really isn't a meaningful figure if you are looking for apples-to-apples in a traditional sense. Our most heavily loaded SQLite instance probably sees 100 writes per second. In aggregate, we can handle tens of thousands of requests per second.
- Abishek_Muthian 4y ago> 1 SQLite database per user's working session I presume you've designed your application to accommodate only the data types offered by SQLite and without any concurrent writing?