Projects / termsql

termsql

termsql converts text from stdin or any file into an SQLite database table and allows users to execute SQL queries on that table, all in just one line on the command line. It can be used to sort, display, convert, extract, and modify data on the command line using syntax familiar to those who know SQL.

Tags
Licenses
Operating Systems
Implementation

Recent releases

  •  01 May 2014 20:09

    Release Notes: You can now define custom column names. A convenience command line option allows a final "SELECT * FROM" statement to be appended to a user query. This was always the default when no user query was given (and still is). A short command line option has been added so that the output separator is whitespace instead of the default SQLite separator |.

    •  30 Apr 2014 00:10

      Release Notes: All the basic features are working. Termsql can use input from other programs (stdin) and from files and turn it into a SQL database on-the-fly, so you can run SQL on it. Sqlite is the backend. This is also useful for creating sqlite databases from raw data and for converting text to CSV or HTML. It's easy to use. The prototype code has been sanitized and rewritten. This release is stable and usable.

      Screenshot

      Project Spotlight

      OpenStack4j

      A Fluent OpenStack client API for Java.

      Screenshot

      Project Spotlight

      TurnKey TWiki Appliance

      A TWiki appliance that is easy to use and lightweight.