Adminer
|
Adminer main screen | |
| Developer(s) | Jakub Vrána |
|---|---|
| Initial release | July 25, 2007 |
| Stable release | 4.2.3 (November 15, 2015) [±] |
| Written in | PHP |
| Operating system | Cross-platform |
| Available in | Multilingual (24) |
| Type | Web Database Management |
| License | Apache license or GPL v2 |
| Website | www.adminer.org |
Adminer (formerly known as phpMinAdmin) is a tool for managing content in MySQL databases (since version 2 also in PostgreSQL, MS SQL, SQLite and Oracle databases). Adminer is distributed under Apache license (or GPL v2) in a form of a single PHP file (around 300 KiB in size). Its author is Jakub Vrána who started to develop this tool as a light-weight alternative to phpMyAdmin, in July 2007. Adminer got some attention in 2008 when it made it to the CCA finals at SourceForge.[1] 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.[2] The project's priorities, according to its author, are (in this order): safety, user-friendliness, performance, functionality, and size.[3]
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, Catalan, Chinese, Czech, Dutch, English, Estonian, French, German, Hungarian, Italian, Japanese, Lithuanian, Persian, Polish, Portuguese, Romanian, Russian, Slovak, Slovenian, Spanish, Tamil, Turkish, Ukrainian)
- 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.[4]
See also
References
- ↑ 2008 CCA: Finalists
- ↑ Manage Your Database with Adminer
- ↑ http://www.zdrojak.cz/clanky/phpmyadmin-vs-adminer/nazory/6737/
- ↑ Vrána, Jakub (August 2009), "Architecture of Adminer", php|architect 8 (8): 34–40