Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
cogs
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
61.
▲
by
cogs
11y ago
It lets us turn on and off different functional parts, to see the effect, so we can reverse engineer it. We don't have good general theories about how brains work, so a good place to start is from the bottom up.
62.
▲
by
cogs
11y ago
Wordiness isn't really a problem, because I'm a fast typer and most systems have tab completion and history recall. For me the benefit is that for lots of problems, whether databases or the filesystem, thinking in terms of sets fe
63.
▲
by
cogs
11y ago
Blatant plug: My pain at all these unnecessary hieroglyphics & man page work is why I built Crab, so I could use SQL to find things and an EXEC command to run commands on them. etia.co.uk Really it shouldn't have to be this hard.
64.
▲
by
cogs
11y ago
Crab doesn't pick up metadata during the scan, because this would slow the scan too much. There is a wrapper function 'metadata' which returns a specific metadata item from a file at a given path at query run time, but this b
65.
▲
by
cogs
11y ago
We don't have any linux builds at the moment, if there's demand we'll make some. We can scan mounted drives, and Crab has a command line switch to treat names as case sensitive or not. SHA-1 calls are probably not practical
66.
▲
by
cogs
11y ago
The example does check the contents, by using the SHA-1 of the files
67.
▲
by
cogs
11y ago
We looked at Log Parser before building Crab. The syntax was far from standard SQL, it didn't have joins etc. It didn't use string matching to identify subsets of files to query. And maybe the most important thing, it doesn'
68.
▲
by
cogs
11y ago
We're working on Windows, the query syntax and the functions are going to be the same.
69.
▲
by
cogs
11y ago
Crab is aimed specifically at the filesystem, rather than querying devices or processes. For example wildcard matching on paths, combined with the exec function to run OS commands on the files you get back.
70.
▲
by
cogs
11y ago
Crab has tab completion, so there's not too much extra typing, and the repacement of hieroglyphics by words does help readability. It's especially handy to see what is going on if you wrote it a month ago, and don't remember
71.
▲
Crab – SQL for your filesystem
(etia.co.uk)
127 points
by
cogs
11y ago
|
43 comments
72.
▲
Show HN: Hacking Sleep
(etia.co.uk)
2 points
by
cogs
12y ago
|
0 comments