Hacker News Reader

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.

When 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.

Using 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 ;-)