Fahim Patel
2012-Nov-07 11:50 UTC
Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
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
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/EtBsbS4cArwJ.
For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-07 11:53 UTC
Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
Colin Law
2012-Nov-07 12:16 UTC
Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On 7 November 2012 11:50, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 ?You can use any extension you like. It is just a file.> > 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 > > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/EtBsbS4cArwJ. > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Colin Law
2012-Nov-07 12:17 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On 7 November 2012 11:53, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-07 12:35 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wednesday, November 7, 2012 5:48:38 PM UTC+5:30, Colin Law wrote:> > On 7 November 2012 11:53, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org <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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
Fabian Becker
2012-Nov-07 13:30 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
> > > 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. -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Colin Law
2012-Nov-07 13:35 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On 7 November 2012 12:35, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > > On Wednesday, November 7, 2012 5:48:38 PM UTC+5:30, Colin Law wrote: >> >> On 7 November 2012 11:53, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
saikiran mothe
2012-Nov-07 13:35 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
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 <fabian.becker87-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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. > > -- > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
saikiran mothe
2012-Nov-07 13:37 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
$ cd yourapp/db $ sqlite3 develoment.sqlite3 $ .help $ .databases $ .use databasename $ .tables On Wed, Nov 7, 2012 at 7:05 PM, saikiran mothe <saikiran.mothe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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 <fabian.becker87-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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. >> >> -- >> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Hassan Schroeder
2012-Nov-07 13:37 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wed, Nov 7, 2012 at 5:30 AM, Fabian Becker <fabian.becker87-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> You only have a single database in SQLite3, there is no need to select one.Well, not necessarily; see the ATTACH command. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org http://about.me/hassanschroeder twitter: @hassan -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
saikiran mothe
2012-Nov-07 13:39 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
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 <saikiran.mothe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> $ cd yourapp/db > > $ sqlite3 develoment.sqlite3 > > $ .help > > $ .databases > > $ .use databasename > > $ .tables > > > > > On Wed, Nov 7, 2012 at 7:05 PM, saikiran mothe <saikiran.mothe-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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 <fabian.becker87-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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. >>> >>> -- >>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> To unsubscribe from this group, send email to >>> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >>> 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-07 13:52 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
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 <saikira...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:> > > wrote: > >> $ cd yourapp/db >> >> $ sqlite3 develoment.sqlite3 >> >> $ .help >> >> $ .databases >> >> $ .use databasename >> >> $ .tables >> >> >> >> >> On Wed, Nov 7, 2012 at 7:05 PM, saikiran mothe <saikira...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<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 <fabian....-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<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 rubyonra...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:> >>>> . >>>> To unsubscribe from this group, send email to >>>> rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org 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.
saikiran mothe
2012-Nov-07 13:57 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
$sqlite3 develoment.sqlite3 use .sqlite3 On Wed, Nov 7, 2012 at 7:00 PM, Fabian Becker <fabian.becker87-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>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. > > -- > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Hassan Schroeder
2012-Nov-07 13:59 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wed, Nov 7, 2012 at 5:52 AM, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> So over all which i understood is that in Sqlite we can use only one > database at a time. > > Is above statement is correct.No. Again, see the ATTACH command: http://www.sqlite.org/lang_attach.html -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org http://about.me/hassanschroeder twitter: @hassan -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-07 14:15 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wednesday, November 7, 2012 7:31:58 PM UTC+5:30, Hassan Schroeder wrote:> > On Wed, Nov 7, 2012 at 5:52 AM, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:>> > wrote: > > > So over all which i understood is that in Sqlite we can use only one > > database at a time. > > > > Is above statement is correct. > > No. Again, see the ATTACH command: http://www.sqlite.org/lang_attach.html >Attach database is different concept which you are saying ? My question was In mysql we fire below command use database_name In postgre we fire below command \c database_name But what to fire in sqlite3 to switch database? @colin has given the answer is that you have exit open another database. Waiting for your reply Hope you will understood.> -- > Hassan Schroeder ------------------------ hassan.s...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:> > http://about.me/hassanschroeder > twitter: @hassan >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/XgBnS6HCKeQJ. For more options, visit https://groups.google.com/groups/opt_out.
Hassan Schroeder
2012-Nov-07 14:24 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wed, Nov 7, 2012 at 6:15 AM, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:>> No. Again, see the ATTACH command: http://www.sqlite.org/lang_attach.html> My question was> But what to fire in sqlite3 to switch database?If you *read* the page I referred to, you''ll see that you don''t "switch" databases, you refer to the attached one(s) explicitly by name. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org http://about.me/hassanschroeder twitter: @hassan -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Fahim Patel
2012-Nov-07 15:41 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wednesday, November 7, 2012 7:55:25 PM UTC+5:30, Hassan Schroeder wrote:> > On Wed, Nov 7, 2012 at 6:15 AM, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:>> > wrote: > > >> No. Again, see the ATTACH command: > http://www.sqlite.org/lang_attach.html > > > My question was > > > But what to fire in sqlite3 to switch database? > > If you *read* the page I referred to, you''ll see that you don''t "switch" > databases, you refer to the attached one(s) explicitly by name. >It works .. I attach development database to test. ################################### attach development as test; sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /home/titainum9/development 2 test /home/titainum9/development ####################################### but i am not understanding what that column "name" "seq" "file" means ?> -- > Hassan Schroeder ------------------------ hassan.s...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:> > http://about.me/hassanschroeder > twitter: @hassan >-- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/XKd8kD_sSdYJ. For more options, visit https://groups.google.com/groups/opt_out.
Hassan Schroeder
2012-Nov-07 16:28 UTC
Re: Re: Sqlite3 is confused me fully ? What to give database extension (.db or .sqlite3)?
On Wed, Nov 7, 2012 at 7:41 AM, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> I attach development database to test. > ################################### > attach development as test; > sqlite> .databases > seq name file > --- --------------- > ---------------------------------------------------------- > 0 main /home/titainum9/development > 2 test /home/titainum9/development > ####################################### > but i am not understanding what that column "name" "seq" "file" means ?I would think attaching the same db under a different name wouldn''t be a great idea :-) In any case, "name" and "file" seem pretty obvious; don''t really know any use for "seq" offhand. -- Hassan Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org http://about.me/hassanschroeder twitter: @hassan -- 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.