Dec 2023 Hacker News Suggestions

[jqnatividad]

qsv was mentioned on Hacker News Dec 23, 2023! 🎉

https://news.ycombinator.com/item?id=38733617

There were several good suggestions in there that should be incorporated into qsv.

[jqnatividad]

Here's my reply to the main qsv suggestions for reference:

Thanks for the detailed feedback @Snidane!
As maintainer of qsv, here's my reply:

• Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.
• Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (pivot: new command to pivot tables #799)
• I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (Add dedicated sum command with the group by (-by) and window by (-over) capability #1514). Do note that stats has basic sum as @ezequiel-garzon pointed out.
• With the enum command, qsv can achieve what you proposed with laminate. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv
• With the cat rowskey command, qsv can already concatenate files with mismatched headers.
• other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (Add fixed width format support #1515)
• as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.
  Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0

[jqnatividad]

In reference to @Snidane's comment re additional file formats:

Conversions to and from other standard formats would be appreciated (parquet, ion, fixed width lenghts, avro, etc.). Othe compression formats as well - especially zstd.

With 0.121.0, sqlp can now output results in Apache Avro format.

https://github.com/jqnatividad/qsv/releases/tag/0.121.0