4 ms·
Who exactly is using SQLite in production for non-trivial usecases (>10K QPS)?
by endisneigh 3y ago
Who exactly is using SQLite in production for non-trivial usecases (>10K QPS)?
- regularfry 3y agoWho exactly is defining triviality purely in terms of request rate?
- endisneigh 3y agoI think most. You don't need a database to do 1 request a day, for instance.
- mongol 3y agoIt depends on the usecase. A database is not only a data store, it can also be used as an analytics tool.
- regularfry 3y agoRequest rate doesn't dictate the need for a database. Next?
- endisneigh 3y agoOK.
- lanstin 3y agoI use it to provide persistence to an in memory counter server. It is written to in batches of 4096 (total 25k/second). For restarting he server, the server gets a signal, stops listening, flushes the remaining writes to SQLite, and exits. On start up, it reads the SQLite then starts processing accepted reads. It was a couple hundred lines of go and makes the server much better operationally. It is not involved in the request servicing, just this back up persistence.