Some new features in myterm, extensible mysql command line client:TailEver found yourself running the same query over and over again to see if a table has got new content, just waiting for that magic row to appear? The tail command will watch for new lines in a table, just like you might tail a log file in Linux. Example:

1. myterm> tail -f bid
2. +--------+---------+-----------+--------+---------------------+
3. | bid_id | item_id | bidder_id | price | created |
4. +--------+---------+-----------+--------+---------------------+
5. | 67925 | 107751 | 81594 | 92500 | 2010-01-20 19:12:58 |
6. | 67926 | 34248 | 32530 | 10000 | 2010-01-20 19:12:59 |
7. | 67927 | 111211 | 108032 | 22900 | 2010-01-20 19:12:59 |
8. | 67928 | 116016 | 46720 | 90400 | 2010-01-20 19:13:00 |
9. | 67929 | 129101 | …

What if I type this:

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

and Firefox says:What's that?I just launched an open-source project on launchpad called myterm. Myterm is a crossover between the standard mysql command line client and the concept of pipes and filters in bash. You can use it to run queries and filter the produced result set in various ways using pipe chaining. This lends itself to quite a lot of different use cases, for instance graphical charts, md5 checksums and different presentation forms to name a few. It has browser integration using shell exec, which means it can render html result sets or charts in your browser. And since most stuff is written using plugins, it will work well to serve as a hub for hooking in more and more tools for …