Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Fred Williams
. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Friday, September 25, 2009 1:12 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite Suitability for Shopping Cart On Sep 25, 2009

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Marcus Grimm
oes have sharing > capabilities > so it would be helpful to profile these for novices. > -- > View this message in context: > http://www.nabble.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25615724.html > Sent from the SQLite mailing list archive at Nabble.com. > > __

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread D. Richard Hipp
hentouse.html > bearing in mind that new people would naturally have the mindset that > databases are for shared use normally. SQLite does have sharing > capabilities > so it would be helpful to profile these for novices. > -- > View this message in context: > http://www.nabbl

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread CityDev
ally. SQLite does have sharing capabilities so it would be helpful to profile these for novices. -- View this message in context: http://www.nabble.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25615724.html Sent from the SQLite mailing list arch

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Fred Williams
m: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of CityDev Sent: Friday, September 25, 2009 12:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite Suitability for Shopping Cart This is what is says on the SQLite site: "We are aware of no other emb

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Kees Nuyt
On Thu, 24 Sep 2009 22:58:28 -0700 (PDT), CityDev wrote: > >This is what is says on the SQLite site: > >"We are aware of no other embedded SQL database engine that supports as much >concurrency as SQLite. SQLite allows multiple processes to have the database >file open at

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Simon Slavin
On 25 Sep 2009, at 6:58am, CityDev wrote: > What that seems to be saying is you can have concurrency but you > will suffer > the effects of whole-database locking for update transactions. It > seems a > glaring shortcoming, so either SQLite is not normally used by multiple > processes or

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 CityDev wrote: > What that seems to be saying is you can have concurrency but you will suffer > the effects of whole-database locking for update transactions. It seems a > glaring shortcoming, so either SQLite is not normally used by multiple >

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-24 Thread Dan Kennedy
On Sep 24, 2009, at 7:04 PM, CityDev wrote: > > Thanks for that Sebastian. > > It does however surprise me. I believe Access Jet handles simultaneous > activities. Indeed I've got a feeling it does row-locking rather than > page-locking. It's odd that SQLite has such a limitation. Anyway, >

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-24 Thread CityDev
in context: http://www.nabble.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25562183.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] SQLite Suitability for Shopping Cart

2009-09-22 Thread Sebastian Bermudez
> De: CityDev <nab...@recitel.net> > Asunto: [sqlite] SQLite Suitability for Shopping Cart > Para: sqlite-users@sqlite.org > Fecha: martes, 22 de septiembre de 2009, 3:37 am > > I am building a shopping cart application that calls a web > service which > provides

[sqlite] SQLite Suitability for Shopping Cart

2009-09-22 Thread CityDev
rom this description, do you think SQLite is a valid choice as the database in this scenario? -- View this message in context: http://www.nabble.com/SQLite-Suitability-for-Shopping-Cart-tp25530589p25530589.html Sent from the SQLite mailing list archive at Nabble.