Many Small Queries Are Efficient in SQLite

If you haven't tried SQLite, please do. For years I ignored SQLite and used MySQL (it does the job) but once you see how fast SQLite is, and advantages of having a DB contained in a single file... just go play around with SQLite instead of ignoring it for years like me. It's neat.

I am using SQLite on paperless-ngx (an app to manage pdf [4]). It is quite difficult to beat SQLite if you do not have a very huge parallelism factor in writes. SQLite is an embedded database: no socket to open, you directly access to it via file system. If you do not plan to use BigData with high number of writers, you will have an hard time beating SQLite on modern hardware, on average use cases. I have written a…

I built a rules engine around SQLite queries for the last product I was working on. This article was the reason. You can run an unbelievable # of select statements per unit time against a SQLite database. I think of it like a direct method invocation to members of some List<T> within the application itself. Developers who still protest SQLite are really sleeping on the latency advantages. 2-3 orders of magnitude are really hard to fight against. This opens up…

I’m glad this was written out because I’ve deeply internalized that many queries => bad. Good to know the overhead for a query is that low