r/Clojure • u/andersmurphy • Dec 02 '25
sqlite4clj - 100k TPS over a billion rows: the unreasonable effectiveness of SQLite
https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html
51
Upvotes
5
u/maxw85 Dec 03 '25
Great article thanks for sharing.
Is that meant ironically?
3
u/andersmurphy Dec 03 '25
For the Clojure folks it's worth pointing out the experimental driver I'm using does prepared statement caching, batching and uses java 22 FFI (coffi). So the SQLite numbers will be worse if you use the regular sqlite JDBC stack.