Need advice about which tool to choose?Ask the StackShare community!
phpMyAdmin vs phpPgAdmin: What are the differences?
What is phpMyAdmin? A free software, for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.
What is phpPgAdmin? Software project released under the PostgreSQL/Artistic licence. It is the leading graphical Open Source management, development and administration tool for PostgreSQL, running on Windows, Linux, Solaris, FreeBSD and Mac OSX.
phpMyAdmin can be classified as a tool in the "Database Tools" category, while phpPgAdmin is grouped under "Log Management".
phpPgAdmin is an open source tool with 281 GitHub stars and 130 GitHub forks. Here's a link to phpPgAdmin's open source repository on GitHub.
We were looking a tool that would allow us to do MySQL and PostgreSQL development/administration from a single tool. We decided on Navicat Premium because it can connect to MySQL, MariaDB, MongoDB, SQL Server, Oracle, PostgreSQL, and SQLite databases - and simultaneously. It's also compatible with Amazon RDS and Microsoft Azure, which we also use.
Moreover, we previously experienced the occasional freezing and crashing in MySQL Workbench. It also suffered from a poor design, with certain features being a bit difficult to find. Meanwhile, phpMyAdmin lacked schema visualization tools and seemed better suited to lightweight day to day transactions than some of the big jobs that we needed to do.
Pros of phpMyAdmin
- Query linter5
- Easy data access5
- User administration5