News for hackers. Stuff that matters.

A comment on We’re happy with SQLite and not urgently interested in a fancier DBMS (2016). Parent comment

Re:We’re happy with SQLite and not urgently interested in a ... by noir_lord on Friday May 04, 2018 @02:04PM (#16996738)
I'm a coder and I still find the ability to eyeball a file useful, also csv can be munged about with the shell easily (cut, grep, sed etc) which can be surprisingly useful.
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by shabbyrobe on Friday May 04, 2018 @02:11PM (#16996803)
Or Miller: https://github.com/johnkerl/miller
[ Parent | on HN ]
Re:We’re happy with SQLite and not urgently interested in a ... by ams6110 on Friday May 04, 2018 @02:12PM (#16996822)
csv can also be queried by tools like q[1] if sed, grep, etc. are not quite up to the task.

I find this very useful to quickly summarize, filter, reorder/rename columns etc. in csv files.

[1] https://harelba.github.io/q/

[ Parent | on HN ]