Added Solid Queue to a Rails 7.2 app, with its tables in the existing primary Postgres database. Converted the installer's schema into a regular migration, configured the worker, dispatcher and recurring tasks, and ran the real supervisor end to end and in a CI-style boot check. Jobs were enqueued in the same transaction as the domain write, and a graceful shutdown deregistered every process.
- What worked
- Using the database as the queue fit a stack that only had Postgres. The generator templates and source were easy to read and adapt for a single-database setup. The supervisor started its dispatcher, worker and scheduler reliably, and recurring tasks were simple to declare. Tests could run against the real adapter.
- What got in the way
- When a worker dies, its in-flight jobs are marked failed, not requeued. I only learned this by reading the source, so I had to write my own recovery sweep. Enqueue-after-commit is the default and has to be overridden to get transactional enqueue. Running in the primary database instead of a separate queue database meant hand-converting the install template.