I'm all-in on server-side SQLite
&gt; SQLite isn&#x27;t just on the same machine as your application, but actually built into your application process. When you put your data right next to your application, you can see per-query latency drop to 10-20 microseconds. That&#x27;s micro, with a μ. A 50-100x improvement over an intra-region Postgres query.<p>This is the #1 reason my exuberant technical mind likes that we use SQLite for all the things. Latency is the exact reason you would have a problem scaling any large system in the first place. Forcing it all into one cache-coherent domain is a really good way to begin eliminating entire universes of bugs.<p>Do we all appreciate just how much more throughput you can get in the case described above? A 100x latency improvement doesn&#x27;t translate <i>directly</i> into the same # of transactions per second, but its pretty damn close if your I&#x2F;O subsystem is up to the task.