News for hackers. Stuff that matters.
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.
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.