Skip to content
/ textql Public
forked from dinedal/textql

Execute SQL against structured text like CSV or TSV

License

Notifications You must be signed in to change notification settings

mitoma/textql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

  • sqlite import will not accept stdin, breaking unix pipes. textql will happily do so.
  • textql supports quote escaped delimiters, sqlite does not.

Is it any good?

Yes

Requirements

  • Go

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

See LICENSE for details

About

Execute SQL against structured text like CSV or TSV

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Go 100.0%