Setting Up Solid Cache on Heroku with a Single Database

I ran into an issue trying to deploy a Rails 8 app to Heroku that was using Solid Cache. This was for a small MVP and ultimately I wanted to use the Solid stack (cache, queue, job) but wanted this to run off a single database on a PaaS like Heroku. The following outlines what I did to get this working.