Show HN: FSQL – Search through your file system with SQL-esque queries

Re:Show HN: FSQL – Search through your file system with SQL-... by taeric on Monday May 15, 2017 @03:47PM (#14344542)

Out of curiosity, I'm interested in how folks would do the "in this not that" folder query. At a gut shot, I'd assume that diff would be used. I'm about to dig through the find man page to see if it has something directly to help.

[ Parent | on HN ]

Re:Show HN: FSQL – Search through your file system with SQL-... by keithlfrost on Monday May 15, 2017 @04:44PM (#14344941)

One tool for this is the 'comm' utility: given two files containing sorted lines, it can output one or more of (1) lines only in file 1, (2) lines only in file 2, and (3) lines common to both files.

[ Parent | on HN ]

Re:Show HN: FSQL – Search through your file system with SQL-... by hoytech on Monday May 15, 2017 @04:09PM (#14344700)

Assuming no dups in file1, this outputs lines in file1 that aren't in file2:

    sort file1 file2 file2 | uniq -u

(double file2 is not a typo :)

[ Parent | on HN ]

Re:Show HN: FSQL – Search through your file system with SQL-... by isometry on Monday May 15, 2017 @04:45PM (#14344946)

Or (a little faster):

  comm -23 <(sort file1) <(sort file2)

[ Parent | on HN ]