[EMAIL PROTECTED] wrote:
I would like to use SQLite from a network share. I would like to create a
server app that would do all of the writing to the database except for
certain tables, one table per client,the clients would write to their own
table only. The client drops it's
Darrell Lee wrote:
Here is my situation: the maximum number of clients that would be
reading the SQLite database is 6, of that 6 the maximum number of
clients that might be trying to write to the SQLite db is 3. In you
guys experience, on a scale of 1-10 , 10 being the most
The long and short of it is that SQLite uses the os File-Locking APIs
for concurrency. Network File systems vary wildly in the reliability
of their implementations of these APIs. If you already have a server
application why not simply force all database access through that?
On Thu, Sep 25, 2008
On Mon, Sep 15, 2008 at 11:49:48PM -0400, [EMAIL PROTECTED] scratched on the
wall:
I would like to use SQLite from a network share. I would like to create a
server app that would do all of the writing to the database except for
certain tables, one table per client,the clients would write to
Another question I have is do I understand correctly that an SQLite
database, on a network share, has no problems with many readers, the
problem starts with many writers. Is this correct?
Thanks,
TD
Yes, you'll have problems with many writers since each network file
system implementation
I would like to use SQLite from a network share. I would like to create a
server app that would do all of the writing to the database except for
certain tables, one table per client,the clients would write to their own
table only. The client drops it's data/instructions into it's own table,
the