Back to Home

Adminer - web interface for databases the size of a single .php file

mysql · postgresql · sqlite · db · subd · mongodb · mssql · oracle · elasticsearch · how not to write code

Adminer - web interface for databases the size of a single .php file



    In the light of a recent post about comparing PostgreSQL and MySQL , in the comments there was a problem of choosing a convenient interface for working with postgres. I myself encountered such a problem, deciding to look for alternatives to the well-known phpMyAdmin / php * Admin, which is considered the standard by webmasters.

    And since I love minimalism and speed in life, the feeling inside me was that inside for the sake of viewing the structures of tables, data in the database, executing SQL queries, I drag a huge pile of files in the archive occupying 5MB, then I started searching. And www.adminer.org was found. A

    free, open-source web-muzzle that resembles the phpMyAdmin interface in the form of a single * .php file of 189 KB in size (in the minimum configuration). Functionality covers the needs of 95% of developers:
    • Support MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB
    • Multilingual support
    • Free for any use.
    • View, create, modify data
    • Working with table and database structures
    • Work with indexes
    • Dump and import
    • Saving Session Authentication Engine
    • Support for themes (+1 .css file, I use this one )
    • etc.


    It will be most likely to familiarize yourself with the demo and with screenshots on the site .

    Of the minuses that I noticed - incomplete support for postgresql data types (arrays, json, for example). For myself, I cured this by editing the source code , but I have no more desire to look at the code, and I do not advise you. The main thing is that it performs its task.

    Read Next