On Mon, Oct 27, 2014 at 5:12 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 27 Oct 2014, at 9:49pm, Nico Williams <n...@cryptonector.com> wrote: >> 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.
Yes, but there's portability concerns. For example, PathCchCanonicalize() is not available before Windows 8 / Windows Server 2012. (Also, use PathCchCanonicalizeEx() instead...) (Windows also has an inode number on NTFS, as well as hardlinks, which is nice.) Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users