Reading up on TxtAI

1 deep · digging since dec 05, 25

100k TPS over a billion rows: the unreasonable effectiveness of SQLite
SQLite achieves over 100k transactions per second on a billion-row dataset by avoiding network overhead, though durability and HA remain trade-offs.