This is the Linux app named q - Text as Data whose latest release can be downloaded as v2.0.19.tar.gz. It can be run online in the free hosting provider OnWorks for workstations.
Download and run online this app named q - Text as Data with OnWorks for free.
Follow these instructions in order to run this app:
- 1. Downloaded this application in your PC.
- 2. Enter in our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 3. Upload this application in such filemanager.
- 4. Start the OnWorks Linux online or Windows online emulator or MACOS online emulator from this website.
- 5. From the OnWorks Linux OS you have just started, goto our file manager https://www.onworks.net/myfiles.php?username=XXXXX with the username that you want.
- 6. Download the application, install it and run it.
q - Text as Data
q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings. q fully supports all types of encoding. Use -e data-encoding to set the input data encoding, -Q query-encoding to set the query encoding, and use -E output-encoding to set the output encoding. Sensible defaults are in place for all three parameters. Files with BOM: Files which contain a BOM (Byte Order Mark) are not properly supported inside python's csv module. q contains a workaround that allows reading UTF8 files which contain a BOM - Use -e utf-8-sig for this. The plan is to separate the BOM handling from the encoding itself, which would allow to support BOMs for all encodings.
- q allows performing SQL-like statements on tabular text data
- Its purpose is to bring SQL expressive power to the Linux command line and to provide easy access to text as actual data
- Query should be an SQL-like query which contains filenames instead of table names
- Use -H to signify that the input contains a header line
- Column types are auto detected by the tool, no casting is needed
- Query/Input/Output encodings are fully supported
This is an application that can also be fetched from https://sourceforge.net/projects/q-text-as-data.mirror/. It has been hosted in OnWorks in order to be run online in an easiest way from one of our free Operative Systems.