On Nov 17, 2009, at 12:49 AM, Simon Slavin wrote:
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.
hmm...now that's definitely a good question. When compiling Qt, there
is a configure flag for --system-sqlite. The implication here (I would
think) is that if you don't use that flag, Qt uses it's own version of
SQLite (perhaps it just contains the SQLite source?), which very well
may not have this flag defined. I'll have to see if I can get it to
compile with the --system-sqlite flag. Last time I tried, compilation
failed, but I didn't spend much time looking into it. Thanks for the
info!
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-----------------------------------------------
Israel Brewster
Computer Support Technician II
Frontier Flying Service Inc.
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7250 x293
-----------------------------------------------
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
