Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: