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 iangcarroll commented Feb 18, 2013

Thanks!

@cernalpanic

This comment has been minimized.

Copy link

@cernalpanic cernalpanic commented Feb 28, 2013

yeah. thanks.

@abhishekdagarit

This comment has been minimized.

Copy link

@abhishekdagarit abhishekdagarit commented Apr 3, 2013

Thankx...

@Athreyas

This comment has been minimized.

Copy link

@Athreyas Athreyas commented Apr 29, 2013

Thanks .!!

@iangcarroll

This comment has been minimized.

Copy link

@iangcarroll iangcarroll commented May 8, 2013

Come back to say I just _love_ this Gist.

@gefangshuai

This comment has been minimized.

Copy link

@gefangshuai gefangshuai commented Oct 31, 2013

Thanks.!!!

@wilsoncampusano

This comment has been minimized.

Copy link

@wilsoncampusano wilsoncampusano commented Nov 7, 2013

wowo

@kyletcarlson

This comment has been minimized.

Copy link

@kyletcarlson kyletcarlson commented Jan 10, 2014

+1

@retgoat

This comment has been minimized.

Copy link

@retgoat retgoat commented Mar 26, 2014

+1

@dtak1114

This comment has been minimized.

Copy link

@dtak1114 dtak1114 commented Apr 30, 2014

+1

@pauloroger

This comment has been minimized.

Copy link

@pauloroger pauloroger commented Jul 16, 2014

+1

@jpcamara

This comment has been minimized.

Copy link

@jpcamara jpcamara commented Aug 20, 2014

Why do you set reconnect to false?

@ayoub-bousetta

This comment has been minimized.

Copy link

@ayoub-bousetta ayoub-bousetta commented Sep 10, 2014

Danke

@igoreliasm

This comment has been minimized.

Copy link

@igoreliasm igoreliasm commented May 17, 2015

+1

@joaoteixeirajunior

This comment has been minimized.

Copy link

@joaoteixeirajunior joaoteixeirajunior commented Jun 24, 2015

+2

@kishoore

This comment has been minimized.

Copy link

@kishoore 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 kkoci commented Aug 15, 2015

puts "Pure awesomeness!"

@yosemite-windows

This comment has been minimized.

Copy link

@yosemite-windows yosemite-windows commented Nov 22, 2015

this is awesome ! Cheers

@danguilherme

This comment has been minimized.

Copy link

@danguilherme danguilherme commented Mar 28, 2016

puts "👍 🎉"

@hightechweb

This comment has been minimized.

Copy link

@hightechweb hightechweb commented Jun 1, 2016

+3

@pandu-49

This comment has been minimized.

Copy link

@pandu-49 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 manish-shrivastava commented Dec 28, 2016

+1

@ghost

This comment has been minimized.

Copy link

@ghost ghost commented Jan 16, 2017

+1

@ldz2017reborn

This comment has been minimized.

Copy link

@ldz2017reborn ldz2017reborn commented May 14, 2017

+1

@shivabhusal

This comment has been minimized.

Copy link

@shivabhusal 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 Thanhdong0909 commented Jun 10, 2019

thanks very much

@Chrisn27

This comment has been minimized.

Copy link

@Chrisn27 Chrisn27 commented Jul 28, 2020

Hey there, not sure if this is still active by I'm desperate. Updating a legacy application with zero documentation. It's a bunch of rails apps that have their own database.yml files. The top record in each reads:

defaults: &defaults
adapter: sqlserver
mode: odbc
pool: 5
timeout: 5000

How would one find out which host the adapter is looking at?

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.