TextQL

Execute SQL against structured text like CSV or TSV

View the Project on GitHub dinedal/textql

TextQL

Allows you to easily execute SQL against structured text like CSV or TSV.

Example session: textql_usage_session

Key differences between textql and sqlite importing

Is it any good?

Yes

Requirements

Install

You may need to export CC=clang on OS X.

go get -u github.com/dinedal/textql

Usage

  -console=false: After all commands are run, open sqlite3 console with this data
  -dlm=",": Delimiter between fields -dlm=tab for tab, -dlm=0x## to specify a character code in hex
  -header=false: Treat file as having the first row as a header row
  -outputHeader=false: Display column names in output
  -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

License

New MIT License - Copyright (c) 2014, Paul Bergeron (@dinedal)

See LICENSE for details