News for hackers. Stuff that matters.
Re:Cold Showers: For when people get too hyped up about things by thomascgalvin on Friday July 24, 2020 @09:24AM (#23939157)
To me, this is the most important line in the article:

> SQLite scales almost perfectly for parallel read performance (with a little work)

They aren't using stock SQLite, they're using SQLite wrapped in Bedrock[1], and their use case is primarily read-only.

SQLite is fantastic at read-only, or read-mostly, use cases. You start to run into trouble when you want to do concurrent writes, however. I tried to use SQLite as the backend of a service a couple of years ago, and it locked up at somewhere around tens of writes per second.

[1]: www.bedrockdb.com

There are no comments on this comment yet.