Adminer

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Adminer
Adminer screenshot
Adminer main screen
Developer(s) Jakub Vrána
Initial release July 25, 2007 (2007-07-25)
Stable release 4.1.0 (April 18, 2014; 7 months ago (2014-04-18)) [±]
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 SQL 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[edit]

  • 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[edit]

References[edit]

  1. ^ 2008 CCA: Finalists
  2. ^ Manage Your Database with Adminer
  3. ^ http://www.zdrojak.cz/clanky/phpmyadmin-vs-adminer/nazory/6737/
  4. ^ Vrána, Jakub (August 2009), Architecture of Adminer, php|architect 8 (8): 34–40 

External links[edit]