How do I set up multiple databases in a Rails application?

How do I set up multiple databases in a Rails application?

To set up multiple databases in a Rails application, you need to configure your database.yml file to include the different databases you want to use.

Can you give me an example of how to configure the database.yml?

Sure! Here's a basic example:

production:
  primary:
    adapter: postgresql
    database: myapp_primary
    username: user
    password: password
  secondary:
    adapter: postgresql
    database: myapp_secondary
    username: user
    password: password

How do I connect to these databases in my models?

You can specify the database in your model by using the establish_connection method. For example:

class User < ApplicationRecord
  establish_connection :primary
end