159
SQLite (programming.dev)
submitted 2 months ago by tatterdemalion@programming.dev to c/programmer_humor@programming.dev
19 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[-] ulterno@programming.dev 0 points 2 months ago

SQLite puts all of the responsibility on users to handle this

Thanks for the explanation.
I feel like the one who decided this behaviour, expected the users of the database, to make their own system of prioritising the transactions.

[-] F04118F@feddit.nl 2 points 2 months ago

More likely: SQLite is built to be small, simple and lightweight, not to be super highly concurrent.

If this situation happens rarely, just make sure you have a retry on the query. If it happens often, switch to postgres.

this post was submitted on 08 Nov 2025
159 points (97.6% liked)

Programmer Humor

29147 readers
276 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
Feyter@programming.dev
anzo@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev