Not sure on the locking issue, but some of it might have to do with whether the database file is being provided via a NFS or a Windows Network Filesystem. Sometimes file-level locking is not real robust on networked file systems. If you are using some kind of ODBC/ADO provider then the details for that would be what counts.
Not sure what cocoa is, but it sounds fairly modern so you are probably able to go through an ODBC connection or provider of some sort, in which case youwould just configure the SQLITE connectivity layer you are using. As far as SQLITE itself goes, there is no database server to 'log into', all you are doing is providing a file name ( the file for which has to be visible to the client program ) to the connect function. If you want a more usual client/server situation, youd have to use ODBC or ADO, else you'd have to write it yourself. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Brown Sent: Friday, March 07, 2008 4:06 AM To: sqlite-users@sqlite.org Subject: [sqlite] Newbie question re using SQLite in basic client/serversituation Hi all I'm looking at switching the database that I use for my XCode/Cocoa application from MySQL to SQLite. (I'm getting tired of all the incompatibilities with new versions of MySQL). But I need to be able to use it as a server with at most 10 clients that occasionally use the system. I noticed in the documentation that it said the following "so, the 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." >From users' experience, is SQLite likely to be safe with so few clients on a local network. Also how do I login to the SQLite database from a client app? Cheers Jeff Get the name you always wanted with the new y7mail email address. www.yahoo7.com.au/y7mail _______________________________________________ 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
