Welcome to this first message from the list “Bert Hubert Nerd Stuff”!
And it is immediately a bit meta. Not only do I reinvent wheels, I also reinvent rubber. This mailing list is powered by freshly written software, for reasons that take some explaining. Maybe one day.
While developing ckmailer and sending out the first few messages, I got an SQLITE_BUSY error, something I found hard to understand. So I got busy trying to find that out.
The result is this blog post, in which I cover the various defined SQL transaction isolation modes. To my surprise, SQLite by default runs in the rather stringent ‘serializable’ mode. And perhaps equally unexpected, the PostgreSQL default is less stringent than that used by MySQL InnoDB. But do know these are just defaults.
I hope you’ll enjoy these surprises as much as I did, and perhaps the post will save you some pain later on. It has advice on how to never ever get SQLITE_BUSY errors in SQLite.
Cheers,
Bert