Hacker News new | ask | show | jobs
by hnarn 11 days ago
Moving from MariaDB to SQLite and not Postgres for a web application of this scale is insane. I wonder what went into the discussion behind this.
2 comments

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...

The web app typically sees 10 rps and most of those don't write.