#1109 (ok 3.5) Drop down for 'Jump to Recent table' list
Have a drop down that appears just under the top tabs Browser | Structure | SQl | ETC
This drop down shows a list of the 10 most recent tables you have viewed
If you have a load of tables, in multiple databases, jumping back and forth between them can be a little slow.
The preferences should allow you to set:
1) Show last x -> you should be able to choose how many table to list in the drop down from 1 to 20 maybe
2) Only show tables in current DB or show tables across all your DBs
3) Jump to 'Browse view ' or Jump to 'Structure view' when selecting a table.
My preferences would be
1) show last 10 tables
2) show tables across all databases
3) jump to structure view
Maybe even have a radio select to hit for browse view or structure view which you can select before selecting the table.
This would be really really helpful.
Keep up the great work
Trent
I think that
- just adding the last 10 tables (across all databases)
- in a "Recent" drop-down in the navi (left) frame, under the buttons
- jump to the page indicated in $cfg['LeftDefaultTabTable']
would be a good feature, without introducing a too complex dialog for preferences.
Yes that would be perfect.
Hi,
I've tried to implement this feature. Please see http://demo.phpmyadmin.net/gsoc-aris/ for the demo. Any comment and suggestion are welcome.
@Aris: I'm guessing that it's just a quirk on the server, but the feature does not work for me on the demo server. You can see the error in this screenshot here: http://www.placella.com/random/pma_screenshot.png
@Aris: Ok, scrap my previous reply, it actually works just fine even without the configuration storage. Anyway, I'd personally like the drop-down always being there and merely saying "There are no recent tables" is there is nothing to show me. Other than that I think it's great!
Rouslan
Hi,
Yes it also works well for me (chrome browser on ubuntu).
I think it look great, even long tables names using the hover works very well.
The only problem I see is that each time I go to a new table, (within the same database) the left column refreshes. Is this to repopulate that list????
If it is, users will get very annoyed with that I fear for 2 reasons:
1. I work on 10Gig + databases, and it's can take a while for left frame to load, so if it tries to reload each time I change a table that will take forever
2. The flashing frame on reload for each table change will just be visually distracting.
Hopefully this is just happening on the Demo site to reloaded multi/users changes,
If it is reloading 'just to change the recent tables drop down', I would suggest either:
1. Try adding 'recent list' in it's own frame, for quick reload
2. Add 'recent table' as a tab (After Tracking tab) that uses a JavaScript hover to display recent tables, therefore it is repopulated on each new page, and the left frame does not need to reload each table change.
Over all looks very good and work well
Trent
@Rouslan: I think it is a good idea to display "There are no recent tables". And thanks for pointing out in your screenshot. I think I must replace the text "Recently used tables: disabled" with "Persistent recently used tables" to make it clearer.
@Trent: Yes, currently, it reloads the navigation frame to repopulate the recent tables list. For the suggestions:
1. Try adding 'recent list' in it's own frame, for quick reload
Too much frame wouldn't be good.
2. Add 'recent table' as a tab (After Tracking tab) that uses a JavaScript ...
I think this is a good idea. But, instead of adding a tab, I'll try to use ajax to refresh the drop-down list. It would be more convenient if users can still interact with the recent list (in case the user wrongly select the recent table), while the main frame is still loading.
@arisferyanto: Agreed, your placement of the list is definitely the best spot.
And yes the AJAX trigger sounds like a winner!
Trent
Hi,
The demo has been updated with ajax. Please try it. :)
Any comment and suggestion are welcome.
Regards,
Aris
This requested feature was implemented in the repository and will be part of a future release; thanks for suggesting.
Great work!!
Great work!!
Great work!!