Does anyone remember WinFS (1)?<p>Bill Gates described it as his biggest product regret (2).<p>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.<p>(1) <a href="https://en.m.wikipedia.org/wiki/WinFS" rel="nofollow">https://en.m.wikipedia.org/wiki/WinFS</a><p>(2) <a href="http://www.zdnet.com/article/bill-gates-biggest-microsoft-product-regret-winfs/" rel="nofollow">http://www.zdnet.com/article/bill-gates-biggest-microsoft-pr...</a><p>(3) <a href="https://en.m.wikipedia.org/wiki/Microsoft_Tablet_PC" rel="nofollow">https://en.m.wikipedia.org/wiki/Microsoft_Tablet_PC</a>
For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax.<p>[1] <a href="http://voidtools.com" rel="nofollow">http://voidtools.com</a>
Reminds me of osquery [0].<p>[0] - <a href="https://github.com/facebook/osquery" rel="nofollow">https://github.com/facebook/osquery</a>
On macOS, there is a query syntax [0] that's usable in Spotlight and the mdfind(1) command. Richer searchable attributes [1], but the results may have to be piped through other tools for formatting or other output.<p>[0]: <a href="https://developer.apple.com/library/content/documentation/Carbon/Conceptual/SpotlightQuery/Concepts/QueryFormat.html" rel="nofollow">https://developer.apple.com/library/content/documentation/Ca...</a><p>[1]: <a href="https://developer.apple.com/library/content/documentation/CoreServices/Reference/MetadataAttributesRef/Reference/CommonAttrs.html" rel="nofollow">https://developer.apple.com/library/content/documentation/Co...</a>
I 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.
I 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.
Seems if the query is always going to start with SELECT, that maybe it should be assumed?
I would never use this though, ack or find seem sufficient to me.
Reminds me of WSSQL [0] on Windows.<p>[0] <a href="https://msdn.microsoft.com/en-us/library/windows/desktop/bb231255(v=vs.85).aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/windows/desktop/bb2...</a>
find/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.
Nice 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/.<p>Any examples where this would be better than using find (with the occasional filter thrown in) ?
Did someone come up with a generalized rule about putting SQL on top of every possible system that contains queryable information? Here is first-pass:<p>>eventually every system that contains information that can be queried will have a sql interface
Nice! 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:<p><pre><code> 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
</code></pre>
Best of luck!
This is nice, but what I'm actually looking for is a lightweight clone of SharePoint Search[1].<p>Something that has a self-hosted Web Interface, and an engine that I can point at some file servers, and let it index the files to it's hearts content. All I then have to do is search the index 'google style' for my files.<p>Any suggestions?<p>--<p>[1] <a href="https://i-technet.sec.s-msft.com/dynimg/IC423463.jpg" rel="nofollow">https://i-technet.sec.s-msft.com/dynimg/IC423463.jpg</a>
This 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.
I never know when I have to use find vs grep. And linux grep is different from macOS grep so I google about it every day lol. I just never figure it out.
I think I'll be a heavy user of FSQL.