On 17 Nov 2009, at 7:45am, Dan Kennedy wrote: > On Nov 17, 2009, at 2:32 AM, Israel Brewster wrote: > >> Simple (I hope) question here for my first posting to this list: >> Running SQLite 3.4.0 on Mac OS X 10.5.8, should I or should I not be >> able to place a SQLite database on a network share and have it work >> for a single user? I know there could be issues if multiple people >> tried accessing it at the same time, as well as potential performance >> issues regardless, but I'm trying to find out definitively if it >> should work at all - the idea is to have location portability, as >> opposed to truly sharing the database.
Mac OS X 10.5.8 comes with SQLite .h and .dylib files. The library is tested with the SQLite test suites and was built with the switches that make it pass all the tests. Note: /that/ library is tested, supplied with and works for /that/ version of Mac OS X. If the OP is using either of /usr/lib/libsqlite3.dylib /System/Library/Tcl/sqlite3/libtclsqlite3.dylib then all SQLite tests have been passed for all media types supported by Apple, including Flash drives, NFS, AFP and supported SMB configurations (I do not know about RAM disks). Of course, it's possible to set PRAGMAs and do library calls which will make it fail again, for example by defeating locking and/or caching under certain circumstances. One possibility is that the OP is not using the libraries supplied by Apple in which case this sort of thing > There is some tricky stuff in os_unix.c contributed by Apple that > I think is supposed to help with this. But with older SQLite versions > you have to turn it on by defining SQLITE_ENABLE_LOCKING_STYLE when > you build the library. Maybe your command line tool was built with > this option but the Qt driver was not. is definitely a good thing to be worrying about. But the supplied libraries should have no trouble with network shares mounted using the tools built into OS X. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
