Reminds me of osquery [0]. [0] - https://github.com/facebook/osquery
Doesn't Windows have something like this built-in? WMI or something?
Show HN: FSQL – Search through your file system with SQL-esque queries
51–60 of 132 posts
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#52Nice! I'm actually working on a similar project to push lsof and files from /proc into some postgres tables. Lets me do cool things like query log files across a ~6000 server infrastructure similar to: SELECT distinct(l.name) FROM lsof l, lsofer_runs r WHERE l.lsofer_id = r.id AND fd_type = 'REG' AND l.fd ~ '[0-9][uw]' AND l.name like '%log' GROUP BY l.name, r.hostname ORDER BY name Best of luck!
so you're rewriting osquery? https://osquery.io/
I need this immediately.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#53Reminds me of WSSQL [0] on Windows.
[0] https://msdn.microsoft.com/en-us/library/windows/desktop/bb2...
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#54For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax. [1] http://voidtools.com
Everything is awesome
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#55I wanted to write the exact opposite: a Mysql/Postgres client as a FUSE filesystem driver. Namespaces -> folders, tables -> (editable) CSV files, stored procedures and settings accessible as (editable) plain text files.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#56Did someone come up with a generalized rule about putting SQL on top of every possible system that contains queryable information? Here is first-pass: >eventually every system that contains information that can be queried will have a sql interface
Yes, it is called "Spark driver" these days.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#57find/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.
Not to take anything away from this project, but you can filter on size, permission, etc easily and robustly using just `find` (try -perm, -size, -{c,m}time, etc flags): https://linux.die.net/man/1/find
If you are splitting strings (from output of `ls -l` presumably) for such tasks, then definitely take a look at find.
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#58Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#59I wanted to write the exact opposite: a Mysql/Postgres client as a FUSE filesystem driver. Namespaces -> folders, tables -> (editable) CSV files, stored procedures and settings accessible as (editable) plain text files.
Sounds dangerous!
Re: Show HN: FSQL – Search through your file system with SQL-esque queries
#60Does anyone remember WinFS (1)?
Bill Gates described it as his biggest product regret (2).
I remember I thought it was brilliant. Too bad it was probably a little bit too futuristic for its time, as for a few other things they launched when it just was not the right time... the clunky Tablet PCs (3) were for sure another example.
(1) https://en.m.wikipedia.org/wiki/WinFS
(2) http://www.zdnet.com/article/bill-gates-biggest-microsoft-pr...