search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.19k stars 322 forks source link

CLI interface embedded in SQLyog. #2172

Open peterwy opened 6 years ago

peterwy commented 6 years ago

We had this request a few times - last time in ticket 540156089/55708/. A few other MySQL clients have.

Those users must find that the for certain tasks a CLI is more convenient than the SQLyog editor (even with RESULT/DATA tab display tab set to 'text'

Personally I can only see one reason to use the CLI rather than the SQLyog editor: using the \G delimiter in the CLI returns a result row "vertically". This option does not exist in SQLyog, but something similar could be added somehow.

Note that there may be a legal license problem with this request - even with the CLI as distributed by MariaDB (MariaDB Connector/C is LGPL, but probably the CLI is GPL). So this would be a showstopper.

peterwy commented 6 years ago

Actully FORM-view in SQLyog does return rows vertically. But there are 2 differences as compared to CLI \G -delimiter

1) Only one row is visible at the time. 2) It is HTML formattted and cannot be copied as plain text.

But exactly why the user(s) want a CLI interface in SQLyoig is not clear. There may be other reasons.