Live data from Hacker News

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

github.com

111–120 of 132 posts

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

#111

For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax. [1] http://voidtools.com

Everything is one of the first tools I install on every windows box. For me personally it is a must have. I don't think I know of any other tool which altered my workflow that heavily.

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

#112

Does 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-bi…

That was my first thought, too. I'd love a file system that was more like a relational database. Also see the Pick operating system.

I always wanted the file system to be built on a version control.

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

#113
post #90
post #80

Earlier quoted context omitted.

You could use the audit subsystem. https://www.linux.com/learn/customized-file-monitoring-audit...

Definitely crossed my mind, but I'm working on hosts where installing auditd isn't really easy. Broken yum and apt all over the place makes installing new packages almost impossible. Same goes for lsof, but its installed in "enough" places. Kinda nightmarish, but it gives me a chance to write some fun code ;). Also, thanks for the article! Super interesting. Think that'd be better than implementing something on top o…

Another non polling option: http://www.brendangregg.com/blog/2014-07-25/opensnoop-for-li...

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

#114

For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax. [1] http://voidtools.com

Everything is pretty awesome, one of the things I really miss on Linux. When I last looked for a Linux replacement for it, none had the real time updates or the instant search ui, and even those that claimed to index the file system for a quick search were very slow. I actually ended up writing my own hacky and rudimentary GUI over locate to achieve something that fits my needs (and of course doesn't support real tim…

Have you tried FZF (the fuzzy finder)?

https://github.com/junegunn/fzf

It integrates well with UNIX shells, editors (VIM integration is excellent), git log search etc. It's really versatile.

Of course, there is also q:

http://harelba.github.io/q/

for something that is more like the software described by OP.

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

#116

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.

There's been some attempts. Here's one:

https://github.com/BMDan/DFuse

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

#117

For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax. [1] http://voidtools.com

Everything is pretty awesome, one of the things I really miss on Linux. When I last looked for a Linux replacement for it, none had the real time updates or the instant search ui, and even those that claimed to index the file system for a quick search were very slow. I actually ended up writing my own hacky and rudimentary GUI over locate to achieve something that fits my needs (and of course doesn't support real tim…

I heard that Everything is dependent on the exact format of NTFS. The same algorithm isn't applicable to ext4 or HFS+.

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

#118
This is nice, but what I'm actually looking for is a lightweight clone of SharePoint Search[1].

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.

Any suggestions?

--

[1] https://i-technet.sec.s-msft.com/dynimg/IC423463.jpg

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

#119
post #77
post #31

Earlier quoted context omitted.

SQL is the standard language for querying relational data, so why not.

It's not a great standard. Practically keywords the whole English language...

Yes, it is a "Structured-English Query Language", formerly abbreviated as SEQUEL.

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

#120
post #98

Earlier quoted context omitted.

While WinFS was a good start, I think the idea of a semantic file system could be extended much further to the whole system (if it weren't for pesky POSIX) I think most people would expect /home/geokon/program1/src/ and /src/program1/home/geokon to have pretty much the same content A tag based file system that makes the two equivalent would eliminate all sorta of annoyances where you can't decide how to structure you…

Years ago, I had a similar idea, but never did anything with it. Look at DNs in LDAP (and X.400/X.500), they are based on attribute=value pairs. What about a filesystem in which filenames were collections of attribute=value pairs? e.g. /home/geokon/program1/src/foo.c could become: user=geokon/program=program1/category=src/lang=c/name=foo You could potentially decide that the order of the attributes is not significant…

Just write geokon program1 src c foo, and then just display a list of files that match. You could for example also make fake folder/menus to navigate tags. (Which would just be appending filters.)
Post reply on HN