[dajobe]

There is also the (impossible to google) https://github.com/harelba/q that lets you SQL over CSV and is unix pipeline friendly.

[lambda]

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.

[dmix]

xsv is awesome, just used it for a mini-project. Thanks for the heads up.

[harelba]

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

[kinleyd]

Miller looks very useful, and so does q. Thanks to the op and to you for the introductions.

[john_kerl]

indeed, I hadn't found q. thanks for the intro!

[meowface]

This is great. Wonder why they didn't go with "cq" or something, though.

[singingfish]

does it bring any advantages over https://metacpan.org/pod/DBD::CSV? (not being perl is not an advantage).

[pyre]

Well, DBD::CSV is just a driver for DBI, not a command that is "unix pipeline friendly"... So there's that.

[singingfish]

Perl is pipeline friendly though ...

[pyre]

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.