Project myterm launched

Written for myterm by Bjorn Melinder on 2009-11-02

myterm, extensible mysql command line client with pipe chaining.

The first version 0.2 has now been launched. Download and try it out.

More information:

Can be used to run queries, and filter the produced result set in various ways using pipe chaining. Can produce graphical charts and has browser integration.

Currently written in PHP. But should be rewritten in Python to better support console, signal handling and multi-threading. For now, the parsing and option handling is limited, but most basic stuff works so you can get a feel for it.

Some examples:

Connecting:
myterm -uroot

Producing html output in the browser:
myterm> SHOW DATABASES|html

Column filtering:
myterm> SHOW PROCESSLIST| cols 2-3

Pie charting:
myterm> SELECT engine, count(*) AS count FROM information_schema.tables GROUP BY 1 ORDER BY 2 DESC|chart pie

Bar charts with result set reduction (other):
myterm> SELECT CONCAT(table_schema, '.', table_name) AS `Table`, data_length + index_length AS Bytes FROM information_schema.tables order by 2 desc|other 7|chart hbar

Reverse-engineering of result sets:
myterm> SHOW PROCESSLIST|insertify|tsv -N -E

Show loaded plugins
myterm> plugins -l