On Sun, 12 Dec 2010 20:09:49 +0100, "Marco Turco" <m.tu...@softwarexp.co.uk> wrote:
>Hi all, > >I am having a problem running my Window Sqlite app on Mac OS X with Wine >emulator. > >It runs well in local but when I try to access to a network disk hosted on >Windows XP then a lock error appears. > >I checked on internet about this and as I know Sqlite at this moment doesn't >support the Samba/CIFS disk with reference to the locking system. > >I am really in trouble because I have more than 50 customers with mixed >network (Windows/Mac OS X) having this problem in the next future. > >Any ideas or turn-around to solve this problem ? Alternatives: 1) Use a database server, like PostgreSQL. http://www.sqlite.org/whentouse.html You can develop with SQLite and run production with PostgreSQL, because the SQL 'dialect' of postgres and sqlite are alike. 2) Redevelop your application so it accesses your sqlite databases via a webinterface. That way the webserver is the only one to access the sqlite files. Make sure they are on local disk or SAN, not on a SMB or NFS share. 3) Use a SQLite stub on the client, connecting to a central SQLite server instance. http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork Hope this helps. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
