For Solid Cache to become a Rails 8 default, the configuration needs to be fully automated, such that we can run it as part of "rails new". This PR makes the installation a single step process, and commits to using a separate database for the default case.
This also converts the setup from using a migration to providing the full SC db as a schema. This is needed in order to only have the cache db configured in production. Otherwise you also need it configured in development, even if you're not using it, or the migration installation won't run. It's better anyway like this.
For Solid Cache to become a Rails 8 default, the configuration needs to be fully automated, such that we can run it as part of "rails new". This PR makes the installation a single step process, and commits to using a separate database for the default case.
This also converts the setup from using a migration to providing the full SC db as a schema. This is needed in order to only have the cache db configured in production. Otherwise you also need it configured in development, even if you're not using it, or the migration installation won't run. It's better anyway like this.