Adminer, where have you been all my life?

How do you view and edit data in a mysql DB? Lots of ways.

There's always commandline mysql. This is how I do it around 50% of the time. But it could be better. ASCII-art table dumps are not the easiest things to read, and readline-based history and editing only gets you so far.

phpMyAdmin is what I grew up with. It's pretty good but it's way too heavyweight. It also has all kinds of funky Javascript, to the point where I actually use Greasemonkey to remove some of it. Auto-selecting query text when you try to edit it in particular drives me crazy. Auto-selecting ANYTHING on Linux, where selecting text usually equals clobbering the X clipboard, is a really really bad idea. Last I tried it's a one line of Javascript in Greasemonkey to fix this by the way:

document.getElementById('sqlquery').removeAttribute('onfocus');

But phpMyAdmin may have changed since last I used it, it's been a while.

There's the native mysql GUI, called mysql-gui-tools in Gentoo. It's a standalone app that's pretty good, but the Linux version is gimped up compared to the Windows version for some strange reason. In any case it seems to be discontinued or something. There's some new MySQL Workbench thing coming, which I'll probably try once it hits Gentoo, but it looks like overkill for my simple needs.

SQuirreL SQL is another cross-platform GUI app. It connects to lots of different kinds of DBs (pretty much any DB that Java can talk to), so at work where I have get my mysql server to talk to someone else's MS SQLServer (ugh) I use this. But it's very heavyweight and not the most enjoyable interface.

Last week I chanced upon something pretty good. Adminer is a single PHP file you throw on a server and there you go. It gives you something vaguely similar to phpMyAdmin but far more lightweight. There's very little Javascript messing with my query-writing and the styling is minimal and easy to read. I don't know how secure it is, so I don't plan to put it on any public servers, but on my test server doing web development it's good. I love bouncing back and forth between a the database in one browser tab and my website in another tab. This is what I use now.

November 28, 2009 @ 9:47 AM PST
Cateogory: Programming

2 Comments

Ferdinand Kuhl
Quoth Ferdinand Kuhl on November 28, 2009 @ 7:20 PM PST

Do you know SQL Buddy? It's another so called lightweight phpMyAdmin clone. As I am usually perfectly lucky with phpMyAdmin on my systems, I use it for the exploration of foreign application and databases. Perhaps you might give it a try? (There is some amount of javascript for its ajax-interface ... but i don't think there is much more than that)

http://www.sqlbuddy.com/

Jakub Vrána
Quoth Jakub Vrána on June 08, 2010 @ 7:24 AM PDT

I'm the author of Adminer and I'm glad that you are satisfied with it. You can bet that it is pretty secure. For last three years, Adminer fixed two security issues, phpMyAdmin twenty. I.e. defense against ClickJacking in phpMyAdmin was added five months after Adminer on my proposal.

I lead PHP security trainings and security of Adminer is the number one priority.

Speak your Mind

You can use Markdown in your comment.
Email/URL are optional. Email is only used for Gravatar.

Preview