Myterm Extensible MySQL command-line client with pipe chaining
Download

Myterm Ranking & Summary

Myterm Tags

MySQL MySQL client pipe chaining pipe chaining

Myterm Description

Extensible MySQL command-line client with pipe chaining Myterm 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 -urootProducing HTML output in the browser:myterm> SHOW DATABASES|htmlColumn filtering:myterm> SHOW PROCESSLIST| cols 2-3Pie charting:myterm> SELECT engine, count(*) AS count FROM information_schema.tables GROUP BY 1 ORDER BY 2 DESC|chart pieBar 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 hbarReverse-engineering of result sets:myterm> SHOW PROCESSLIST|insertify|tsv -N -EShow loaded plugins:myterm> plugins -lTo get involved, have a look at the blueprints. Join the myterm-team and mailing list. Get the code and start coding! Requirements: · MySQL · PHP

Myterm Related Software