A Chat About Adminer – A Simple, Yet Effective, Database Management tool written in PHP

A Small Intro..

Adminer - A Full-Featured Database Management Tool

Adminer – A Full-Featured Database Management Tool

Adminer, formerly known as phpMinAdmin, is a full-featured database management tool to be used as a more simple, effective and fast alternative to the famous PHPmyAdmin. Being curious about it, I had a chat with the creator of Adminer, Jakub Vrana.

Who Is Jakub Vrana?

Last time I did a thorough PHP Interview with Jakub Vrana (Co-Author Of The Official PHP Manual), so you can read his whole bio and PHP advice here: PHP Interview With Jakub Vrana

Jakub Vrana - Co-Author Of The Official PHP Manual

Jakub Vrana – Co-Author Of The Official PHP Manual

Adminer – The Interview

>> What does Adminer try to solve

Adminer is a database management tool written in PHP. If you want to create a new database table, insert a record or just select some data, Adminer is here for you.

>> How did the idea to build it come?

I needed to execute some SQL query on a database server accessible only from the web server. I didn’t have phpMyAdmin there and I got tired of copying 10 MB in 666 files of phpMyAdmin (at that time) just to execute that SQL query. So I created a simple script which evolved into a feature complete tool.

>> Why would you convince a PHP guy to use it as compared to PHPMyAdmin for example?

The main difference is hopefully the user experience – everything is easier accessible, less error-prone and faster than in phpMyAdmin or most other tools. Installation and configuration makes also a big difference – just copy one small file of Adminer and use your DB user and password for login. Surprisingly, even though Adminer looks very simple and easy to use, it actually has more features than phpMyAdmin. I’ve created a detailed comparison of Adminer and phpMyAdmin at http://www.adminer.org/en/phpmyadmin/. To be objective – it’s possible that phpMyAdmin is a better choice for someone with very different values than me or than most people who tried both tools.

There are also number of desktop tools (sometimes with a web proxy to mitigate the DB-accessible-only-from-web problem) but I like the freedom of web – I can access the DB from any computer or from my phone using the same tool without any compromises.

>> What is the current status of Adminer

I don’t add much features to Adminer recently. I still maintain it and I publish a new version every 6 months or so.

>> what do you plan for it in the near future? Will it be around for a long-term basis?

I have some plans for the next major version but I didn’t start with it yet. I plan to support Adminer at least for several next years.

>> How has the PHP Community responded to Adminer so far?

Based on the feedback, 95+ % people who tried both phpMyAdmin and Adminer stayed with Adminer. The problem is that most people aren’t aware about the alternatives.


Want To Be Cool? Do Something Simple!

1) LIKE 7PHP dot COM on FaceBook – if you appreciate what I do

2) Help diffuse this interview to the PHP ecosystem – Share, tweet and spread the word to your audience ==> That would be a FREE way to thank me 😉

3) Make a comment below using the comment form – I’m sure you can at least say 1 word about this interview

{I’m thankful to your response(s)!}

If You Appreciate What I Do Here On Seven PHP :: 7PHP, You Could Consider:

  1. Following me on Twitter | @7php
  2. LIKE-ing my FaceBook page
  3. Subscribe to my Email List - see top-right subscription box
  4. Help diffuse this interview to the PHP ecosystem - Share & Spread the word as far as you can ==> That would be a FREE way to thank me
  5. Use my DigitalOcean referral link if you plan to use it as your VPS (it starts at only $5/month btw) or if you can refer it to your friends, highly appreciated.
  6. Support via Paypal donate - my Paypal ID is w@7php.com

{I'm thankful to your response(s)!}

Valuable Feedback / Comment / Review From People Like You

  1. Rajveer says:

    Thanks for sharing this information. Actually you are right few peoples are aware from this alternative of phpmyadmin. Thanks a lot for such a nice post.

  2. It looks simple, it works faster. Since you now have a new user and promoter.

  3. Peter Kokot says:

    This application is very good indeed and faster. Problem is that PHPMyAdmin is integrated by default in xampp and wamp and many users don’t even know for this alternative. Thanks for sharing. Regards.

  4. I discovered it about 2.5 years ago and it actually changed how I work on databases. Adminer is immensely useful, takes single wget to install, requires 0 configuration. I never looked back. Postgres and sqlite support is something I frequently take advantage of too. Absolutely recommended.

  5. viliam says:

    You can check one more tool – Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

  6. SergeiK says:

    You can also use dbForge Studio for MySQL http://www.devart.com/dbforge/mysql/studio/ Great functional and intuitive GUI will make you work with MySQL fast and easier!

  7. Hi Sergeik,

    thanks for your comment and for your suggestion.

Speak Your Mind