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.

New feature: Favorites

ansgar's profile image ansgar posted 6 years ago in News Permalink
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's profile image kondybas posted 6 years ago Permalink
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's profile image jan posted 6 years ago Permalink
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
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 6 years ago Permalink
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's profile image maXus posted 6 years ago Permalink
Ist das noch ein "nightly feature" oder sehe ich's nur nicht?
ansgar's profile image ansgar posted 6 years ago Permalink
Das kam kurz nach dem 8.1 release - ja, ist ein "nightly feature".
justpusher's profile image justpusher posted 6 years ago Permalink
Very, very useful!
Thank you very much for this feature!
justpusher's profile image justpusher posted 6 years ago Permalink
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's profile image ansgar posted 6 years ago Permalink
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's profile image Thiru posted 6 years ago Permalink
Is this feature not available in ver 8 ?
pls. help me to find the same
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.
jfalch's profile image jfalch posted 6 years ago Permalink
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's profile image Thiru posted 6 years ago Permalink
Its not availableunhappy
BubikolRamios's profile image BubikolRamios posted 6 years ago Permalink
It is, look hard. I was looking for like 10 minutes to find where to add to favourites (-:
jfalch's profile image jfalch posted 6 years ago Permalink
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's profile image Thiru posted 6 years ago Permalink
Thanks for your reply.
here is my screen shot:
http://imageshack.com/a/img6/7720/tqe3.png
jfalch's profile image jfalch posted 6 years ago Permalink
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's profile image Thiru posted 6 years ago Permalink
Yes i downloaded and found "favorites" stars :-)
Thanks for your great support.
PeterGrr's profile image PeterGrr posted 4 years ago Permalink

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

RaVenC's profile image RaVenC posted 4 years ago Permalink

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's profile image PeterGrr posted 4 years ago Permalink

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.