PhpMyAdmin does not offer an interface for creating these objects and has only primitive functionality for altering them.Ĭalling stored procedures and functions in phpMyAdmin is possible only by creating a SQL query. Half of users do not know that it has a different function than table name, the other half is not sure which function it is.

It is not possible to alter a view in phpMyAdmin, it must be dropped and recreated manually.Īn example that applies to many differenet cases: there is an icon by table name in navigation.

Adminer offers a foreign keys interface directly in create/alter table. You have to create an index manually before you create the foreign key. It is not possible to create multi-column foreign keys in phpMyAdmin. Adminer allows manipulation with all indexes together. Adminer can reorganize columns and add them in different places – at once.Īdminer offers textarea with one item per line for enum type creation.Īdding an index is a slow operation with big tables.

PhpMyAdmin cannot move columns and cannot add columns in different places at once (every alter table is very slow when applied to big tables). The form design transposes based on the number of fields. In phpMyAdmin you have to specify the number of fields prior to creating the table. MySQL, SQLite, PostgreSQL, MS SQL, OracleĪdminer is also available in a MySQL-only version.Īdminer offers permanent login including user list, phpMyAdmin only partial support through configuration. Berikut ini tabel perbandingan antara PHPMyAdmin dan Adminer yang saya kutip dari situs resminya. Namun menurut situs resminya, Adminer, lebih baik. PHPMyAdmin memang salah satu tools manajemen database MySQL yang sangat terkenal dan banyak digunakan. Menarik bukan? Silahkan langsung dicoba saja, download di situs resmi Adminer atau coba demo onlinenya. Tidak perlu space yang besar, karena Adminer terdiri dari satu file PHP saja dengan ukuran kurang dari setengah Mega. Tidak hanya untuk MySQL, tapi juga bisa dipake untuk Oracle, SQL Lite, PostgreSQL dan MS SQL. Bosan dengan PHPMyAdmin? Ingin sesuatu yang lebih sederhana namun powerfull? Ini dia salah satu Database Client berbasis Web yang saya suka.

Contoh aplikasi client server sederhana