On 27 Oct 2014, at 9:49pm, Nico Williams <n...@cryptonector.com> wrote:

> On Mon, Oct 27, 2014 at 3:17 PM, Stephan Beal <sgb...@googlemail.com> wrote:
>> That's conceptually the same problem we're trying to solve here: keep the
>> public db names stable, regardless of where/how they're actually attached.
> 
> Yes, I think that's desirable.
> 
> If it's not too much to ask for then SQLite3 ought to: a) check for
> duplicates by canonicalized path (but keep in mind that this can be
> difficult to do portably, or without obnoxious length limitations on
> Windows), then b) check for duplicates by st_dev/st_ino where
> available.

Checking for cannonical path would seem to be important to improving this 
functionality.  There's a function to do this under OS X (resolve links, then 
do "stringByStandardizingPath") and Windows ("PathCchCanonicalize").  BSD has 
"realpath(3)".  It should be possible for most VFSes.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to