Hi Dave, > I'm experimenting with using networked files as sqlite databases > (yes, I'm aware this is a questionable practice)
It seems quite valid for remote access to make ad hoc small changes to large hosted database files, or to provide shared access to small user databases files via desktop GUIs. > If the client is running on a mac, and the database file is not a > local disk, "database locked" error is returned immediately. Yes, I've noticed and reported this same problem. It appears that the SQLite bundled in Mac OS X has a special flag set to allow opening database files on networked volume, and that works great. Unfortunately, it is not enabled by default in the SQLite source code. I have enabled it myself in the past and compiled my own later version of SQLite for Mac OS X, though I haven't tried it with recent releases and seem to recall someone else saying that the old method no longer works. I would really like to see the SQLite source code and downloadable Mac OS X binary have this flag enabled, so that it behaves predictably the same as the version distributed with Mac OS X. This has far reaching indirect consequences such as the developer of the Zentus JDBC SQLite driver matching their code also with the default distribution, so currently the dozen or so SQLite applications for Mac OS X that use the JDBC driver also fail to open networked database files. You can see some of the programs this limitation affects in my comparison table as "Can open database file on AppleShare volume" here: http://www.tandb.com.au/sqlite/compare/ Richard and co, please enable this flag by default. Thanks, Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
