Re: [sqlite] appropriate Uses For SQLite

2010-09-30 Thread Visnik
Thanks for the info. it has helped clarify some things for me. I think I will stick with MySQL with this application as it is going to be a networked app. If I do one that does not need to be on a network i will dive into SQLlite. thanks again. Pavel Ivanov-2 wrote: > > There's no contradict

Re: [sqlite] appropriate Uses For SQLite

2010-09-30 Thread Pavel Ivanov
There's no contradiction in those citations. First talks about website with some 100K hits/day. Website means application running on some dedicated server, clients send HTTP requests to your application and application processes it working with locally stored database. Second citation is talking ab

RE: [sqlite] Appropriate uses for SQLite

2007-02-15 Thread Eduardo Morras
I'm late too, but here you have my opinion At 02:03 05/02/2007, you wrote: FWIW I don't interpret any posts on this thread as an attempt to change SQLite, either. But there seems to be some who see value in more clearly defining *when* SQLite *does* work. I guess that there is a lot of enthusias

Re: [sqlite] Appropriate uses for SQLite

2007-02-15 Thread David M. X. Green
Thank you for your thorough replies to my supplementary remarks on this topic. It seems to me clear now that it is best not to take a careful disclaimer etc (on site networking support) as typically/generally indicating a limitation on usefulness of sqlite. Rather it is a matter of taking care &

Re: [sqlite] Appropriate uses for SQLite

2007-02-12 Thread Mike Owens
Hey, sorry I'm a little late on this one (as usual). On 2/3/07, David M X Green <[EMAIL PROTECTED]> wrote: I am new to this but are these issues those of trying to get it to do what sqlite it > is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " ..

Re: [sqlite] Appropriate uses for SQLite

2007-02-05 Thread Chris Hanson
On Feb 2, 2007, at 8:59 AM, Clark Christensen wrote: FWIW, I'm not convinced Samba has locking working correctly. Using a very recent Samba version, I managed to corrupt a SQLite database last fall by (I think) doing simultaneous writes from the Linux host box, and my WinXP client box (via

RE: [sqlite] Appropriate uses for SQLite

2007-02-04 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
PROTECTED] Sent: Monday, 5 February 2007 3:08 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite We used Sqlite in a web server successfully. It is embedded in a custom written web server which provides multithreaded access and application language support (an a

Re: [sqlite] Appropriate uses for SQLite

2007-02-04 Thread John Stanton
ite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " Again, most of these limitations are intention

RE: [sqlite] Appropriate uses for SQLite

2007-02-04 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
EMAIL PROTECTED] Sent: Sunday, 4 February 2007 1:17 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1

Re: [sqlite] Appropriate uses for SQLite

2007-02-03 Thread David M X Green
I am new to this but are these issues those of trying to get it to do what sqlite it is not designed for. I quote the book The Definitive Guide to SQLite - Chapter 1 --- Networking " Again, most of these limitations are intentional—they are a result of SQLite’s design. Supporting high writ

Re: [sqlite] Appropriate uses for SQLite

2007-02-02 Thread Alex Roston
Scott Hess wrote: On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. I doubt it is this easy. You need to line

Re: [sqlite] Appropriate uses for SQLite

2007-02-02 Thread Scott Hess
On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. I'm sure someone knows which versions of NFS have working file locking, at least under Linux. I doubt it is this easy. You need to line up a bunch of thing

Re: [sqlite] Appropriate uses for SQLite

2007-02-02 Thread Clark Christensen
Message From: Dennis Cote <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, February 2, 2007 7:49:55 AM Subject: Re: [sqlite] Appropriate uses for SQLite [EMAIL PROTECTED] wrote: > The problem is, not many network filesystems work correctly. Hi All, If my understanding of thi

Re: [sqlite] Appropriate uses for SQLite

2007-02-02 Thread Alex Roston
Dennis Cote wrote: [EMAIL PROTECTED] wrote: The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue

Re: [sqlite] Appropriate uses for SQLite

2007-02-02 Thread Dennis Cote
[EMAIL PROTECTED] wrote: The problem is, not many network filesystems work correctly. Hi All, If my understanding of this is correct, SQLite only requires that the network file system has; reliable data transport and working file locking. This has primarily been an issue on older implementat

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
1:34 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite "Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote: > > I am trying to decide whether I can use SQLite for a website that runs > on 4 load-balanced servers usin

Re: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread drh
"Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote: > > I am trying to decide whether I can use SQLite for a website that runs > on 4 load-balanced servers using networked file storage mounted by all > servers for common data access. This sounds like a job for a clien

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
tency question, Wayne. Anil. -Original Message- From: WB Stow [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 1:12 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite I think that he said that he is running one website on four different servers using loadbala

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
ace that effort. Thanks Eric. Anil. -Original Message- From: Eric Pankoke [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 1:08 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite By separate files, do you mean that each user has their own data store? If

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread WB Stow
hilip Butler [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 7:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of S

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Eric Pankoke
8:27 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses for SQLite That's what I'm talking about! It's good to get the perspective from your setup, Phil. I'm beginning to get the picture. I am starting to think that I should stick to an enhancement of my current s

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
OTECTED] Sent: Friday, 2 February 2007 12:24 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I'd be _extremely_ leery of doing this on a network store. In theory, it should work just fine, but bridging theory and practice may very well cost you many sleepl

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
ms almost impossible when data is in separate files with no compression, etc. Thanks for taking the time. Anil. -Original Message- From: Philip Butler [mailto:[EMAIL PROTECTED] Sent: Friday, 2 February 2007 12:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLi

Re: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Scott Hess
essage- > From: Philip Butler [mailto:[EMAIL PROTECTED] > Sent: Friday, 2 February 2007 11:39 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Appropriate uses for SQLite > > I am not an expert on SQLite - but if you are running separate > websites > from your

Re: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Philip Butler
9 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If

RE: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Anil Gulati -X \(agulati - Michael Page at Cisco\)
e.org Subject: Re: [sqlite] Appropriate uses for SQLite I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If they do need to share the

Re: [sqlite] Appropriate uses for SQLite

2007-02-01 Thread Philip Butler
I am not an expert on SQLite - but if you are running separate websites from your multiple servers, then why not use 4 instances of SQLite ?? That is unless the websites need to share the same database/tables. If they do need to share the same database/tables, then PostgreSQL or MySQL ma