Allows you to easily execute SQL against structured text like CSV or TSV.
Example session:
- sqlite import will not accept stdin, breaking unix pipes. textql will happily do so.
- textql supports quote escaped delimiters, sqlite does not.
- sqlite3
- Go
You may need to export CC=clang on OS X.
Install sqlite3 via whatever means you prefer, and:
go get -u github.com/dinedal/textql -console=false: After all commands are run, open sqlite3 console with this data
-dlm=",": Delimiter between fields, (\t for tab)
-header=false: Treat file as having the first row as a header row
-save-to="": If set, sqlite3 db is left on disk at this path
-source="stdin": Source file to load, or defaults to stdin
-sql="": SQL Command(s) to run on the data
-table-name="tbl": Override the default table name (tbl)
-verbose=false: Enable verbose logging