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

Reply via email to