bert hubert 🇺🇦🇪🇺 on Nostr: I'm a huge SQLite fanboy, which why I was pretty worried when my mailing list ...

I'm a huge SQLite fanboy, which why I was pretty worried when my mailing list software was getting SQLITE_BUSY errors despite setting a timeout. Turns out databases and transactions are tricky. Here is an overview of what happens in various databases when multiple connections try to write. And specifically, how to make this work well for SQLite: https://berthub.eu/articles/posts/a-brief-post-on-sqlite3-database-locked-despite-timeout/