q-textasdata - Run SQL directly on CSV or TSV files
q-textasdata is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q-textasdata treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs, etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings.
q-textasdata is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q-textasdata treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs, etc. It supports automatic column name and type detection, and q provides full support for multiple character encodings.
To install q-textasdata, run the following command in macOS terminal (Applications->Utilities->Terminal)
sudo port install q-textasdata
To see what files were installed by q-textasdata, run:
port contents q-textasdata
To later upgrade q-textasdata, run:
sudo port selfupdate && sudo port upgrade q-textasdata
Reporting an issue on MacPorts Trac
The MacPorts Project uses a system called Trac to file tickets to report bugs and enhancement requests.
Though anyone may search Trac for tickets, you must have a GitHub account in order to login to Trac to create tickets.