How do I set up the database yml file in Rails

Question

I m doing this tutorial  http   dmix ca 2008 09 how-to-scrape-websites-in-ruby-on-rails-using-scrubyt   and step 4 before I begin is to set up the database yml file  Not sure what that means  Could someone please explain

User · Accepted Answer

At first I would use http   ruby railstutorial org     And database yml is place where you put setup for database your application use - username  password  host - for each database  With new application you dont need to change anything - simply use default sqlite setup

User · Answer

The database yml is a file that is created with new rails applications in  config and defines the database configurations that your application will use in different environments  Read this for details   Example database yml   development    adapter  sqlite3   database  db development sqlite3   pool  5   timeout  5000  test    adapter  sqlite3   database  db test sqlite3   pool  5   timeout  5000  production    adapter  mysql   encoding  utf8   database  your db   username  root   password  your pass   socket   tmp mysql sock   host  your db ip      defaults to 127 0 0 1   port  3306

User · Answer

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   lt    ENV  MONGOID HOST     gt  port   lt    ENV  MONGOID PORT     gt  username   lt    ENV  MONGOID USERNAME     gt  password   lt    ENV  MONGOID PASSWORD     gt  database   lt    ENV  MONGOID DATABASE     gt    slaves      - host  slave1 local       port  27018     - host  slave2 local       port  27019

[ruby-on-rails] How do I set up the database.yml file in Rails?

Examples related to ruby-on-rails

Examples related to ruby

Examples related to database

Examples related to yaml