Create a gist now

Instantly share code, notes, and snippets.

Embed
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.

Show comment
Hide comment

Thanks!

@cernalpanic

This comment has been minimized.

Show comment
Hide comment
@cernalpanic

cernalpanic Feb 28, 2013

yeah. thanks.

yeah. thanks.

@abhishekdagarit

This comment has been minimized.

Show comment
Hide comment

Thankx...

@Athreyas

This comment has been minimized.

Show comment
Hide comment
@Athreyas

Athreyas Apr 29, 2013

Thanks .!!

Thanks .!!

@iangcarroll

This comment has been minimized.

Show comment
Hide comment
@iangcarroll

iangcarroll May 8, 2013

Come back to say I just _love_ this Gist.

Come back to say I just _love_ this Gist.

@gefangshuai

This comment has been minimized.

Show comment
Hide comment

Thanks.!!!

@wilsoncampusano

This comment has been minimized.

Show comment
Hide comment

wowo

@kyletcarlson

This comment has been minimized.

Show comment
Hide comment

+1

@retgoat

This comment has been minimized.

Show comment
Hide comment

retgoat commented Mar 26, 2014

+1

@dtak1114

This comment has been minimized.

Show comment
Hide comment

+1

@pauloroger

This comment has been minimized.

Show comment
Hide comment

+1

@jpcamara

This comment has been minimized.

Show comment
Hide comment
@jpcamara

jpcamara Aug 20, 2014

Why do you set reconnect to false?

Why do you set reconnect to false?

@ayoub-bousetta

This comment has been minimized.

Show comment
Hide comment

Danke

@igoreliasm

This comment has been minimized.

Show comment
Hide comment

+1

@joaoteixeirajunior

This comment has been minimized.

Show comment
Hide comment
@kishoore

This comment has been minimized.

Show comment
Hide comment
@kishoore

kishoore 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 ???

kishoore 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.

Show comment
Hide comment
@kkoci

kkoci Aug 15, 2015

puts "Pure awesomeness!"

kkoci commented Aug 15, 2015

puts "Pure awesomeness!"

@yosemite-windows

This comment has been minimized.

Show comment
Hide comment
@yosemite-windows

yosemite-windows Nov 22, 2015

this is awesome ! Cheers

this is awesome ! Cheers

@danguilherme

This comment has been minimized.

Show comment
Hide comment
@danguilherme

danguilherme Mar 28, 2016

puts "👍 🎉"

puts "👍 🎉"

@hightechweb

This comment has been minimized.

Show comment
Hide comment

+3

@pandu510

This comment has been minimized.

Show comment
Hide comment
@pandu510

pandu510 Jun 27, 2016

How about RethinkDB with Rails 5.0.0.rc2

How about RethinkDB with Rails 5.0.0.rc2

@manish-shrivastava

This comment has been minimized.

Show comment
Hide comment
@ghost

This comment has been minimized.

Show comment
Hide comment

ghost commented Jan 16, 2017

+1

@ldz2017reborn

This comment has been minimized.

Show comment
Hide comment
@shivabhusal

This comment has been minimized.

Show comment
Hide comment
@shivabhusal

shivabhusal Jul 25, 2017

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

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

shivabhusal commented Jul 25, 2017

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

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment