By removing network latency, a major bottleneck for databases like Postgres, SQLite avoids Amdahl's Law. The single writer allows for easy batching, enabling it to handle over 100,000 transactions per second with serializable isolation in benchmarks, outperforming a networked database in this scenario.

https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html

#programming #sqlite #clojure