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