
In light of the 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 faced such a problem by deciding to look for alternatives to the well-known phpMyAdmin / php * Admin, which is considered the standard by webmasters.
And since in my life I love minimalism and speed, I was gnawed from the inside by the feeling that in order to view the table structures, data in the database, execute SQL queries, I drag a huge pile of files in the archive occupying 5MB, I started searching. And
www.adminer.org was found
A free open-source web-muzzle, extremely reminiscent of the phpMyAdmin interface in the form of a single * .php file with a size of 189 KB (in the minimum configuration). The functionality covers the needs of 95% of developers:
- MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB support
- Multi-language support
- Free for any use.
- View, create, edit data
- Working with table and database structures
- Work with indexes
- Dump and import
- Authentication mechanism with saving sessions
- Support themes (+1 .css file, I use this one )
- etc.
')
The quickest way is to familiarize yourself with the
demo and with screenshots on the
site .
Of the minuses I have noticed is incomplete support for postgresql data types (arrays, json, for example). For myself, I cured it 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.