2 ms·
SQL on CSV (using preinstalled Mac tools) previously linked on HN: https://til.simonwillison.net/sqlite/one-line-csv-operations https://til.simonwillison.net/sq
by smugma 4y ago
SQL on CSV (using preinstalled Mac tools) previously linked on HN:
https://til.simonwillison.net/sqlite/one-line-csv-operations https://til.simonwillison.net/sqlite/one-line-csv-operations
e.g.
sqlite3 :memory: -cmd '.mode csv' -cmd '.import royalties.csv Royalty' -cmd '.mode column' \
'SELECT SUM(Royalty),Currency FROM Royalty GROUP BY Currency'