Show HN: FSQL – Search through your file system with SQL-esque queries
1–10 of 132 posts
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#2I think SQL is too verbose for use on the terminal. find + grep does the trick with way less verbose syntax (but also probably less readable). With that said, it is quite cool.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#3For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#4We 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-esque queries
#5This is really neat. MacOS has a easy to use smart folder which I use to find recent files and large files. An interface like this is an advantage because it's easy to understand what it's doing and it's cross platform . Other people make the claim it may be verbose (but being verbose makes the operation clearer) and SQL is so familiar to programmers that are power users.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#6FROM dir1, dir2 doesn't mean the same as in SQL. In SQL that's a join of dir1 and dir2, but here it's a union.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#7Nice project, wish you the best ! Although tbh, I personally won't use this simply because I know enough of find(1) to not see the cognitive overhead of switching to sql to do filesystem /queries/.
Any examples where this would be better than using find (with the occasional filter thrown in) ?
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#8Reminds me of osquery [0].
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#9FROM dir1, dir2 doesn't mean the same as in SQL. In SQL that's a join of dir1 and dir2, but here it's a union.
Hence the esque. :)
Good point though, I'll make a note of that in the README.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#10find/grep/awk/ag get me a long way to be honest. However, I think this is a cool project because it makes filtering of file attributes (such as size) so much easier. No need for splitting strings and using regex. Cheers.