bookmarks for tables

[expired user #7262]'s profile image [expired user #7262] posted 11 years ago in Feature discussion Permalink
would be nice to have a bookmark-system similar to textpad: mark with ctrl-f2, jump to next/previous bookmark with f2/shift f2

checking values in different tables would be much easier and faster

thanks
walter
ansgar's profile image ansgar posted 11 years ago Permalink
You are talking about the database tree, right? In the SQL editor this is already possible - use Ctrl+Shift+0/1/2... to set a bookmark and Ctrl+0/1/2 to jump to them.

But I guess you mean the tree. How would shortcuts be visible in the tree? I assume one would not want to keep various shortcuts in mind, but wants to see these when scrolling over them, like in a text editor.
[expired user #7262]'s profile image [expired user #7262] posted 11 years ago Permalink
Yes, I mean the database tree.

The implementation in textpad (you know it?) would be enough for my needs :)
You can set as many bookmarks as you like, and on pressing F2 it jumps to the next bookmarked table in the tree, shift F2 to the previous table.

If you have to control many tables while developing/testing, you don't have to scroll down and up the whole time, just pressing F2 several times, imho that's much faster.

[expired user #7262]'s profile image [expired user #7262] posted 11 years ago Permalink
I forgot: tables with a bookmark could be shown in a different color or have a colored symbol in the tree view
ansgar's profile image ansgar posted 11 years ago Permalink
See issue #3366.
jfalch's profile image jfalch posted 11 years ago Permalink
+1 to some solution, eg the one preferred in #3366. I, too, have to access e.g. typo3 and magento databases, and access to several individual tables becomes mighty unhandy with that large number of tables; scroll, scroll, scroll some more... always typing something into the filter box when you have to repeatedly switch between the same 5 tables gets rather boring too. a "favorite subset" system would help a lot here while developing.
(NB, a "bookmark" IMHO refers to a single thing; "favourites" sounds better to me.)
jfalch's profile image jfalch posted 11 years ago Permalink
very nice solution, helps greatly ! (eg. magento..)

Thanks a lot !
ansgar's profile image ansgar posted 11 years ago Permalink
Thanks.

I just wonder if favorites should be applicable to databases also, not just for tables/views/...
But I think tables are mostly existent in myriads, databases not so.
jfalch's profile image jfalch posted 11 years ago Permalink
well, I have rarely more than, say, 20. OTOH, I have read of people here who tell of using 200 or even 400 databases on a server... does your "usage statistics" pingback include the maximum number of databases encountered on a server ? if not, you could consider adding it, and perhaps make a decision on the numbers returned.
ansgar's profile image ansgar posted 11 years ago Permalink
Yes, good idea. Or just wait for users asking for database favorites? No clue.

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