From Surf Wiki (app.surf) — the open knowledge base

Adminer

Tool for managing content in databases

Field	Value
name	Adminer
screenshot	Latest Adminer – database overview.png
caption	Adminer main screen
developer	Jakub Vrána
released
latest release version
programming language	PHP
language count	42
genre	Database management system
license	Apache license or GPL v2
website

Adminer (formerly known as phpMinAdmin) is a tool for managing content in databases. It natively supports MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch and MongoDB. Adminer is distributed under Apache license (or GPL v2) in a form of a single PHP file (around 470 KiB in size). Its author Jakub Vrána started to develop this tool in July 2007 as a light-weight alternative to phpMyAdmin. Adminer got some attention in 2008 when it made it to the CCA finals at SourceForge. Also, first webhosting providers started to include Adminer as MySQL managing tool into their portfolio of services. In 2012 Adminer got coverage on Linux.com for the second time. The project's priorities, according to its author, are (in this order): safety, user-friendliness, performance, functionality, and size.

Features

Users log in specifying the destination server and providing the user name and password (which is stored during whole session)
Basic functions: select database, select/edit tables, browse/insert/edit table rows
Searching or sorting via multiple columns
Editing of other database objects: views, triggers, events, stored procedures, processes, mysql variables, user permissions
Text area for arbitrary SQL commands and storing these commands in command history
Export of databases and tables (its structures and/or data) as a dump to output or a downloadable attachment
User-friendly interface (extensive employment of JavaScript)
Multiple language support (Arabic, Bengali, Catalan, Chinese, Czech, Dutch, English, Estonian, French, German, Greek, Hungarian, Italian, Indonesian, Japanese, Korean, Lithuanian, Persian, Polish, Portuguese, Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Tamil, Thai, Turkish, Ukrainian, Vietnamese)
SQL syntax highlighting
Visual database/E-R schema editing
Countermeasures against XSS, CSRF, SQL injection, session-stealing, ...
"Light-weight" – released in a form of a single file
Support of CSS "skins", as well as many extensions

The small single file is a result of compilation and minification of source codes.{{Citation

References

"Adminer - Database management in a single PHP file".
[https://sourceforge.net/blog/cca08-finalists/ 2008 CCA: Finalists]
[https://www.linux.com/tutorials/manage-your-database-adminer/ Manage Your Database with Adminer]
(11 January 2010). "PhpMyAdmin VS Adminer".
"Adminer".

Info: Wikipedia Source

This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page.

database-administration-tools free-software-programmed-in-php cross-platform-software software-using-the-apache-license mysql mariadb postgresql sqlite oracle-database-tools microsoft-database-software

Want to explore this topic further?

Ask Mako anything about Adminer — get instant answers, deeper analysis, and related topics.

Research with Mako

Free with your Surf account

Content sourced from Wikipedia, available under CC BY-SA 4.0.

This content may have been generated or modified by AI. CloudSurf Software LLC is not responsible for the accuracy, completeness, or reliability of AI-generated content. Always verify important information from primary sources.

Report