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.
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. > Actually, in my testing it works fine from the command line sqlite3 > client. The problem I am running into is that whenever I try using > sqlite through the Qt (http://www.trolltech.com/) sqlite driver, I get > an error indicating that the database is locked if the database file > is located on a network share (tried AFP and SMB). Now I know that > this sounds like a Qt problem, and in fact I believe that to be the > case. However, when I ask them about it, they stubbornly keep > insisting that it is a sqlite problem. As such, I wanted to at least > throw the question out to you guys to get your feedback. Could this > possibly be a SQLite problem? Or are the Trolltech/Qt people just not > willing to accept that the problem is with their driver? Thanks. > ----------------------------------------------- > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
