Sqlite is an embedded database, not a server. If you want to use it for multiple clinets you really need to add a server which embeds Sqlite. When you do that it works well and will handle many remote clients.
If you have multiple users on one machine you can use the inbuilt Sqlite synchronization. [EMAIL PROTECTED] wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
