SQLite performance comparison in production

[andrecasal]

I've been searching for days and I can't seem to find a first-principles analysis of how SQLite compares to other databases, in terms of performance, in a production environment.

Most comparisons say things like "SQLite is faster than X" or "SQLite is slower than Y". But they don't show real numbers.

Also, no one seems to be aware that database performance is not everything that matters. If the application lives on server A and the database on server B, network latency and max load put a cap on the maximum number of reads and writes you can do per second. So, in that circumstance, after a certain point, network load is your bottleneck.

Does anyone know of a first-principles benchmark of SQLite vs Posgres vs MySQL vs MongoDB (and other famous DBs)?

Also, am I missing something? 😅