Adminer (formerly known as phpMinAdmin) is a tool for managing content in databases. It natively supports

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...

MariaDB MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the ori ...

, PostgreSQL,

SQLite SQLite (, ) is a database engine written in the C programming language. It is not a standalone app; rather, it is a library that software developers embed in their apps. As such, it belongs to the family of embedded databases. It is the m ...

, MS SQL, Oracle,

Elasticsearch Elasticsearch is a search engine based on the Lucene library. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. Elasticsearch is developed in Java and is dual ...

and

MongoDB MongoDB is a source-available cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Ser ...

. Adminer is distributed under Apache license (or

GPL v2 The GNU General Public License (GNU GPL or simply GPL) is a series of widely used free software licenses that guarantee end users the four freedoms to run, study, share, and modify the software. The license was the first copyleft for general u ...

) in a form of a single

PHP PHP is a general-purpose scripting language geared toward web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1993 and released in 1995. The PHP reference implementation is now produced by The PHP Group. ...

file (around 470 KiB in size). Its author is Jakub Vrána who started to develop this tool as a light-weight alternative to

phpMyAdmin phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services. His ...

, in July 2007. Adminer got some attention in 2008 when it made it to the CCA finals at

SourceForge SourceForge is a web service that offers software consumers a centralized online location to control and manage open-source software projects and research business software. It provides source code repository hosting, bug tracking, mirroring ...

. 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 In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...

, select/edit tables, browse/insert/edit table rows * Searching or sorting via multiple columns * Editing of other database objects:

views A view is a sight or prospect or the ability to see or be seen from a particular place. View, views or Views may also refer to: Common meanings * View (Buddhism), a charged interpretation of experience which intensely shapes and affects thou ...

, triggers,

event Event may refer to: Gatherings of people * Ceremony, an event of ritual significance, performed on a special occasion * Convention (meeting), a gathering of individuals engaged in some common interest * Event management, the organization of e ...

s, 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 Usability can be described as the capacity of a system to provide a condition for its users to perform the tasks safely, effectively, and efficiently while enjoying the experience. In software engineering, usability is the degree to which a soft ...

interface (extensive employment of

JavaScript JavaScript (), often abbreviated as JS, is a programming language that is one of the core technologies of the World Wide Web, alongside HTML and CSS. As of 2022, 98% of websites use JavaScript on the client side for webpage behavior, of ...

) * 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 Syntax highlighting is a feature of text editors that are used for programming, scripting, or markup languages, such as HTML. The feature displays text, especially source code, in different colours and fonts according to the category of terms ...

* Visual database/ E-R schema editing * Countermeasures against XSS,

CSRF Cross-site request forgery, also known as one-click attack or session riding and abbreviated as CSRF (sometimes pronounced ''sea-surf'') or XSRF, is a type of malicious exploit of a website or web application where unauthorized commands are submitt ...

SQL injection In computing, SQL injection is a code injection technique used to attack data-driven applications, in which malicious SQL statements are inserted into an entry field for execution (e.g. to dump the database contents to the attacker). SQL in ...

, 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.

References

{{reflist

External links

Project homepageReview at Linux.com
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

Features

See also

References

External links