One-liner for running queries against CSV files with SQLite

1

Tidy Viewer

#Linux #Spreadsheets #CSV Editors 2 social mentions

2

LNAV

One of my all-time favorite (and somehow still-obscure / relatively unknown) tools is called `lnav` ^1. It's a mini-ETL powertool with embedded SQLite, perfect for wrangling log files or other semi-structured data (a few millions of rows are no problem), it's intuitive and flexible... 1. https://lnav.org.

#Monitoring Tools #Log Management #Realtime Analytics 62 social mentions

3

OctoSQL

Since many people are sharing ones liners with various tools... OctoSQL[0]: octosql 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi.csv GROUP BY passenger_count' [0]:https://github.com/cube2222/octosql.

#Databases #Big Data #Relational Databases 23 social mentions