News for hackers. Stuff that matters.
Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by garciasn on Thursday March 16, 2023 @09:20AM (#35181560)
1. Because it doesn't use SQL syntax.

2. Because it's closer to an amalgamation of the standard shell scripting tools (cut, sort, jq, etc) than it is to a SQL variant.

Re:Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, ... by kbouck on Friday March 17, 2023 @04:16AM (#35194519)
and miller also has a powerful (and intuitive imo.) dsl should you need to go beyond what the simple command line switches offer.

so, it remains simple and concise for the easy problems, yet can scale up to address the trickier ones as well.

i've used csvkit, sqlite, jq, etc. miller is my favorite tool for data-fu (with sqlite being a close 2nd)