On: Miller: Like Awk, sed, cut, join, and sort for CSV...

[zX41ZdbW]

How does it look from command-line for streaming processing of CSV/TSV?

[jsyolo → zX41ZdbW]

you can pipe to it

[nousermane → jsyolo]

Yep:

  $ 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