Hacker News new | ask | show | jobs
by HackerThemAll 9 days ago
Have you ever contemplated the true performance of SQLite? Expensify reached 4M point database queries per second, and an artificial (more like parser-testing, not database-touching) 160M qps. If your backend is on a single machine of predictable performance, and you properly index your queries, and you don't require remote DB connections, you don't need anything else but SQLite for 95% of use cases.

https://use.expensify.com/blog/scaling-sqlite-to-4m-qps-on-a...