This software is an advanced command-line client for MySQL that offers pipe chaining and extensibility, allowing developers to streamline their workflows and easily extend functionality. It is a powerful tool for managing MySQL databases efficiently.
Myterm is a software that enables users to run queries and filter the produced result set using pipe chaining. It also has the ability to produce graphical charts and integrates well with browsers. Currently written in PHP, it is suggested that it should be rewritten in Python to better support console, signal handling and multi-threading.
Although the parsing and option handling are limited at the moment, most basic functionalities are available for users to try out. For instance, users can connect using "myterm -uroot", produce HTML output in the browser using "myterm>SHOW DATABASES|html", and filter columns using "myterm>SHOW PROCESSLIST|cols 2-3".
Additionally, pie charting can be achieved by using "myterm>SELECT engine, count(*) AS count FROM information_schema.tables GROUP BY 1 ORDER BY 2 DESC|chart pie", while bar charting with result set reduction can be achieved with "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".
Users can also reverse-engineer result sets using "myterm>SHOW PROCESSLIST|insertify|tsv -N -E" or show loaded plugins with "myterm>plugins -l".
If interested, users can get involved by checking out the blueprints, joining the myterm-team and mailing list, getting the code and start coding. Overall, Myterm is a handy software with various features that make running queries and filtering result sets easier.
Although the parsing and option handling are limited at the moment, most basic functionalities are available for users to try out. For instance, users can connect using "myterm -uroot", produce HTML output in the browser using "myterm>SHOW DATABASES|html", and filter columns using "myterm>SHOW PROCESSLIST|cols 2-3".
Additionally, pie charting can be achieved by using "myterm>SELECT engine, count(*) AS count FROM information_schema.tables GROUP BY 1 ORDER BY 2 DESC|chart pie", while bar charting with result set reduction can be achieved with "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".
Users can also reverse-engineer result sets using "myterm>SHOW PROCESSLIST|insertify|tsv -N -E" or show loaded plugins with "myterm>plugins -l".
If interested, users can get involved by checking out the blueprints, joining the myterm-team and mailing list, getting the code and start coding. Overall, Myterm is a handy software with various features that make running queries and filtering result sets easier.
What's New
Version rev4: N/A