Adminer

Database management

Updated November 15, 2018

5 updates


SCORE BREAKDOWN

User Interface

20/25

Cost

25/25

Differentiation

20/25

Effectiveness

25/25

Pros

  • Open source
  • WordPress plugin
  • Lightweight

Cons

  • Dated design
  • Highly technical
  • Limited exporting capabilities compared to PHPMyAdmin

Adminer is a database management tool built entirely in the PHP programming language for database frameworks like MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, among others. The tool is also a lightweight alternative to “heavier” PHP-based database management tools.

Let’s begin: Adminer is highly technical

Adminer is a highly technical tool for the average computer user. For any newbie to database management or to open source technology, Adminer is not a good fit. Organizations and advocacy groups interested in deploying Adminer must have the staff or the access to consulting talent who can facilitate a successful installation. If organizations are unable or unwilling to hire new staff or consultants for coding tasks, they should opt for a hosted database management solution or software-as-a-service solution (e.g., QuickBase, etc.).

Lightweight and powerful

Adminer is an open source solution available for download in multiple languages, for different operating systems, and in various distributions and technical frameworks. Users can easily access Adminer from the project’s website and download the version of the software directly to their computer. Adminer has an Apache Software Foundation license verification.

Once a user chooses the download of their choice, the file sizes are tiny and can be quickly installed. The download for the English-only edition of the software’s 4.6.3 version is only a 311 kB PHP file. The software can be installed with great ease. For example, if a user installs Adminer on an Ubuntu distribution of Linux, they only need to download the correct directories and infuse the proper commands into a LAMP server. (A LAMP server is a web development platform that utilizes Linux as the operating system (L), Apache as the web server (A), MySQL as the relational database framework (M), and PHP as the programming language (P).) Linux and these various frameworks are all operating systems used by developers to create multiple applications.

Intended use and database connections

Adminer, as described earlier in this review, is a database management tool which permits users to manage databases, tables, columns, relations, indexes, users, permissions, and more. Typically, database management tools are web-based platforms. Anyone who maintains databases in MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, or others can use Adminer as a replacement for traditional management panels or other open source tools, like the popular PHPMyAdmin. Adminer was developed as an alternative to PHPMyAdmin. Adminer is more flexible than PHPMyAdmin. PHPMyAdmin has been known to be “heavier” and limits advanced customization utilities. For users some, according to user reviews, Adminer has pulled ahead of its open source rival by offering greater customization and unique user experience (UX). However, both tools do the same job, and both even have popular WordPress plugins to connect a database with consumer-facing web assets.

The user experience for Adminer

Though these objections are focused on aesthetics, the Adminer UX isn’t representative of the power of the tool. Adminer’s user dashboards are dated and aren’t as responsive as one would hope. Regardless, users do have the ability to customize the theme of the Adminer software once installed.

Pricing

Adminer is a free, open source tool.

What we think

If organizations and campaigns have the necessary technical talent at their disposal, then they should give Adminer a go. The software is free to download and could resolve some significant issues associated with similar database management tools. But, for the organizations who don’t have the talent, don’t even try it. There is nothing wrong with deploying a hosted database solution or using software that’s easier to understand.

If you have any feedback on this review or you would like to suggest an app for us to review, please drop us a note – telegraph@joinlincoln.org.


Screenshots

SCORE BREAKDOWN

User Interface

20/25

Cost

25/25

Differentiation

20/25

Effectiveness

25/25

Get Adminer