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

Reply via email to