Re: [sqlite] web server use of SQLite

2003-11-24 Thread Vania Smrkovski
Thank you all so much for your data. It will really help me a lot. Looks like I'll be able to use SQLite in ways I had originally anticipated would be out of scope. Well done On Mon, 2003-11-24 at 09:06, D. Richard Hipp wrote: > D. Richard Hipp wrote: > > > > Over the past 30 days, the

Re: [sqlite] web server use of SQLite

2003-11-24 Thread D. Richard Hipp
D. Richard Hipp wrote: Over the past 30 days, the www.sqlite.org website has seen 6 separate 10-minute bursts of activity with 25 hits/day rates and many 1-minute bursts in the 45 hits/day range. Rates in excess of 20 hits/day have been sustained for a couple of hours on one event.

RE: [sqlite] web server use of SQLite

2003-11-24 Thread Allan Edwards
-Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 7:13 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] web server use of SQLite D. Richard Hipp wrote: > > The www.sqlite.org website is run off of a single SQLite database. > Back

Re: [sqlite] web server use of SQLite

2003-11-24 Thread D. Richard Hipp
Vania Smrkovski wrote: Have you or anyone encountered issues regarding my other questions, that of using SQLite as a web-served DB system? How do the recently discussed issues of concurrency and the locking of DB tables and files affect the use of a web site delivered SQLite DB system, and is

Re: [sqlite] web server use of SQLite

2003-11-24 Thread Vania Smrkovski
Darren, Thanks for the response. I knew about this issue as a security hole, which is why one of my options was to place the DB files out of the entire web doc tree. Happily, you took something that I had to learn the hard way from tech notes and experience and codified it in a way that