Feature Request: Group Tables

[NicholasA]

One of the things missing from MYSQL is catalogs, or as I understand them, the abiltiy to define groups of tables. When my database has hundreds of tables, this becomes a real nightmare. Use prefixes in table names only gets you so far.

It occured to me that a great feature for SQLYog would be to make up for that in the interface, by allowing the user to define groups of tables in the tool. “Groups” would appear at the same level as Tables,Views etc, and you would just drag and drop tables from Tables into that. Effectively these would be like virtual folders for your tables.

A related request would be to be able to have a search filter at the database or table level to be able to restrict the list of tables/items presented.

[Shalmali]

Hello NicholasA,

Thank you for your feedback!

Quote:

It occured to me that a great feature for SQLYog would be to make up for that in the interface, by allowing the user to define groups of tables in the tool. “Groups” would appear at the same level as Tables,Views etc, and you would just drag and drop tables from Tables into that. Effectively these would be like virtual folders for your tables.

— Added to our tracker — http://code.google.com/p/sqlyog/issues/detail?id=1464

We will schedule this according to our priority!

Quote:

A related request would be to be able to have a search filter at the database or table level to be able to restrict the list of tables/items presented.

Couple of such requests have been there already!

http://code.google.com/p/sqlyog/issues/detail?id=1119

http://code.google.com/p/sqlyog/issues/detail?id=965

We have already scheduled it! Should be shipped with the upcoming releases.

~Shalmali

[peterlaursen]

The problem is that if one client adds this functionality (client-side) it will cause problems if more clients are allowed to create tables.  For instance if you upgrade a 'standard application' (like this Forums software) the upgrade script may add new tables.  And another client (SQLyog will not know).

Such functionality should be a server-side functionality. Same applies to ROLES in User Management for instance. But MySQL server has no such functionalities.

[NicholasA]

'peterlaursen' wrote on '06:

The problem is that if one client adds this functionality (client-side) it will cause problems if more clients are allowed to create tables.  For instance if you upgrade a 'standard application' (like this Forums software) the upgrade script may add new tables.  And another client (SQLyog will not know).

Such functionality should be a server-side functionality. Same applies to ROLES in User Management for instance. But MySQL server has no such functionalities.

Peter,

I agree that ideally this should be done server-side in the database, and I understand catalogs are used for this purpose, which MYSQL doesn't support.

However I don't see why the client software couldn't provide such a client-side feature as a great selling point, helping to fill the gap.

I don't see the conflict? The grouping feature would be a personal feature for an admin's use. It would be invisible to anybody else. SQLYog would just provide the ability to allow him to organise his tables in client-side virtual folders. The ordinary tables tree would still be there, this is an optional capability. If somebody else adds another table, it appears in the table list as per usual.

[Author]

Posts