What to do about SQLITE_BUSY errors despite setting a timeout

I've written about this a few times before, so I just started a sqlite-busy tag to collect my notes together on a single page.