Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Another level of grouping in the database Tree Explorer

biju_ps's profile image biju_ps posted 8 years ago in Feature discussion Permalink
Now HeidiSQL have ability to group database objects like Tables,SPs,Functions etc. IF we can provide another level then it will be very useful when the number of objects in the gorups are very large for Eg.

+Tables

sales
Purchase
+Temp Tables
tmp_sales
tmp_purchase

+Stored Procedures
+Transactional
proc_sales
proc_purchase

+Reporting
Proc_repo_sales
.
.
.


If Heidi can automatically map objects based on the given prefix then it will be an added advantage.

- Biju


ansgar's profile image ansgar posted 8 years ago Permalink
Don't you think the tree is already cluttered enough?
biju_ps's profile image biju_ps posted 8 years ago Permalink
hi anse ,
Thanks for your quick response.
yes, its already cluttered .
But please think about a database with 100's of tables and SPs.
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 8 years ago Permalink
Well, there are some other approaches to keep the overview:
* use the "Database" tab on the right, which can be filtered (Ctrl+Alt+F)
* organize tables into different databases instead of using prefixes.
* remove some tables :)
oz8hp's profile image oz8hp posted 8 years ago Permalink
I second the suggestion from biju_ps
The option to have tables, views, stored procedures and so on as levels in the tree is one of the main reasons for me to still have my old SQLYog installed on my computer.
It has this feature and it is workin like a charm.
ansgar's profile image ansgar posted 8 years ago Permalink

The option to have tables, views, stored procedures and so on as levels in the tree is one of the main reasons for me to still have my old SQLYog



Well, HeidiSQL supports these folders since a few months. No need to use SQLYog any longersmileYou just need to update HeidiSQL to the latest build, then rightclick the tree and activate "Group objects by type".
oz8hp's profile image oz8hp posted 8 years ago Permalink
That I had not seen smile

Then I will have to get rid of my old SQLYog.
rkrx's profile image rkrx posted 7 years ago Permalink
Hi,

I would also vote this up. But my solution is a little different.

I would include in an option to Group tables by ^[a-zA-Z0-9]+_+, and then (optional 2. layer) the grouping of SPs, Tables and so on.

+ system
|	+ tables
|	+ stored procedures
|	+ ...
+ user
|	+ tables
|	+ stored procedures
|	+ ...


I think, phpmyadmin does grouping already this way...

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.