Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by dajobe on Saturday August 15, 2015 @10:09PM
(#10067691)
There is also the (impossible to google) https://github.com/harelba/q that lets you SQL over CSV and is unix pipeline friendly.
[ Parent
| on HN ]
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by lambda on Sunday August 16, 2015 @10:24AM
(#10068958)
There's also https://github.com/BurntSushi/xsv which is fairly similar in how it works to Miller, though it can also index a CSV file and then future operation will be sped up by utilizing the index.
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by dmix on Wednesday August 19, 2015 @12:52PM
(#10086794)
xsv is awesome, just used it for a mini-project. Thanks for the heads up.
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by harelba on Monday August 17, 2015 @04:41AM
(#10071878)
Hi. q's developer here. Thanks for the mention and kind words everyone.
I've considered the searchability issue when deciding on a name for it, but eventually favored the day-to-day minimum-typing short name over better searchability.
Anyway, you can search for "harelba q" in order to find it if needed.
Harel @harelba
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by kinleyd on Sunday August 16, 2015 @06:56AM
(#10068575)
Miller looks very useful, and so does q. Thanks to the op and to you for the introductions.
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by john_kerl on Sunday August 16, 2015 @09:10AM
(#10068805)
indeed, I hadn't found q. thanks for the intro!
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by meowface on Sunday August 16, 2015 @05:29AM
(#10068438)
This is great. Wonder why they didn't go with "cq" or something, though.
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by singingfish on Sunday August 16, 2015 @06:15AM
(#10068509)
does it bring any advantages over https://metacpan.org/pod/DBD::CSV? (not being perl is not an advantage).
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by pyre on Sunday August 16, 2015 @07:41AM
(#10068638)
Well, DBD::CSV is just a driver for DBI, not a command that is "unix pipeline friendly"... So there's that.
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by singingfish on Sunday August 16, 2015 @05:21PM
(#10070313)
Perl is pipeline friendly though ...
Re:Miller is like sed, awk, cut, join, and sort for name-ind...
by pyre on Monday August 17, 2015 @07:56AM
(#10072431)
DBD::CSV is a library, which you could use to build a command, but doesn't seem to come with one out of the box. q is just a command, but not a library.
One could use DBI + DBD::CSV + Perl to build something similar to q, but that's a batteries not included solution.