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.
(Restricting mysql access to localhost and using an SSH tunnel is fine practice, AFAIK.)
Also, sequel (rubygem) comes with an awesome console to write SQL queries in.
He asked for a real superior alternative. In the same vain. Not something completely different.
>Like most things on the command line you are able to more much faster instead of having to deal navigate the GUI.
Not really. Between limitations of the readline lib and terminals, it's a pretty shitty experience. There's a limited stuff you can do faster in the command line.
edit: Also, GUI tools are very useful when you want to familiarize yourself with a large or complex database you haven't previously worked on.
 Demo: http://teampostgresql.herokuapp.com/ (runs on a free Heroku account so a bit slow, and demo users sometimes mess up the db)
Most large-ish Scheme systems have a module system. You're a bit limited if you stick with straight R5RS, but even then every serious compiler/interpreter has additional features. Not unlike Python, Perl, Ruby, PHP, etc. There is also R6RS and R7RS now, which have additional features now.
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.
Then I discovered the option to enable the old theme again. A great tool!
Edit: 'to' => 'too'
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.
Are there a lot of known security issues outstanding?
Besides MySQL, we also support PostgreSQL (what we use in house), Oracle and MS SQL Server.
Sep 9 12:58:29 [41.66.xxx.xxx] GET /phpMyAdmin/translators.html [1 ms]
I'm sure it's come a long way (at least I hope it has).
Also means you are more secure since PHPMYADMIN has a history of vulnerabilities and less to run on the server, so your database server can run mysql and nothing else (well maybe stunnel for encrypted connection to your app servers)
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.