4 ms·

I like using q for querying CSVs on the command line: https://github.com/harelba/q https://github.com/harelba/q

• AdrenalinMd 4y ago
  Same. And I believe q uses sqlite under hood, so you can use the same SQL syntax as the one supported by sqlite. Joining multiple csv files is also possible without too much setup. http://harelba.github.io/q/ http://harelba.github.io/q/
  • mattewong 4y ago
    It's nice that q has caching.... then again, it kind of needs it to solve its performance inefficiency. Running "select *" on a 1mm-row worldcitiespop_mil file, q takes 27 seconds compared to `zsv sql` which takes 1.7 seconds ( https://github.com/liquidaty/zsv https://github.com/liquidaty/zsv ) and also supports multiple file joins. I'm sure q is faster once cached, but taking a 16x performance hit up-front is not for me