{"repo":"noborus/trdsql","free":true,"listed":false,"github":"https://github.com/noborus/trdsql","clone":"git clone https://github.com/noborus/trdsql.git","description":"CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.","language":"Go","stars":2170,"topics":["sql","csv","ltsv","json","cli","go","tbln","postgresql","mysql","sqlite3"],"license":"MIT","category":"databases-storage","readme_excerpt":"trdsql trdsql is a CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN files. This tool is similar to others such as q and textql, with a key distinction: it allows the use of PostgreSQL or MySQL syntax. For usage as a library, please refer to the godoc and the provided examples. 1. INSTALL 1.1. go get 1.1.1. Requirements 1.2. Download binary 1.3. Homebrew 1.4. MacPorts 1.5. FreeBSD 1.6. Cgo free 2. Docker 2.1. Docker pull 2.2. image build 2.3. Docker Run 3. Usage 3.1. Global options 3.2. Input formats 3.2.1. Input options 3.3. Output formats 3.3.1. Output options 3.4. Handling of NULL 3.5. Multiple queries 4. Example 4.1. STDIN input 4.2. Multiple files 4.3. Compressed files 4.4. Output file 4.5. Output compression 4.6. Guess by output file name 4.7. Columns is not constant 4.8. TSV (Tab Separated Value)) 4.9. LTSV (Labeled Tab-separated Values)) 4.10. JSON 4.10.1. jq expression 4.11. JSONL(NDJSON)) 4.12. YAML 4.13. TBLN 4.14. WIDTH 4.15. TEXT 4.16. Raw output 4.17. ASCII Table & MarkDown output 4.18. Vertical format output 5. SQL 5.1. SQL function 5.2. JOIN 5.3. PostgreSQL 5.3.1. Function 5.3.2. Join table and CSV file is possible 5.4. MySQL 5.5. Analyze 5.6. Configuration 6. Library 7. See also 8. Learn More 9. License 1. INSTALL 1.1. go get 1.1.1. Requirements go 1.25 or higher. 1.2. Download binary Download binary from the releases page(Linux/Windows/macOS). 1.3. Homebrew 1.4. MacPorts 1.5. FreeBSD freshports 1.6. Cgo free Typically, go-sqlite3 is use","default_branch":null,"files":null,"tree":[],"storefront":"/r/noborus","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/noborus/trdsql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}