q is a command-line utility that allows users to execute SQL queries in tabular format text files (CSV, TSV, and other such formats). Users wanting to accomplish this task without a tool like q would typically need to load the CSV data into database software of some kind. The examples section on the q website provides an analysis of website click-count data and an analysis of file sizes to determine the owner using the most disk space. Users less familiar with SQL syntax may find the more detailed tutorial section useful. q requires Python 2.5 or higher and can run on any platform where Python runs. Python 3 is not yet supported. Installers are available for Windows and Linux. q is free software, licensed under the GNU General Public License v3, with source code available on GitHub.
Comments