Adminer
Page Module:Message box/ambox.css has no content.
 | This article needs additional citations for verification. (September 2009) |
Page Module:Infobox/styles.css has no content.
| Adminer | |
|---|---|
| Lua error in package.lua at line 80: module 'Module:InfoboxImage/data' not found. Adminer main screen | |
| [[Programmer|DeveloperTemplate:Pluralize from text]] | Jakub Vrána |
| Initial release | Script error: No such module "Date time". |
| Written in | PHP |
| Available in | 42 languages |
| Type | Database management system |
| License | Apache license or GPL v2 |
| Website | www |
Script error: No such module "Check for conflicting parameters".
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.[1] 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.[2] 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.[3] The project's priorities, according to its author, are (in this order): safety, user-friendliness, performance, functionality, and size.[4]
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)[5]
- 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.[6]
See also
Lua error in mw.title.lua at line 404: bad argument #2 to 'title.new' (unrecognized namespace name 'Portal').
References
Page Template:Reflist/styles.css has no content.
- ^ Page Module:Citation/CS1/styles.css has no content."Adminer - Database management in a single PHP file". www.adminer.org. Retrieved 2022-04-17.
- ^ 2008 CCA: Finalists
- ^ Manage Your Database with Adminer
- ^ Page Module:Citation/CS1/styles.css has no content."PhpMyAdmin VS Adminer". 11 January 2010.
- ^ Page Module:Citation/CS1/styles.css has no content."Adminer". SourceForge. Retrieved 2016-06-15.
- ^ Page Module:Citation/CS1/styles.css has no content.Vrána, Jakub (August 2009), "Architecture of Adminer", PHP-architect, 8 (8): 34–40
