Solid_queue, solid_cable, solid_cache migrations questions

production:
  primary: &primary_production
    <<: *default
    database: app_production
    username: app
    password: <%= ENV["APP_DATABASE_PASSWORD"] %>
   //IN CASE I HAVE A URL
  cache:
    <<: *primary_production
    database: app_production_cache
    migrations_paths: db/cache_migrate
  queue:
    <<: *primary_production
    database: app_production_queue
    migrations_paths: db/queue_migrate
  cable:
    <<: *primary_production
    database: app_production_cable
    migrations_paths: db/cable_migrate
  1. I dont really get how this work. If i work with railway.com with postgresql, this means i need to have 4 different databases?
  2. I have gotten two different errors: relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist – so i ended up creating a migration for each of the queue_schema, cache_schema. I dont understand how am i supposed to work with migrations using these. Are they supposed to migrate on their own if a database exists for them? If i have them specified like you see on the code, why do they still migrate but can’t find the database?

I dont really get how this work. If i work with railway.com with postgresql, this means i need to have 4 different databases?

I’m not familiar with railway.com, but yes you will have 4 different databases.

I have gotten two different errors: relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist – so i ended up creating a migration for each of the queue_schema, cache_schema. I dont understand how am i supposed to work with migrations using these. Are they supposed to migrate on their own if a database exists for them? If i have them specified like you see on the code, why do they still migrate but can’t find the database?

Did you follow the installation guide?

Such as:

I am using rails 8 so all of them come already installed. The issues i am facing is with the migrations of each. This is why i keep getting: relation “solid_queue_jobs” does not exist, and relation “solid_cache_jobs” does not exist. My queue_schema, and cache schema are there in my db folder, but no migrations are generated.

What Rails environment are you currently using?

(From what I can see of the file you submitted in your original post, it looks like you’re in production, but it’s always good to ask the question in case.)

Because for instance according to the documentation of solid_queue, if you’re in production, for example, you need to run the command: rails db:prepare, to ensure the db is created and the schema is loaded.

Then run db:prepare in production to ensure the database is created and the schema is loaded.