How do I set up the database.yml file in Rails?

by

The database.yml is the file where you set up all the information to connect to the database. It differs depending on the kind of DB you use. You can find more information about this in the Rails Guide or any tutorial explaining how to setup a rails project.

The information in the database.yml file is scoped by environment, allowing you to get a different setting for testing, development or production. It is important that you keep those distinct if you don’t want the data you use for development deleted by mistake while running your test suite.

Regarding source control, you should not commit this file but instead create a template file for other developers (called database.yml.template). When deploying, the convention is to create this database.yml file in /shared/config directly on the server.

With SVN: svn propset svn:ignore config "database.yml"

With Git: Add config/database.yml to the .gitignore file or with git-extra git ignore config/database.yml

… and now, some examples:

SQLite

adapter: sqlite3
database: db/db_dev_db.sqlite3
pool: 5
timeout: 5000

MYSQL

adapter: mysql
database: my_db
hostname: 127.0.0.1
username: root
password: 
socket: /tmp/mysql.sock
pool: 5
timeout: 5000

MongoDB with MongoID (called mongoid.yml, but basically the same thing)

host: <%= ENV['MONGOID_HOST'] %>
port: <%= ENV['MONGOID_PORT'] %>
username: <%= ENV['MONGOID_USERNAME'] %>
password: <%= ENV['MONGOID_PASSWORD'] %>
database: <%= ENV['MONGOID_DATABASE'] %>
# slaves:
#   - host: slave1.local
#     port: 27018
#   - host: slave2.local
#     port: 27019

More Related Contents:

  1. Difference between rake db:migrate db:reset and db:schema:load
  2. Rails :include vs. :joins
  3. PG::ConnectionBad – could not connect to server: Connection refused
  4. Use YAML with variables
  5. What is the best way to seed a database in Rails?
  6. Using Rails Migration on different database than standard “production” or “development”
  7. delete_all vs destroy_all?
  8. database.yml &references not working
  9. Begin, Rescue and Ensure in Ruby?
  10. How to “pretty” format JSON output in Ruby on Rails
  11. Rails :dependent => :destroy VS :dependent => :delete_all
  12. difference between collection route and member route in ruby on rails?
  13. Disable ActiveRecord for Rails 4
  14. Using Rails serialize to save hash to database
  15. Rails 3: Get Random Record
  16. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  17. In Rails, how do you render JSON using a view?
  18. Rails sessions current practices
  19. Heroku upload-Precompiling assets failed
  20. What tools do you recommend to profile Rails apps? [closed]
  21. Rails: around_* callbacks
  22. How do I use RVM and create globally available gems?
  23. Undefined Method attr_accessible
  24. How to avoid NoMethodError for nil elements when accessing nested hashes? [duplicate]
  25. Add a default value to a column through a migration
  26. Rails: How to change the title of a page?
  27. Rails – Sort by join table data
  28. Installing Ruby on Rails – Mac OS Lion
  29. Ruby: Create range of dates
  30. Unable to install MySQL2 gem on Windows 7

Leave a Comment