Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Rails 3 database.yml examples
# MySQL. Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
# gem install mysql2
#
# And be sure to use new-style password hashing:
# http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: test-mysql2_development
pool: 5
username: root
password:
socket: /tmp/mysql.sock
# 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.
test:
adapter: mysql2
encoding: utf8
reconnect: false
database: test-mysql2_test
pool: 5
username: root
password:
socket: /tmp/mysql.sock
production:
adapter: mysql2
encoding: utf8
reconnect: false
database: test-mysql2_production
pool: 5
username: root
password:
socket: /tmp/mysql.sock
# PostgreSQL. Versions 7.4 and 8.x are supported.
#
# Install the pg driver:
# gem install pg
# On Mac OS X with macports:
# gem install pg -- --with-pg-config=/opt/local/lib/postgresql84/bin/pg_config
# On Windows:
# gem install pg
# Choose the win32 build.
# Install PostgreSQL and put its /bin directory on your path.
development:
adapter: postgresql
encoding: unicode
database: test-postgres_development
pool: 5
username: test-postgres (or your username if PostgreSQL installed by Homebrew)
password:
# Connect on a TCP socket. Omitted by default since the client uses a
# domain socket that doesn't need configuration. Windows does not have
# domain sockets, so uncomment these lines.
#host: localhost
#port: 5432
# Schema search path. The server defaults to $user,public
#schema_search_path: myapp,sharedapp,public
# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error, fatal, and panic
# The server defaults to notice.
#min_messages: warning
# 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.
test:
adapter: postgresql
encoding: unicode
database: test-postgres_test
pool: 5
username: test-postgres (or your username if PostgreSQL installed by Homebrew)
password:
production:
adapter: postgresql
encoding: unicode
database: test-postgres_production
pool: 5
username: test-postgres
password:
# SQLite version 3.x
# gem install sqlite3
development:
adapter: sqlite3
database: db/development.sqlite3
pool: 5
timeout: 5000
# 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.
test:
adapter: sqlite3
database: db/test.sqlite3
pool: 5
timeout: 5000
production:
adapter: sqlite3
database: db/production.sqlite3
pool: 5
timeout: 5000
@iangcarroll

This comment has been minimized.

Copy link

commented Feb 18, 2013

Thanks!

@cernalpanic

This comment has been minimized.

Copy link

commented Feb 28, 2013

yeah. thanks.

@abhishekdagarit

This comment has been minimized.

Copy link

commented Apr 3, 2013

Thankx...

@Athreyas

This comment has been minimized.

Copy link

commented Apr 29, 2013

Thanks .!!

@iangcarroll

This comment has been minimized.

Copy link

commented May 8, 2013

Come back to say I just _love_ this Gist.

@gefangshuai

This comment has been minimized.

Copy link

commented Oct 31, 2013

Thanks.!!!

@wilsoncampusano

This comment has been minimized.

Copy link

commented Nov 7, 2013

wowo

@kyletcarlson

This comment has been minimized.

Copy link

commented Jan 10, 2014

+1

@retgoat

This comment has been minimized.

Copy link

commented Mar 26, 2014

+1

@dtak1114

This comment has been minimized.

Copy link

commented Apr 30, 2014

+1

@pauloroger

This comment has been minimized.

Copy link

commented Jul 16, 2014

+1

@jpcamara

This comment has been minimized.

Copy link

commented Aug 20, 2014

Why do you set reconnect to false?

@ayoub-bousetta

This comment has been minimized.

Copy link

commented Sep 10, 2014

Danke

@igoreliasm

This comment has been minimized.

Copy link

commented May 17, 2015

+1

@joaoteixeirajunior

This comment has been minimized.

Copy link

commented Jun 24, 2015

+2

@kishoore

This comment has been minimized.

Copy link

commented Aug 5, 2015

Hey i am confusing a lot with CASino , Actually i successfully installed CASino in my local system but right now my confusion is I have 3 rails application so i would like to give SSO for those applications with CASino but am not able to do that... Can anybody help me for this ???

@kkoci

This comment has been minimized.

Copy link

commented Aug 15, 2015

puts "Pure awesomeness!"

@yosemite-windows

This comment has been minimized.

Copy link

commented Nov 22, 2015

this is awesome ! Cheers

@danguilherme

This comment has been minimized.

Copy link

commented Mar 28, 2016

puts "👍 🎉"

@hightechweb

This comment has been minimized.

Copy link

commented Jun 1, 2016

+3

@pandu-49

This comment has been minimized.

Copy link

commented Jun 27, 2016

How about RethinkDB with Rails 5.0.0.rc2

@manish-shrivastava

This comment has been minimized.

Copy link

commented Dec 28, 2016

+1

@ghost

This comment has been minimized.

Copy link

commented Jan 16, 2017

+1

@ldz2017reborn

This comment has been minimized.

Copy link

commented May 14, 2017

+1

@shivabhusal

This comment has been minimized.

Copy link

commented Jul 25, 2017

I have created a Rails Template for generating database.yml files

see https://github.com/shivabhusal/useful_rails_templates

@Thanhdong0909

This comment has been minimized.

Copy link

commented Jun 10, 2019

thanks very much

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.