New feature: Favorites

ansgar posted 3 years ago in News
The database tree on the left can be quite tall, on servers with myriads of tables, views, procedures and whatever. Now you can mark important items as so called favorites, by mouse click on the very left area of a table. Afterwards, you can limit the tree to show only favorites by a click on the new "Show only favorites" button at the top:

Thanks to bogdan.ghervan for the nice discussion on that idea in issue #3366.
kondybas posted 3 years ago
Wow! That's exactly what I need!

I have few projects with lot of procedures. Without "favorites" it was a mess to deal with them.

jan posted 3 years ago
Sehr geil.
Eine Schnellsuche wäre auch klasse gewesen, aber so geht es auch.

du solltest noch was einbauen, wenn keine favoriten existieren. Ist sehr verwirrend, wenn der baum dann leer ist.

Liebe Grüße
ansgar posted 3 years ago
Richtig. Das ist bereits jemandem passiert der mir das Phänomen umständlich erzählt hat aber nichts von dem Knopf wusste: http://www.heidisql.com/forum.php?t=13675#p13707
maXus posted 3 years ago
Ist das noch ein "nightly feature" oder sehe ich's nur nicht?
ansgar posted 3 years ago
Das kam kurz nach dem 8.1 release - ja, ist ein "nightly feature".
justpusher posted 3 years ago
Very, very useful!
Thank you very much for this feature!
justpusher posted 3 years ago
I have two suggestions for the favorites feature.

1. Add "Add/remove to favorites" item to table context menu.
Explaining: This will ease adding table to favorites (without it I have to turn off filtering, find the table in list, click star and then turn on filtering).
Alternatively, If "Show only favorites" enabled, and currently opened table is not in favorites, show an extra row with currenly selected table.

2. Make favorites tables list common for all databases and all connections.
Explaining: I have three identical databases: two local (for development and testing), and one remote database (for working site), and I have to star tables three times.
ansgar posted 3 years ago
1. Yes, I'm also thinking the selected table should be visible even if it's not a favorite. The context menu is already a bit crowded so I'm hesitating to add new items here.

2. That's a special use case. Applying favorites over all sessions would confuse other users, having randomly tables with the same name in different but totally unrelated sessions. That's not good. I can already hear the complaints :)
Thiru posted 3 years ago
Is this feature not available in ver 8 ?
pls. help me to find the same
jfalch posted 3 years ago
it´s still present: in the top left of window, use the yellow star besides database/table filter to toggle show all/ show only favorites.
while showing "all items", small stars to the left of table names in tree can be toggled to include(yellow) / exclude(grey) items to/from favorites.
Thiru posted 3 years ago
Its not availableunhappy
BubikolRamios posted 3 years ago
It is, look hard. I was looking for like 10 minutes to find where to add to favourites (-:
jfalch posted 3 years ago
please post a screenshot of the heidisql window. as this is unfortunately not available as a forum function here, i suggest that you use an image hoster e.g. imageshack, and post the url of your screenshot uploaded there.
Thiru posted 3 years ago
Thanks for your reply.
here is my screen shot:
jfalch posted 3 years ago
ok, you are using v8.0.0.4396, which is really quite old. How about downloading the current version v8.2.0.4690 ? I am using this version; it works well, and it definitively has the "favorites" stars (again).
Thiru posted 3 years ago
Yes i downloaded and found "favorites" stars :-)
Thanks for your great support.
PeterGrr posted 1 year ago


would it be possible to also filter the Db's ? a new suggestion is multiple favorites, so when working on a project you can select with favorites A the current db's belonging to the project.

thanks in advance, Peter

RaVenC posted 1 year ago

You can do this with your Login Setup. There you can add multiple databases, separated with an semicolon. When you login, you only will see this databases.

PeterGrr posted 1 year ago

Hi RaVenC, I understand , but 'toggling' between project a b en c would be much easier, if db's where also included in the favorites. and much faster to select.

thanks for the suggestion.

gr, Peter

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