Because it changes the kinds of things you can build: https://www.sqlite.org/np1queryprob.html
With SQLite, it's often practical to issue several queries in situations where that would be too slow for a traditional client-server database.
With SQLite, it's often practical to issue several queries in situations where that would be too slow for a traditional client-server database.
Unless you’re talking 1 versus 10 microseconds (or less), I don’t think Postgres will have an order of magnitude higher latency. And if we are talking this range, why would it matter for a web app where the client’s latency is almost certainly >1 millisecond?