Manage Your MySQL Database Fast with Adminer
Database management is an integral part of a programmer’s life. Different programmers use different database solutions and management tools. In my case, I use MySQL. Then I use phpMyAdmin Adminer to manage my MySQL databases.
Just heard of Adminer from Erwin, one of our developers in WishList Products last Saturday. It’s been around for quite some time already, it’s just that I haven’t heard about it before. I took a quick look at it and I became a convert.
From phpMyAdmin to Adminer
Don’t get me wrong, phpMyAdmin is a powerful tool and I haven’t had any complaints with it. It’s awesome and does its job well. The main reason that I switched over to Adminer is its simplicity both in interface and installation.
One File to Rule it All - The entire Adminer system is contained in just one file making it easy to deploy on any server that supports PHP. Just drop the file and point your browser to the right URL and you’re done. Adminer will ask for your connection information and you’re on your way. This contrasts a lot with phpMyAdmin which is composed of a lot of files. One would argue that uploading phpMyAdmin to any PHP-supporting-server will work just as well and it’s true. But it’s just easier to upload just one file.
Simplicity Rocks - The whole interface of Adminer is just so simple I fell in love with it the first time I saw it. It’s not fancy at all. Just in case you don’t like how it looks, the guys at Adminer also provided with alternative CSS files to skin your interface. Awesome huh?
Manage at the Speed of Light - I couldn’t believe at how fast Adminer runs. It loads instantly on my local server and less than a second remotely. phpMyAdmin on the other hand takes longer – no need to say that but I just did.
As if that’s not good enough, Adminer also has a WordPress plugin that you can install allowing you to manage your database straight from within WordPress. No need to log on to cPanel for phpMyAdmin anymore. Again, there’s a phpMyAdmin plugin for WordPress too but it’s just too cumbersome to work with from within the WordPress UI.
But what there’s more!!! Adminer also supports SQLite, PostgreSQL, MS SQL, and Oracle. Nice huh?
That’s all I can say for now but something inside me tells me that I haven’t seen it all yet. This is one tool that coders like me will definitely love! Give it a try and let us know how it goes by posting your comment below.