outroll / vesta

VESTA Control Panel
http://vestacp.com
GNU General Public License v3.0
2.97k stars 1.03k forks source link

[Feature] implements adminer that is much more stable and provide both mysql/postgres ui #2285

Open mckaygerhard opened 1 year ago

mckaygerhard commented 1 year ago

mplements adminer for database manager ui

currently with phpmyadmin and phppgadmin myvesta must mantain two different integrations, that introduced much more bug due complex "modern" tendency..

adminer is much more "simplified and simplistic" so bugs are much less (far away) rather than those two!

this was already requested as https://github.com/hestiacp/hestiacp/issues/561 and a first rudimentary PR was made long time ago in Vesta. https://github.com/serghey-rodin/vesta/pull/1847 ther is a feat request at hestia https://github.com/hestiacp/hestiacp/issues/3713

a PR was provide long time ago but seem in such time developers dont have "common sense".. now time passed and history facts demostrated superiority of adminer in security, code quality and performance

PROS AND CONS
key Adminer phpMyAdmin phppgadmin
Login support Its complete, offers permanent login including user list phpMyAdmin only partial support through configuration. phppgadmin relies on user privilegies, do not manage the pg_user
Supported DBMS MySQL/MariaDB/PostgresQL/etc Mysql only Postgresql
Code quality good too big too big
Popularity stable slow growning cos are not used by windosers its shipped inside xamp so its only popular due that its not so popular and ui is ugly
UI tweaking can be tweaked by just another php file as plugin cannot be tweaked without customizing new php files, already provided cannot be tweaked
Multiple editing Adminer features a special button that is displayed before this operation But its more limited phpMyAdmin allows you to use the clone row feature after altering. Hence it is possible to duplicate the row by mistake when auto keys are presents phppgadmin allow in line editing but it overloaded the ui
Schema Adminer uses HTML and JavaScript but in a string efficient way. Schema in phpMyAdmin is available after setting up and specifying extra tables in the configuration file and only through PDF or canvas. phppgadmin can access the two level of schema (as postgresql looks like oracles)
Database list Adminer downloads this data asynchronously. filtering is made by user access Database list is slow because it displays the number of tables and filtering rely in user access Database list is slow due the lot of features of postgresql but filtering is limited to user access, do not manage pg_Access
Customization Adminer offers advanced customization through a PHP extension class. just easy cos can made by separate files phpMyAdmin offers very simple customizations through special tables. but ui files are joining in php code phppgadmin ui is not fully customizable for
Size The latest full-featured version of Adminer (v4.7.8) comes in at a measly 478 KB, Adminer’s MySQL-only version (354 KB) phpMyAdmin’s latest version (v5.0.4) is 13.7 MB phppgadmin download size is aroung 10 to 20 megs