On Wednesday, November 7, 2012 7:10:23 PM UTC+5:30, sai kiran mothe wrote: > > Fabian, > > You can Sqlite3 for development purpose,Its a lightweight database.for > production you need to switch to postgresql,mysql,mongo. > > Thanks, > Saikiran Mothe > > > On Wed, Nov 7, 2012 at 7:07 PM, saikiran mothe > <[email protected]<javascript:> > > wrote: > >> $ cd yourapp/db >> >> $ sqlite3 develoment.sqlite3 >> >> $ .help >> >> $ .databases >> >> $ .use databasename >> >> $ .tables >> >> >> >> >> On Wed, Nov 7, 2012 at 7:05 PM, saikiran mothe >> <[email protected]<javascript:> >> > wrote: >> >>> Hi Fabian, >>> >>> Go to yourapp/db >>> >>> then you will see development.sqlite3 and test.sqlite3 >>> >>> Run >>> -- sqlite3 development.sqlite3 >>> >>> -- .databases >>> >>> -- .help >>> >>> ---.tables >>> >>> check .help command you will know more commands on sqlite3 >>> >>> Thanks, >>> Saikiran Mothe >>> >>> >>> >>> >>> On Wed, Nov 7, 2012 at 7:00 PM, Fabian Becker >>> <[email protected]<javascript:> >>> > wrote: >>> >>>> >>>>> 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. >>>>> >>>>>> >>>>>> >>>> You only have a single database in SQLite3, there is no need to select >>>> one. >>>> >>>> Type ".help" inside the SQLite3 shell to learn more. >>>> >>> So over all which i understood is that in Sqlite we can use only one database at a time.
Is above statement is correct. Thanks Best Regards to All 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]<javascript:> >>>> . >>>> To unsubscribe from this group, send email to >>>> [email protected] <javascript:>. >>>> 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]. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/NY3By6niSc0J. For more options, visit https://groups.google.com/groups/opt_out.
