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 ?
> Thanks
>
> Best Regards
> Fahim Babar Patel
>
--
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/-/K1NOZJGhKnEJ.
For more options, visit https://groups.google.com/groups/opt_out.
