RE: [sqlite] Appropriate uses for SQLite

of Sqlite gives us an advantage by minimizing network and disk traffic and avoiding repeated process creation and destruction. In your application my reaction would be to run PostgreSQL or similar (maybe the new free version of DB/2) on one of your servers and connect from the others. Anil Gulati -

RE: [sqlite] Appropriate uses for SQLite

I have certainly got no desire to change the design goals of SQLite. The only reason I posted originally is because there was a strong recommendation in the documentation to use it for web sites which of course risk concurrent writes... The trouble introduced there in my case is that I am using mu

RE: [sqlite] Appropriate uses for SQLite

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

e the same database/tables, then PostgreSQL or MySQL may be the more appropriate choice. They are designed to be distributed (hence their increased overhead) while SQLite is designed to be lean-and-mean. Just my 2 cents worth... Phil On Feb 1, 2007, at 7:03 PM, Anil Gulati -X ((agulati - Michael Pag

RE: [sqlite] Appropriate uses for SQLite

ric Pankoke Founder Point Of Light Software http://www.polsoftware.com/ -Original Message----- From: Anil Gulati -X (agulati - Michael Page at Cisco) [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 8:27 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Appropriate uses fo

RE: [sqlite] Appropriate uses for SQLite

t; > 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

RE: [sqlite] Appropriate uses for SQLite

alized. With the db systems that I have designed, I have an automatic process that dumps the db to a text file every 4 hours or so. These are kept for a couple of days. I sleep easy at night knowing this... Phil On Feb 1, 2007, at 7:59 PM, Anil Gulati -X ((agulati - Michael Page at Cisco))

RE: [sqlite] Appropriate uses for SQLite

same database/tables, then PostgreSQL or MySQL may be the more appropriate choice. They are designed to be distributed (hence their increased overhead) while SQLite is designed to be lean-and-mean. Just my 2 cents worth... Phil On Feb 1, 2007, at 7:03 PM, Anil Gulati -X ((agulati - Michael Page at

[sqlite] Appropriate uses for SQLite

Hi SQLite users Thank you for your attention - I am just hoping for some clarification of usability of SQLite. Referring to: http://www.sqlite.org/whentouse.html - SQLite works well in websites - Other RDBMS may work better for Client/Server applications - SQLite will work over a network file syst