myterm Announcementstag:launchpad.net,2009-11-02:/myterm/+announcementshttps://launchpad.net/@@/product-logohttps://launchpad.net/@@/product2009-11-02T18:54:10.094918+00:00Project myterm launched2009-11-02T18:54:10.094918+00:002009-11-02T18:54:09.975649+00:00tag:launchpad.net,2009-11-02:/+announcement/4211Bjorn Melinderhttps://launchpad.net/~bjorn-melinder<p>myterm, extensible mysql command line client with pipe chaining.</p>
<p>The first version 0.2 has now been launched. Download and try it out.</p>
<p>More information:</p>
<p>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.</p>
<p>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.</p>
<p>Some examples:</p>
<p>Connecting:<br/>
myterm -uroot</p>
<p>Producing html output in the browser:<br/>
myterm> SHOW DATABASES|html</p>
<p>Column filtering:<br/>
myterm> SHOW PROCESSLIST| cols 2-3</p>
<p>Pie charting:<br/>
myterm> SELECT engine, count(*) AS count FROM information_<wbr/>schema.<wbr/>tables GROUP BY 1 ORDER BY 2 DESC|chart pie</p>
<p>Bar charts with result set reduction (other):<br/>
myterm> SELECT CONCAT(<wbr/>table_schema, '.', table_name) AS `Table`, data_length + index_length AS Bytes FROM information_<wbr/>schema.<wbr/>tables order by 2 desc|other 7|chart hbar</p>
<p>Reverse-engineering of result sets:<br/>
myterm> SHOW PROCESSLIST|<wbr/>insertify|<wbr/>tsv -N -E</p>
<p>Show loaded plugins<br/>
myterm> plugins -l</p>