Hacker News Reader

Comment by calpaterson | Hacker News Reader

This is odd, I did originally have that argument but I removed it because it didn't seem to matter - it works without ("On My Machine"(tm))

Erk - readding it and busting the cache. After I put my kids to bed I will figure out what is wrong

EDIT: the reason it works for me is because I've got this config in ~/.sqliterc:

    .separator ','

Apparently at some point in the past I realised that I mostly insert csv files into it and set that default.

View on HN

Generally curious - any particular reasons you chose sqlite and gnuplot for this task rather than, say, Python?

I do also use Python (pandas) partway down the page :) I'm just trying to show different tools to give people ideas about how much is possible with stuff that is already in /usr/bin/

If you were to ask my own tool preferences which I use for $DAYJOB: pandas for data cleaning and small data because I think that dataframes are genuinely a good API. I use SQL for larger datasets and I am not keen on matplotlib but still use it for graphs I have to show to other people.

Shouting out that clickhouse-local can do all of those in one step, including downloading, parsing, SQL query and charting.

Reply on news.ycombinator.com