3 ms·
There is also the (impossible to google) https://github.com/harelba/q https://github.com/harelba/q that lets you SQL over CSV and is unix pipeline friendly.
by dajobe 11y ago
There is also the (impossible to google) https://github.com/harelba/q https://github.com/harelba/q that lets you SQL over CSV and is unix pipeline friendly.
- meowface 11y agoThis is great. Wonder why they didn't go with "cq" or something, though.
- singingfish 11y agodoes it bring any advantages over https://metacpan.org/pod/DBD::CSV https://metacpan.org/pod/DBD::CSV? (not being perl is not an advantage).
- pyre 11y agoWell, DBD::CSV is just a driver for DBI, not a command that is "unix pipeline friendly"... So there's that.
- singingfish 11y agoPerl is pipeline friendly though ...
- pyre 11y agoDBD::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.
- kinleyd 11y agoMiller looks very useful, and so does q. Thanks to the op and to you for the introductions.
- john_kerl 11y agoindeed, I hadn't found q. thanks for the intro!
- lambda 11y agoThere's also https://github.com/BurntSushi/xsv 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 11y agoxsv is awesome, just used it for a mini-project. Thanks for the heads up.
- harelba 11y agoHi. 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