Why SQLite succeeded as a database (2016)

Re:Why SQLite succeeded as a database (2016) by OrgNet on Wednesday February 19, 2020 @09:43PM (#22372276)

Doesnt sqlite fail fast when many users commit at once?

[ Parent | on HN ]

Re:Why SQLite succeeded as a database (2016) by samatman on Wednesday February 19, 2020 @11:57PM (#22372787)

There's a level of write-heaviness after which SQLite, even in WAL mode, is the wrong choice.

But one can get pretty far with this design. Thousands of writes per second from a few dozen writers, no problem. Millions and hundreds, I'd use something else for that.

[ Parent | on HN ]

Re:Why SQLite succeeded as a database (2016) by Scarbutt on Thursday February 20, 2020 @01:05AM (#22373050)

Or if you have 10,000 writers each taking 10ms, that's 100 WPS, not bad for most apps.

[ Parent | on HN ]