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||Command Line SQL Query terminal|
|Operating Systems||All operating systems|
|Implementation||Python SQLite 3|
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 |.
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.