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

iangcarroll commented Feb 18, 2013

Thanks!

@cernalpanic

This comment has been minimized.

Copy link

cernalpanic commented Feb 28, 2013

yeah. thanks.

@abhishekdagarit

This comment has been minimized.

Copy link

abhishekdagarit commented Apr 3, 2013

Thankx...

@Athreyas

This comment has been minimized.

Copy link

Athreyas commented Apr 29, 2013

Thanks .!!

@iangcarroll

This comment has been minimized.

Copy link

iangcarroll commented May 8, 2013

Come back to say I just _love_ this Gist.

@gefangshuai

This comment has been minimized.

Copy link

gefangshuai commented Oct 31, 2013

Thanks.!!!

@wilsoncampusano

This comment has been minimized.

Copy link

wilsoncampusano commented Nov 7, 2013

wowo

@kyletcarlson

This comment has been minimized.

Copy link

kyletcarlson commented Jan 10, 2014

+1

@retgoat

This comment has been minimized.

Copy link

retgoat commented Mar 26, 2014

+1

@dtak1114

This comment has been minimized.

Copy link

dtak1114 commented Apr 30, 2014

+1

@pauloroger

This comment has been minimized.

Copy link

pauloroger commented Jul 16, 2014

+1

@jpcamara

This comment has been minimized.

Copy link

jpcamara commented Aug 20, 2014

Why do you set reconnect to false?

@ayoub-bousetta

This comment has been minimized.

Copy link

ayoub-bousetta commented Sep 10, 2014

Danke

@igoreliasm

This comment has been minimized.

Copy link

igoreliasm commented May 17, 2015

+1

@joaoteixeirajunior

This comment has been minimized.

Copy link

joaoteixeirajunior commented Jun 24, 2015

+2

@kishoore

This comment has been minimized.

Copy link

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.

Copy link

kkoci commented Aug 15, 2015

puts "Pure awesomeness!"

@yosemite-windows

This comment has been minimized.

Copy link

yosemite-windows commented Nov 22, 2015

this is awesome ! Cheers

@danguilherme

This comment has been minimized.

Copy link

danguilherme commented Mar 28, 2016

puts "👍 🎉"

@hightechweb

This comment has been minimized.

Copy link

hightechweb commented Jun 1, 2016

+3

@pandu-49

This comment has been minimized.

Copy link

pandu-49 commented Jun 27, 2016

How about RethinkDB with Rails 5.0.0.rc2

@manish-shrivastava

This comment has been minimized.

Copy link

manish-shrivastava commented Dec 28, 2016

+1

@ghost

This comment has been minimized.

Copy link

ghost commented Jan 16, 2017

+1

@ldz2017reborn

This comment has been minimized.

Copy link

ldz2017reborn commented May 14, 2017

+1

@shivabhusal

This comment has been minimized.

Copy link

shivabhusal 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

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