Ask HN: Have you ever used SQLite as a client/server DB for a high volume site?

Re:Ask HN: Have you ever used SQLite as a client/server DB f... by falcor84 on Tuesday November 26, 2019 @07:42PM (#21644275)

That "100k hits" figure you quoted surprised me, so after going over their page, I just wanted to add here that that's "100K hits/day", which translates to just 1 query per second, which is unreasonably conservative.

In a post [0] from last year, Expensify tell how (with some modifications) they managed to get sqlite to 4M qps on a single powerful server running 192 cores. That's 20K qps/thread for their huge table, and they got over 200K qps/thread for a table with a single row (demonstrating how little overhead sqlite has).

[0] https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...

[ Parent | on HN ]

Re:Ask HN: Have you ever used SQLite as a client/server DB f... by pizzaparty2 on Wednesday November 27, 2019 @09:02AM (#21647870)

At that point why not use a heavier database that one would expect to be faster?

[ Parent | on HN ]

Re:Ask HN: Have you ever used SQLite as a client/server DB f... by masukomi on Thursday November 28, 2019 @10:19PM (#21661745)

check out the numbers on SQLite. It's incredibly fast and beats PostgreSQL on a number of benchmarks.

[ Parent | on HN ]

Re:Ask HN: Have you ever used SQLite as a client/server DB f... by elamje on Tuesday November 26, 2019 @10:21PM (#21644977)

Very nice write up! I haven’t found a blog about SQLite at that scale anywhere.

[ Parent | on HN ]