Skip to content

Instantly share code, notes, and snippets.

@erichurst
Created May 9, 2011 02:58
Show Gist options
  • Save erichurst/961978 to your computer and use it in GitHub Desktop.
Save erichurst/961978 to your computer and use it in GitHub Desktop.
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
Copy link

Thanks!

@cernalpanic
Copy link

yeah. thanks.

@abhishekdagarit
Copy link

Thankx...

@Athreyas
Copy link

Thanks .!!

@iangcarroll
Copy link

Come back to say I just _love_ this Gist.

@lifedever
Copy link

Thanks.!!!

@wilsoncampusano
Copy link

wowo

@SabretWoW
Copy link

+1

@retgoat
Copy link

retgoat commented Mar 26, 2014

+1

@dtak1114
Copy link

+1

@pauloroger
Copy link

+1

@jpcamara
Copy link

Why do you set reconnect to false?

@ayoub-bousetta
Copy link

Danke

@igoreliasm
Copy link

+1

@joaoteixeirajrr
Copy link

+2

@kishoore
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
Copy link

kkoci commented Aug 15, 2015

puts "Pure awesomeness!"

@yosemite-windows
Copy link

this is awesome ! Cheers

@danguilherme
Copy link

puts ":+1: :tada:"

@hightechweb
Copy link

+3

@pandu-49-zz
Copy link

How about RethinkDB with Rails 5.0.0.rc2

@manish-shrivastava
Copy link

+1

Copy link

ghost commented Jan 16, 2017

+1

@ldz2017reborn
Copy link

+1

@shivabhusal
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
Copy link

thanks very much

@Chrisn27
Copy link

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