Skip to content

Instantly share code, notes, and snippets.

@TheEricMiller

TheEricMiller/~database.example.yml

Last active December 16, 2015 06:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save TheEricMiller/5390682 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save TheEricMiller/5390682 to your computer and use it in GitHub Desktop.
Download ZIP
Rails database config file template.
Raw
~database.example.yml
#
# Remember:
# Ensure the appropriate gems are defined
# in your Gemfile for each environment
# gem 'sqlite3'
# gem 'pg'
# gem 'mysql2'
# $ bundle
#
# =======================================
# = DEV =
# =======================================
# ~~~~~~~~~~~~~~~~~~~~~~~~
# PG localhost ~~~~~~~~~~~
development:
adapter: postgresql
encoding: utf8
database: appdb_dev
username: root
password:
host: localhost
# ~~~~~~~~~~~~~~~~~~~~~~~~
# AWS RDS ~~~~~~~~~~~~~~~~
# development:
# adapter: mysql2
# encoding: utf8
# host: dbinstance.123endpoint789.us-east-1.rds.amazonaws.com
# database: appdb_dev
# pool: 5
# username: masterusername
# password: password
# socket: /tmp/mysql.sock
# ~~~~~~~~~~~~~~~~~~~~~~~~
# MySQL localhost ~~~~~~~~
# development:
# adapter: mysql2
# encoding: utf8
# database: appdb_dev
# pool: 5
# username: root
# password:
# socket: /tmp/mysql.sock
# ~~~~~~~~~~~~~~~~~~~~~~~~
# ORIGINAL ~~~~~~~~~~~~~~~
# development:
# adapter: sqlite3
# database: db/development.sqlite3
# pool: 5
# timeout: 5000
# =======================================
# = TEST =
# =======================================
# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
# ~~~~~~~~~~~~~~~~~~~~~~~~
# PG localhost ~~~~~~~~~~~
test:
adapter: postgresql
encoding: utf8
database: appdb_test
username: root
password:
host: localhost
# ~~~~~~~~~~~~~~~~~~~~~~~~
# MySQL localhost ~~~~~~~~
# test:
# adapter: mysql2
# encoding: utf8
# database: appdb_test
# pool: 5
# username: root
# password:
# socket: /tmp/mysql.sock
# ~~~~~~~~~~~~~~~~~~~~~~~~
# ORIGINAL ~~~~~~~~~~~~~~~
# test:
# adapter: sqlite3
# database: db/test.sqlite3
# pool: 5
# timeout: 5000
# =======================================
# = Production =
# =======================================
# HEROKU ~~~~~~~~~~~~~~~~~
# Note: This is not needed on Heroku & is (over)written on deployment.
# production:
# adapter: pg
# database: localhost
# timeout: 5000
# ~~~~~~~~~~~~~~~~~~~~~~~~
# ORIGINAL ~~~~~~~~~~~~~~~
# production:
# adapter: sqlite3
# database: db/production.sqlite3
# pool: 5
# timeout: 5000
# =======================================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment