On 7 November 2012 12:35, Fahim Patel <[email protected]> wrote: > > > On Wednesday, November 7, 2012 5:48:38 PM UTC+5:30, Colin Law wrote: >> >> 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. > > > 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 ? > I do lots of google but i get nothing.
It is probably easiest just to exit sqlite3 and start it again on the other db. Colin >> >> >> 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]. > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/e0aJtuY7Jq0J. > > For more options, visit https://groups.google.com/groups/opt_out. > > -- 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.
