I wasn't trying to suggest it be added to an official VFS shipped with SQLite. Just pondering if there might be a way for people who want or need such functionality to integrate it cleanly via the VFS mechanism.
On Thu, Dec 5, 2013 at 5:24 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Dec 2013, at 12:00am, Scott Robison <sc...@casaderobison.com> wrote: > > > Might there be a way to implement a custom VFS for Mac to deal with this? > > One problem is that to be able to call fsevents you have to link in a huge > amount of the standard Mac support some of which isn't accessible from some > of the low-level programs (not Apps) that SQLite is used in. In fact the > amount of overhead involved is more than the whole of SQLite. like trying > to get SQLite to support Unicode sorting. It would be very much a rarely > used tail wagging the dog. > > Also, the problem this solves really isn't one that concerns the vast > majority of Mac programmers. If you can't trust your users not to move > data files out of place you can't trust them not to overwrite the contents > of a database of journal file. And the vast majority of Mac users never > find the appropriate folder (easily locatable inside a hidden folder as > > /Users/<username>/Library/Application Support/<appname>/ > > ) anyway. It's not like these files are right there in the user's > documents folder where users are actually likely to notice them and mess > with them. > > My conclusion is that those programmers who want this can do it inside > their app, outside the code which handles the database itself. Which means > that the code will be useful for more than SQLite database files, and gives > programmers more flexibility when deciding when to start monitoring files, > and what to do when a database file or a journal file is moved. > > Simon. > _______________________________________________ > 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