Bronislav Klučka wrote:
I've created application using SQLite as database (Windows application). The
database is on remote server and application is accesing the database
through file system (e.g. user connect server as P:\ disc and uses the path
p:\databases\database.sdb). More users are accessing the database on the
same time. But database became corrupted nad PRAGMA integrity_check returns
some mistakes (pasted below).
I am told that there are bugs in file locking for network files in many
version of windows. If those reports are true and file locking under
windows does not always work correctly, then it might be possible for
two or more programs to attempt to write the database at the same time,
resulting in corruption.
You should consider moving to a client/server database engine if
you are storing a single database on a windows network. There are
lots of good client/server databases out there. If you really want
to use SQLite, then consider putting a thin server wrapper around
it and using it that way.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
