On 3/7/08, Jeff Brown <[EMAIL PROTECTED]> wrote: > 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).
With a Cocoa application, all you have to do is use Core Data SQL as its persistent data store. Everything is stored automagically in SQLite format. > > 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." There is no such thing as a SQLite server. SQLite is both the client and the server. Well, technically, your application is the client, and SQLite is embedded in it. Hence, when the user runs the application, there is a a SQLite dedicated just for that user. > > 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? The only analog I can think of is a web application where the data are stored in SQLite. This is a scenario that I use all the time. My web forms are the client, and the backend database is the server. I've never had a problem, but if I had more than a few users, I would likely upgrade to PostgreSql. Once again, keep in mind -- a typical use of SQLite is embedded inside an application, hence, each instantiation of the application has its own client (the application) and its own server (the SQLite embedded within it). > > 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 > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
