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] <javascript:>>
> 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.
>
> 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.
