【Rails】Rails中数据库配置模板（MySQL、PostgreSQL、SQLite）

SQLite3数据库配置

default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

development:
  <<: *default
  database: db/development.sqlite3

test:
  <<: *default
  database: db/test.sqlite3

production:
  <<: *default
  database: db/production.sqlite3

MySQL数据库配置

default: &defaults
  adapter: mysql2
  encoding: utf8
  username: root
  password: password
  pool: 10
  reconnect: true
development:
  <<: *defaults
  database: example_dev
test:
  <<: *defaults
  database: example_test
production:
  <<: *defaults
  database: example_prod

PostgreSQL数据库配置

default: &defaults
  adapter: postgresql
  encoding: unicode
  pool: 10
  username: postgres
  password: password

development:
  <<: *defaults
  database: example_dev
test:
  <<: *defaults
  database: example_test
production:
  <<: *defaults
  database: example_prod