News for hackers. Stuff that matters.
Re:TextQL: Execute SQL Against CSV or TSV by ravinizme on Saturday April 07, 2018 @03:07PM (#16782225)
Seem very similar to q

q is out there for years, with a very large community.

q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

http://harelba.github.io/q/

Re:TextQL: Execute SQL Against CSV or TSV by ams6110 on Saturday April 07, 2018 @07:22PM (#16783637)
Yes, I use q all the time for slicing and dicing delimited files. The only problem I have with it is that the name can make it a littler harder to find if you don't remember the repo.

Since q will read stdin and write CVS to stdout you can chain several queries on the command line, or use it in series with other with other commands such as cat, grep, sed, etc.

Highly recommended if you like SQL and deal with delimited files.