3 ms·
While working with MySQL I can't stop wondering, why the mysql CLI interface is neglected for decades?.. It's so inconvenient compared to psql, that it makes m
by anticodon 6y ago
While working with MySQL I can't stop wondering, why the mysql CLI interface is neglected for decades?..
It's so inconvenient compared to psql, that it makes me cringe every time I have to work with MySQL. Garbled formatting of long statements, almost non-working history, editing long statements is cumbersome, etc.
Does MySQL authors use something else to communicate with the database?
- mmerlin 6y agohttps://www.mycli.net/ https://www.mycli.net/
- resheku 6y agocan't say about mysql authors but same as psql has its pgcli mysql cli has its [mycli](https://www.mycli.net https://www.mycli.net) one of the great things it can do is to use mysql_config_editor encrypted credentials [https://www.mycli.net/loginpath https://www.mycli.net/loginpath]
- lmm 6y agoI find the opposite. MySQL's CLI is very easy to use, because it uses long commands that are consistent and easy to remember, e.g. SHOW CREATE TABLE blah or GRANT ALL ON foo, rather than the cryptic letters of psql. Maybe if you use it a lot then psql makes more sense - but if you're directly connecting to the database that much, something's gone wrong, IMO.