An extendable, DRY Rails database file

database.yml

#chances are you use the same port and adapter everywhere
default: &default
  adapter: mysql2
  reconnect: true
  port: 3306

#we use docker compose locally, so these settings stay the same
local: &local
  <<: *default
  username: root
  password:
  host: db

#we use AWS for hosting, but as long as these env vars are present, you can use any provider
remote: &remote
  <<: *default
  database: <%= ENV['DATABASE'] %>
  username: <%= ENV['DB_USER'] %>
  password: <%= ENV['DB_PASSWORD'] %>
  host: <%= ENV['DB_HOST'] %>
  pool: 25
  
#we use SSL connections to our RDS instance, so we setup a verification key, but if you have everything locked down,
#you probably won't need these next two lines
  sslca: '/var/rds-combined-ca-bundle.pem'
  sslverify: true

#finally, we define environment specific settings below
development:
  <<: *local
  database: ygrene_development

test:
  <<: *default
  database: ygrene_test

staging:
  <<: *remote

production:
  <<: *remote