FSQL

Dev tools

file search

SHOW HN2017

Legend

FSQL

Search through your file system with SQL-esque queries

github.com

#file search#sql#filesystem query#find alternative

341points
126comments
#55of 2,242 in 2017
Top 3%of 2017 by points

How HN took it

MixedNo clear lean

9 positive, 17 neutral or asking, 1 mixed, 8 critical, out of 35 comments about the project. Thread score +0.05.

Idea: 7 for, 4 againstDesign: 1 for, 4 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Cool idea, makes filtering file attributes easier than find

    From 2 comments
    • 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…
      ziikutv on HN
    • Really cool idea
      rs86 on HN
  • Would use it for finding recent or large files

    From 1 comment
    • 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…
      zitterbewegung on HN

Objections

  • SQL is too verbose for the terminal; find and grep are enough

    From 2 comments
    • 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.
      m0skit0 on HN
    • 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…
      devnonymous on HN
  • Syntax is clunky, e.g. needs quoting and select

    From 2 comments
    • 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.
      m00s3 on HN
    • Yeah, I like the idea of using sql but it is painful to write. It would be nice to omit the select and the quoting; my suggestion would be that ``` fsql "select * from ..." ```…
      emmelaich on HN

Requests

  • Shorter syntax without select or quotes

    From 1 comment
    • Yeah, I like the idea of using sql but it is painful to write. It would be nice to omit the select and the quoting; my suggestion would be that ``` fsql "select * from ..." ```…
      emmelaich on HN
  • Document a WHY section in the README

    From 1 comment
    • Really cool idea, but I'm really missing the WHY section in the Readme file. Thinking about a use case is quite hard. Anyone?
      drinchev on HN

Questions

  • How and where is the index stored, and does it work on very large filesystems

    From 1 comment
    • Don't see it offhand so asking: 1) How/where are you storing the index 2) Have you tried this on large (30+ TB filesystems)?
      CaseFlatline on HN

Alternatives named

  • Everything (Windows instant file search)

    From 1 comment
    • For those of us on Windows: Everything [1] does the job quite nicely with much less verbose syntax. [1] http://voidtools.com
      misterdata on HN
  • Agent Ransack

    From 1 comment
  • osquery

    From 1 comment
    • Reminds me of osquery [0]. [0] - https://github.com/facebook/osquery
      rekwah on HN
  • fzf and q

    From 1 comment
    • 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…
      super_mario on HN
  • WinFS

    From 1 comment
    • 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…
      crivabene on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/14343967)