Hacker News Reader

Comment by flusteredBias | Hacker News Reader

I am a data scientists. I have used a lot of tools/libraries to interact with data. SQLite is my favorite. It is hard to beat the syntax/grammar.

Also, when I use SQLite I do not output using column mode. I pipe to `tv` (tidy-viewer) to get a pretty output.

https://github.com/alexhallam/tv

transparency: I am the dev of this utility

View on HN

Here is an example of how I would pipe with headers to `tv`.

sqlite3 :memory: -csv -header -cmd '.import taxi.csv taxi' 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' | tv

What a nice tool. I love how Rust has reinvigorated command line utilities.

piping to jq (using json mode of course) also works well for this

Or `jless`, which shows you a tree and doesn't flood your terminal.

Nice, that's definitely better than `jq | less`

Just want to add that snowflake (imo) is better. You don’t have to suffer SQLite’s lack of data types and honestly snowflake is the best tool to work with messy data.

Just fyi you can set up a snowflake account with a minimum monthly fee of 25 bucks. It’ll be very hard to actually use 25 bucks if your data isn’t in 100s of GBs and you literally use as little compute as is needed so it’s perfect.

This is in no way a relevant good-faith reply. It is spam. A web-based cloud-based data analytics platform isn't in the same category as piping command-line programs together.

We can’t pay for anything that doesn’t have Jira integration, sorry!

Reply on news.ycombinator.com