How the SQLite virtual machine works

Re:How the SQLite virtual machine works by bob1029 on Wednesday September 07, 2022 @05:11PM (#32756942)

> 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.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by endisneigh on Wednesday September 07, 2022 @05:46PM (#32757408)

Stats on your service/app and workload?

[ Parent | on HN ]

Re:How the SQLite virtual machine works by bob1029 on Wednesday September 07, 2022 @07:41PM (#32758841)

We 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.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by Abishek_Muthian on Thursday September 08, 2022 @03:38AM (#32762478)

> 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?

[ Parent | on HN ]