#1486 (ok 4.2) Possibility of disabling database expansion

[cybernet2u]

i want to propose for this project to be able to disable in config.php expanding the database menu view in mainmenu.

example case: i have 15 databases on a mysql server ( each db has 100 tables ), if a browse 5 of them i will have to scrool a lot, and because i'm not in the mood to press "-" to collapse the ones i dont use anymore, i have to sign out and sign back in.

real case: i have 54 databases and 2593 tables

for me it's annoying to do all this. anyone feels the same :) ?

:::sql
SELECT IFNULL(table_schema,'Total') "Database",TableCount
FROM (SELECT COUNT(1) TableCount,table_schema
FROM information_schema.tables
WHERE table_schema NOT IN ('information_schema','mysql')
GROUP BY table_schema WITH ROLLUP) A;

[Marc Delisle]

Maybe your feature request should be "Possibility of disabling database expansion" because disabling won't be the default behavior.

If I understand you correctly, with this feature, a click on the database name in the navi panel would only show the db structure on the main panel?

[cybernet2u]

yes, that is correct.
just like in 3.3.10.5

3.3.10.5 was the fastest version. i used it long time after End of Life. but then i got scared and upgraded to 4. imagine the shock when i saw how much javascript is beeing used now.

and really what is the purpose of this future of showing tables on both panels ?
i find it very unusefull and increases the load ( not by much ).

[Marc Delisle]

There are many purposes (and you see not only tables but views, procedures, functions, etc); if you want to discuss it, the phpmyadmin-devel list is the best place.

[cybernet2u]

and what is the purpose of the main panel than ?

[Marc Delisle]

For example, the main panel might show the results of a table Browse, while the navi panel still shows you the list of tables. It has always been the same principle, but since 4.0 the navi panel shows a tree.

[cybernet2u]

ok. but think that this product is used by thousands if not 1 million people.
not everyone uses procedures and views.

some may find this feature usefull, while some not

[Viduranga Wijesooriya]

Hi Marc,
Would it be wise if we let users to set/change a flag about the behavior of the database tree in the conf.inc.php file ?

[Marc Delisle]

Viduranga,
yes, config.inc.php is the place to use configuration directives. In addition, there is the users preferences mechanism so that a user can change the preference from Settings.

[Michal Čihař]

Merged https://github.com/phpmyadmin/phpmyadmin/pull/1101.

[Maxime DAVID]

sorry I didn't see your comment
the link seems invalid since an extra dot appears at the end

https://github.com/phpmyadmin/phpmyadmin/pull/1101

[Marc]

after disabling this option no tables of selected database is shown (cp. 3.x versions)

[Marc Delisle]

Marc,
this is what "disable database expansion" means. You can see the tables if you click on the database name in the navi panel.

[Marc]

that is, what is currently implemented.
I suggest having an option to have the same view as in older versions:
navipanel shows all databases (on startup). If you select a database, the navipanel is expanded whith the tables of that database (others not).

This is likely the behaviour as it was in 3.x versions and which was discussed here.

[Marc]

Btw. why do you expand columns and indexes in navigation panel?