SQLite database is locked in Rails 8

I was pleased to discover Rails 8 would be using SQLite and Solid Queue to replace Redis and a job queue such as Resque. This caught my attention because in 2017, I wrote a blog post on my company blog about using SQLite with a Queue. However my solution was radically different from the one implemented in Rails 8, so that's what I'll discuss below.