[1] http://www.teampostgresql.com
[2] Demo: http://teampostgresql.herokuapp.com/ (runs on a free Heroku account so a bit slow, and demo users sometimes mess up the db)
But what PhpMyAdmin illustrates very well is how important tools can be to environments/communities. For a while, the presence of PhpMyAdmin was what gave PHP an edge over many other environments: here's a tool that gives you (and tech-savvy people in your company) insight into your database, allows you to do changes and some bit of backup visually instead of fighting with the command line. And, if you develop on PHP, you don't even have to install anything additional on your platform. It made running PHP hosting without shell access feasable.
I dislike what happened to the UX, though; definitely a case of "if it ain't broke, don't fk with it". Still a great tool though. I'm always lost on postgre projects...
Although I must say I've yet to see an SQL client that comes close to HeidiSQL (Windows only, MySQL+MSSQL only). (Edit: "MySQL only" was wrong.)
When I used PMA for the first time I was a very young programmer, and it really amazed me that such a tool could exist. Oddly enough, this was a really inspirational piece of software for me.
Also, sequel (rubygem) comes with an awesome console to write SQL queries in.
Then I discovered the option to enable the old theme again. A great tool!
Edit: 'to' => 'too'
It works great for MySQL, SQLite and can be used for some basic PostgreSQL work too.
Is this correct english? Im not a native english speaker. To me it sounds like it should read "in a single PHP file".
Same with "Replace phpMyAdmin by Adminer and you will get tidier user interface"
But then it doesn't have as much impact emphasising the simplicity of it.
The "single file" feature makes installation and updating easy, but the features and usability improvements over phpMyAdmin seal the deal.
It basically fixes every annoyance of phpMyAdmin. Zero config, saved logins, no iframes, consistent and predictable UI. Love this program.
I feel like lots of line of code usually means bloat.
That aside, I often use phpMyAdmin and it is a great tool for those quick little edits! And if you know already about SQL then it is really easy to use.
If you already know SQL then its much faster to type a line into the CLI than click the mouse 50000 times in a web gui. However, I do use it so when I'm on call I can walk someone thru a simple password reset, or something of similar level, over the phone rather than spend 45 minutes find and plug in the laptop, VPN in, do 15 seconds of work, then shut down everything and put it away until next time. Someone completely incapable of finding the semicolon key on a keyboard can usually none the less be successfully talked thru clicking the mouse 5000 times on a web page.
SELECT COUNT(*)
Are there a lot of known security issues outstanding?
Sep 9 12:58:29 [41.66.xxx.xxx] GET /phpMyAdmin/translators.html [1 ms]Besides MySQL, we also support PostgreSQL (what we use in house), Oracle and MS SQL Server.
I'm sure it's come a long way (at least I hope it has).
For example for my mobile backends, I use only phpmyadmin to populate the data and use rails scaffolds to provide json outout to the mobile clients.