如何配置database.yml，同时适配Rails本地原生与Docker开发环境？

Nice question! Mixing native local development with Docker workflows is super common on Rails teams, and you don’t need to maintain separate config files to make both work smoothly. The key is leveraging Rails’ built-in ERB support in database.yml plus environment variables to dynamically adapt to each environment.

Core Approach #

We’ll set sensible defaults for native local development (so your teammates don’t need extra setup to run bin/rails db:setup), while leaving room to override those values via environment variables for Docker. This keeps the config clean and avoids duplication.

Full database.yml Example #

default: &default
  adapter: postgresql # Swap to mysql2 if you use MySQL
  encoding: unicode
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  # Use localhost for native environments; Docker will override this with the DB container name
  host: <%= ENV.fetch("DATABASE_HOST") { "localhost" } %>
  # Default to the current system user (matches most local PostgreSQL setups)
  username: <%= ENV.fetch("DATABASE_USER") { ENV['USER'] } %>
  # Empty password by default (common for local dev; override via env vars if needed)
  password: <%= ENV.fetch("DATABASE_PASSWORD") { "" } %>
  # Auto-generate DB name based on app name and Rails env
  database: <%= ENV.fetch("DATABASE_NAME") { "#{Rails.application.class.parent_name.downcase}_#{Rails.env}" } %>

development:
  <<: *default

test:
  <<: *default
  database: <%= ENV.fetch("DATABASE_NAME") { "#{Rails.application.class.parent_name.downcase}_test" } %>

production:
  <<: *default
  # Follow Rails' standard production practice of using DATABASE_URL
  url: <%= ENV.fetch("DATABASE_URL") %>

Docker Compose Compatibility #

For your Docker-using teammates, just add the necessary environment variables to your docker-compose.yml to point Rails to the database container:

version: '3.8'
services:
  web:
    build: .
    environment:
      - DATABASE_HOST=db # Matches the name of your DB service below
      - DATABASE_USER=postgres # Match the DB container's default user
      - DATABASE_PASSWORD=postgres # Match the DB container's default password
      - DATABASE_NAME=your_app_development # Match the DB container's initial DB name
    depends_on:
      - db
  db:
    image: postgres:15 # Use your preferred DB version
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=postgres
      - POSTGRES_DB=your_app_development
    volumes:
      - postgres_data:/var/lib/postgresql/data/

volumes:
  postgres_data:

Why This Works #

• Zero setup for native devs: Teammates using local databases can run bin/rails db:setup immediately—all defaults align with typical local PostgreSQL/MySQL installs.
• Seamless Docker integration: Docker users get the correct DB host (the container name) and credentials via environment variables, no config edits needed.
• Flexible for other environments: If you add CI/CD or staging later, just set the same environment variables to match those environments.

Bonus Tip for Local Customization #

If some teammates want to tweak their local DB settings without modifying the shared database.yml, recommend adding the dotenv-rails gem to your project. They can create a .env.development file in the root with their custom values:

DATABASE_HOST=localhost
DATABASE_USER=my_custom_local_user
DATABASE_PASSWORD=my_local_password

This overrides the defaults in database.yml for their local setup only, without affecting the team’s shared config.

内容的提问来源于stack exchange，提问作者norman.lol