Remix.run Logo
pibaker 5 hours ago

GP calls out concurrency as a weakness of SQLite. Most of the examples here don't experience the same load even a moderately sized web service experience day to day.

And no, being a part of the python standard library doesn't means it is being used by the average python user. These days I'd say at least half of them are just there for machine learning.

OutOfHere 3 hours ago | parent [-]

SQLite is good for read-concurrency, not great for write-concurrency.

simonw 3 hours ago | parent [-]

SQLite requires writes run sequentially. Most SQLite write operations take single digit milliseconds or even microseconds. If your writes are inexpensive (inserting or updating single small rows) you'll probably never even notice the queue.