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