distal-attribute
distal-attribute
distal-attribute
distal-attribute

bookmarks for tables

walgrun posted 1 year ago in Feature discussion
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 posted 1 year ago
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.
walgrun posted 1 year ago
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.

walgrun posted 1 year ago
I forgot: tables with a bookmark could be shown in a different color or have a colored symbol in the tree view
ansgar posted 1 year ago
See issue #3366.

jfalch posted 1 year ago
+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 posted 1 year ago
very nice solution, helps greatly ! (eg. magento..)

Thanks a lot !
ansgar posted 1 year ago
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 posted 1 year ago
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 posted 1 year ago
Yes, good idea. Or just wait for users asking for database favorites? No clue.

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