On 7 November 2012 11:53, Fahim Patel <[email protected]> wrote: > > > On Wednesday, November 7, 2012 5:20:29 PM UTC+5:30, Fahim Patel wrote: >> >> >> >> Hi all , >> >> I have create new application in rails with sqlite3 . >> Its totally confusing to me when i see my database.yml file. >> Reason of confusing is what type of extension is given to database ? >> >> I have knowledge that by executing following line will create database :- >> sqlite3 test.db >> See the extension of database is .db >> >> But when i see my database.yml , extension of database is .sqlite3 >> database.yml is copied below. >> What is extension of database in sqlite3 ? >> >> In my database.yml file >> 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 >> > > > One more question how to switch database in Sqlite3. > In mysql we fire > use database_name > In postgre we fire > \c database_name > But what to fire in sqlite3 ?
man sqlite3 should show you. Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
