New feature: Favorites

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.

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.

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
Jan

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

Ist das noch ein "nightly feature" oder sehe ich's nur nicht?

Das kam kurz nach dem 8.1 release - ja, ist ein "nightly feature".

Very, very useful!
Thank you very much for this feature!

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.

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 :)

Is this feature not available in ver 8 ?
pls. help me to find the same

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.

Its not available

It is, look hard. I was looking for like 10 minutes to find where to add to favourites (-:

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.

Thanks for your reply.
here is my screen shot:
http://imageshack.com/a/img6/7720/tqe3.png

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).

Yes i downloaded and found "favorites" stars :-)
Thanks for your great support.

Hi,

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

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.

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