3 ms·
The implementation part is actually irrelevant. The nice part is that it is CLI, like jq(1). I did something similar a long time ago with DBD::CSV but lost th
by thesnide 5y ago
The implementation part is actually irrelevant.
The nice part is that it is CLI, like jq(1).
I did something similar a long time ago with DBD::CSV but lost the code. So I'm glad the idea resurfaced.
- xn 5y agoWhen working with large csv files, you're better off importing the file into a sqlite database if you want to perform more than one query. Knowing the import is happening behind the scenes is useful when you hit performance problems with the tool.
- thesnide 5y agoUsing a local cache might indeed improve for following queries. But I managed to be able to "stream" results. When it didn't involve any GROUP BY, of course. I guess that would spawn a nice side project, to rewrite it in a language to learn it ;-)