5 ms·
or sqlite for CSV/TSV, haven't tried it for json.
by jsyolo 4y ago
or sqlite for CSV/TSV, haven't tried it for json.
- zX41ZdbW 4y agoHow does it look from command-line for streaming processing of CSV/TSV?
- jsyolo 4y agoyou can pipe to it
- nousermane 4y agoYep: $ cat foo.tsv name foo bar Alice 10 8888 Bob 20 9999 $ cat foo.tsv | sqlite3 -batch \ -cmd ".mode tabs" \ -cmd ".import /dev/stdin x" \ -cmd "select foo from x where bar > 9000;" 20
- deleted 4y ago[deleted]
- ydant 4y agoduckdb and being able to write: select a,b,c from '*.jsonl.gz' has been a huge improvement to my workflows.