http://www.sqlite.org/whentouse.html
"...file locking logic of many network filesystems implementation
contains bugs (on both Unix and Windows). If file locking does
not work like it should, it might be possible for two or more
client programs to modify the same part of the same database at
the same time, resulting in database corruption. Because this
problem results from bugs in the underlying filesystem
implementation, there is nothing SQLite can do to prevent it."
So you better access SQLite DB always via Apache Web Server.
Pavel
On Fri, Mar 26, 2010 at 9:34 AM, Sam Carleton
<scarle...@miltonstreet.com> wrote:
> I am currently using SQLite in my client/server application:
>
> Server: Apache Web Server -- the sole process that access the SQLite
> databases
> Client A: Admin Client to configure the server, there is only 1 instance of
> this client.
> Client B: Kiosk Client, there is 1 or more of these, some have over 50
>
> Right now both Clients go through the web server to access the SQLite
> database, and all works fine. The Kiosk Clients are also getting images
> from the server, so they will ALWAYS access the SQLite DB via the Apache
> server. If I am not mistaken, the Admin Client, being on the same machine
> as the Apache Web Server, could also access the SQLite database with little
> or no effect, since they are very small rights.
>
> A third client needs to be added to the system, a Sales Client. For larger
> setups where there are more than 2 Sales Clients (10 kiosk clients), a
> traditional client/server database will be used. What I am wondering is, if
> for the smaller setups where only 2 sales clients are needed, can these
> sales clients access the SQLite DB via a network share without a major
> preformance hit or am I better off having the sales clients go through the
> Apache Web Server, too?
>
> Sam
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
