News for hackers. Stuff that matters.
Re:Show HN: FSQL – Search through your file system with SQL-... by samsk on Monday May 15, 2017 @03:10PM (#14344243)
We have implemented smth. like this with sqlite extension, pretty powerful, with all the goodies sqlite (and its extensions) provides...
Re:Show HN: FSQL – Search through your file system with SQL-... by kshvmdn on Monday May 15, 2017 @03:51PM (#14344570)
Sounds interesting, would love to take a look if it's available anywhere.
Re:Show HN: FSQL – Search through your file system with SQL-... by samsk on Tuesday May 16, 2017 @06:51AM (#14348645)
Unfortunately, it was commercial development, so it's not released. But implementation is relatively easy - it was a sqlite virtual table that (as much as I remember) looked in where condition for dir field, and listed that directory (= returned stat() data). Whole thing was quite interesting, because almost every component was somehow hooked into sqlite (either vith function or virtual table), so one could do pretty interesting things only with SQL.