CHANGELOG.md

Adminer dev

Internal

• Install PHPCS and PHPStan by composer install, like ESLint
• Skip all the linters in composer install --no-dev, it only initializes the submodules

Adminer 6.0.0 (released 2026-08-07)

• Escape index type, algorithm and length in table structure (XSS)
• Escape event schedule and non-numeric table status values (XSS)
• Fix translations containing an apostrophe in single language versions
• Escape < in strings printed to JavaScript, a name containing <!--<script> broke the page
• Login: Disallow accessing servers which accept any password (e.g. PostgreSQL with trust authentication)
• Login: Suggest the login-reverse-proxy plugin when throttling logins of a proxied request
• Select: Disallow modifying data by the SQL operator (CSRF)
• Check for a new version even without JavaScript
• Fix JavaScript in Safari < 11 and Firefox < 52 (regression from 5.5.0)
• Fix showing and hiding elements in Chrome < 61 and Edge < 17 (regression from 5.1.0)
• Send the JSON responses of AJAX requests as application/json instead of text/javascript
• Sort languages by their translated name
• Fix the copy to clipboard icon not displayed on Apple systems
• Close the menu on small screens by Esc
• Drop compatibility with IIS 5 and with IIS 7.0 before its 2008 FastCGI update
• Shorten URLs by escaping only the necessary characters, e.g. where[0][col] instead of where%5B0%5D%5Bcol%5D
• Send GET forms by JavaScript to shorten their URLs too
• Tables overview: speed up, show totals in SQLite, real size in MS SQL, Oracle
• Table structure: Shorten long checks and generated columns
• SQL command: Show column type in result table header
• SQL command: Show number of rows in all drivers
• SQL command: Export result to CSV by JavaScript without re-running the query (bug #1108, SF-760)
• SQL command: Rollback an unfinished transaction so that it doesn't break the following queries
• Alter table: Add next column without page reload
• Alter table: Do not highlight other move handles while dragging a column
• Alter table: Move columns on touch screens
• Alter table: Edit multiline column comments in a textarea
• Alter table, Privileges: Do not print a success message if nothing was changed
• Alter table, Select: Warn if the number of fields can exceed max_input_vars
• Alter view, routine and type: Use a transaction instead of a temporary object in PostgreSQL, SQLite, MS SQL
• Alter routine: Fix altering a routine with a name longer than 42 characters
• Select: Remove asking for the page number after clicking the Page legend
• Select: Highlight the current page in the pagination
• Select: Fix the number of selected rows after going back in history
• Select: Keep sorting by an aggregation function in the Sort fieldset
• Select: Show the edit link before the row checkbox and align the column to the right
• Select: Move the Modify link to the Modify fieldset, disable Save until a value is modified
• Select: Disable inline edit of binary values
• Select: Clear the search field and its column by Esc in Firefox
• Select: Import CSV in all drivers, not only in those with their own way to insert or update a row
• Select: Fix Load more data in drivers paginating by a cursor (Redis, SimpleDB)
• Select: Prefill New item with the values of all columns searched by equality, not only foreign keys
• Edit: Keep values of columns with special characters in name after error
• Edit: Fix switching function to SQL with the edit-foreign plugin (bug #1254)
• Edit: Hide the value field for functions without arguments (e.g. now, uuid)
• Edit: Fix editing rows with binary columns in tables without a unique key
• Edit: Disable Save and continue edit after changing a value identifying the row
• Select, Edit: Highlight JSON by a dedicated highlighter instead of the JavaScript one
• Export: Fix the TAR archive of multiple tables in CSV, it contained SQL of views and foreign keys
• Export: Export data in all drivers, not only in those able to run the generated SELECT
• Export: Fix importing a dump with data only, the tables were truncated one by one and their foreign keys were re-created
• MySQL: Do not use SSL if the login-ssl plugin is configured only for other drivers
• MySQL: Cache the list of databases only if getting it is slow
• MySQL: Link performance_schema and sys tables to their documentation
• MySQL: Fix length of routine parameters with unsigned or zerofill, support MySQL < 8 again (bug #1312, regression from 5.4.4)
• MySQL: Fix a warning on the Create table page with the PDO extension
• PostgreSQL: Support operator classes in indexes
• PostgreSQL: Do not show functions and types created by extensions
• PostgreSQL: Create routines with a dollar quoted body so that it is not escaped
• PostgreSQL: Fix altering functions with parameters of array or user-defined types
• PostgreSQL: Hide table actions and row editing in pg_catalog and pg_toast
• PostgreSQL: Support range types (bug #1308)
• PostgreSQL: Show composite, domain and range types next to enums
• PostgreSQL: Alter and rename user defined types
• PostgreSQL: Add values to an enum type without re-creating it
• PostgreSQL: Export all user defined types, fix exporting enum values containing an apostrophe
• PostgreSQL: Drop all tables at once in export so that foreign keys, views and types don't prevent the drop
• PostgreSQL: Drop the selected tables at once so that foreign keys don't prevent the drop
• PostgreSQL: Export materialized views with their indexes, they were exported as plain views
• PostgreSQL: Import CSV by INSERT ... ON CONFLICT instead of two queries for each row
• PostgreSQL: Show, alter and export Auto Increment, only sequences with an unusual name were exported
• PostgreSQL PDO: Fix the number of affected rows in COPY ... FROM stdin
• PostgreSQL, MS SQL: Show two columns in select COUNT(*), COUNT(DISTINCT id)
• PostgreSQL, MS SQL: Highlight primary keys in the database schema (regression from 5.1.0)
• CockroachDB: Do not offer deferrable foreign keys, they are not supported
• SQLite: Fix working with binary data through PDO
• MS SQL: Treat binary fields as blob (bug SF-369)
• MS SQL: Hide table actions and row editing in the sys schema
• MS SQL: Fix cloning and inserting a row with an identity column, the form offered the original value
• MS SQL: Fix error on the databases overview if a database has no collation
• Elasticsearch, ClickHouse: Use default port
• Elasticsearch: The driver is no longer beta, it works with Elasticsearch 7, 8 and 9
• ClickHouse: Fix nullable columns, fix default values, show server version
• ClickHouse: Support schema management, introspection and administration
• MongoDB: Authenticate against the database used in login
• MongoDB: Do not treat the string NULL as the NULL value
• MongoDB: Show the primary key column when altering indexes (regression from 5.4.0)
• Redis: SQL command in the redis-cli syntax, print executed commands
• Redis: Print binary keys and values in the redis-cli syntax
• Redis: Display the type of keys
• SimpleDB: Use default server
• CSS: Improve contrast of query time and dark mode
• CSS: Display the repeated links and row checkboxes outside the table, designs/adminer-border keeps them inside
• Editor: Display all images recognized by PHP, set their size, load them lazily
• Editor: Fix a fatal error in select with an empty foreign key value (regression from 5.1.1)
• Editor: Don't offer an empty option in a select of a not null foreign key, saving it failed in the database
• Designs: Show version of Adminer next to a used design not matching this version
• Plugins: dumpData() gets the parts of the select instead of a query, it selects the rows by Driver::select()
• Plugins: Methods importPrint() and importProcess()
• Plugins: Method verifyVersion()
• Plugins: Methods commentValue() and commentInput() (bug #1233)
• Plugins: Show driver plugins in the list of loaded plugins
• Plugins: Show version of Adminer next to plugins not matching this version
• Plugins: Remove edit-calendar, tinymce, json-column, pretty-json-column, translation, email-table, dump-php, master-slave
• Plugins: Do not fail with a fatal error when a plugin is not an object (bug TimWolla/docker-adminer#211)
• Plugins: Fix missing translations in the compiled version
• Driver plugins: Do not bundle the syntax highlighter of igdb and simpledb, load it from adminer-plugins/jush-<driver>.js
• Plugin login-ip: Allow localhost by default, require the request to not be proxied if X-Forwarded-For prefixes are not specified
• Plugin login-password-less: Allow the plugin password to be also the password of some server
• Plugin menu-links: Add option to show the select link and other repeated links only on hover
• New plugin: Create a table from an imported CSV file
• New plugin: Display images in select, same as in Adminer Editor
• New plugin: Log in only by a passkey holding the passwords
• New plugin: Warn by a red strip if Adminer or the database doesn't run on the local machine

Internal

• Register JavaScript event handlers by a data attribute instead of a script element
• Register the event handlers in functions.js instead of an inline script
• Composer: Initialize submodules on install
• Remove the Makefile, Composer scripts cover compiling and cleaning
• Move documentation to docs/, linter configuration to conf/, coverage.php to tests/
• Add docs/versions.php measuring the size of all releases
• Coding style: Wrap lines to 200 characters
• Cache PHP_CodeSniffer results in the system temp directory
• PHPStan: Check the Editor, more checks which the code already passes
• Add type declarations to all drivers and the Editor
• Use named constants instead of their values
• Compile: Exit if a replacement doesn't match
• Compile: Fix compiling a driver without support for the SQL command
• Compile: Compress translations with the English translation as a dictionary, it saves 21 kB
• Require ES6 in JavaScript, remove old browser workarounds
• Use standard JSDoc @param and @return syntax
• ESLint: Install it by composer install, run it in composer check and CI
• ESLint: Check also the jush modules compiled into the single file
• Docs: Handling of values and binary data, plugin translations, CSS changes must not break skins
• Rename the Git master branch to main
• Run the command line tests by composer test and in CI
• Convert the end-to-end tests from Katalon Recorder to Playwright, run them headless by composer e2e
• Fix the code coverage reporting all files as fully covered when OPcache is enabled

Adminer 5.5.1 (released 2026-07-21)

• Ignore invalid X-Forwarded-Prefix (GHSA-fr74-9mf9-gf44)
• Login: Allow :/_ in server (bug #1305, regression from 5.5.0)
• Compile: Valid UTF-8 (bug #1113, #1213)
• Add missing translations
• Syntax highlighting: Update MySQL, MariaDB, SQLite, PostgreSQL
• Support disabled set_time_limit() and ini_set() (bug #1288)
• PostgreSQL: Log in with empty server (bug #1304, regression from 5.5.0)

Internal

• Compile: Replace LZW with deflate compression
• Update PHPCS and PHPStan

Adminer 5.5.0 (released 2026-07-17)

• Disallow invalid port or socket (GHSA-58cq-mgw2-38m5)
• Ignore invalid X-Forwarded-Prefix (GHSA-8478-xrj3-h9c2)
• Hide copy to clipboard in insecure contexts
• Process list: Copy query to clipboard
• Wrap uneditable values in edit form
• Syntax highlighting: Speed up
• Allow connecting to socket without hostname (bug #1199, regression from 5.4.0)
• MySQL: Do not export IN in FUNCTION parameters (regression from 5.4.2)
• MySQL: Convert vector columns to text in select and edit
• MySQL: Unsupport MySQL < 5.1
• MySQL, SQLite: Draggable columns in alter table
• MariaDB: Support inet4 and inet6 types
• MariaDB: Allow setting password with password validation plugin (bug SF-814)
• MariaDB 11.7+: Support vector columns and indexes
• PostgreSQL 9.2+: Highlight queries in process list
• SQLite: Support ANY type
• SQLite: Support STRICT and WITHOUT ROWID tables
• SQLite: Do not treat INTEGER PRIMARY KEY without AUTOINCREMENT as auto increment
• SQLite: Disable editing of sqlite_schema
• MS SQL: Fix multiple result sets (bug #1180)
• New plugin: Redis driver
• New plugin: Login behind a reverse proxy

Adminer 5.4.4 (released 2026-07-11)

• Fix blob editing (bug #1251, regression from 5.4.2)
• Speed up HTML escaping (bug #1147)
• MySQL: Fix routine fields length (bug #1267, regression from 5.4.2)
• MySQL: Preserve DETERMINISTIC and DATA ACCESS in routine definition (regression from 5.4.2)
• MySQL: Export binary data as hex (bug #1123, SF-741)
• MariaDB: Hash password in privileges (bug #1166, regression from 4.7.2)
• MariaDB: Speed up getting checks (bug #1245, regression from 5.4.2)
• MariaDB, PostgreSQL: Use CREATE OR REPLACE FUNCTION if possible
• PostgreSQL: Allow exporting more schemas at once (bug #1243)
• PostgreSQL: Fix editing jsonb[] columns (bug #1300, regression from 5.4.2)
• PostgreSQL: Fix displayed size of bytea
• PostgreSQL 18: Support VIRTUAL generated columns (bug #1286)
• MS SQL: Fix table status (bug #1146)
• PDO: Increase precision of double (bug #1214)
• Editor PDO: Fix foreign key value in edit (bug #1242)
• Editor PostgreSQL: Fix enums (bug #1241)
• Plugins: Method menuActions() (bug #1303)

Adminer 5.4.3 (released 2026-07-09)

• Check Sec-Fetch-Site header (GHSA-33j4-hc95-pggg)
• Escape REQUEST_URI (GHSA-c533-9qwm-8w5h, bug #1298)
• Validate server (GHSA-r4x9-5m63-3vxw)
• Validate server version (GHSA-h6jr-7pr6-grgj)
• SQLite: Disallow ATTACH commands (GHSA-q4f2-39gr-45jh)
• SQLite: Disallow VACUUM INTO commands (GHSA-gmx3-g29w-77wf)
• SQLite: Check filename before deleting (GHSA-6pg3-chwq-wgqc)
• Avoid unserialize() in brute force protection (bug #1289)
• Tables overview: allow sorting (bug #1231)
• Select: Disable Ctrl+click inline edit without UPDATE privilege
• Select: Display NULL in column title
• Export: Remember unchecked objects (regression from 5.0.6)
• Foreign key: Display new field in case of an error
• PostgreSQL: Order NULL last
• PostgreSQL: Display all SQL command warnings and only once
• PostgreSQL: Export serial as serial, not nextval()
• PostgreSQL: Fix GENERATED AS IDENTITY export (bug #1260)
• PostgreSQL: Export schema in nextval()
• PostgreSQL: Export schema in REFERENCES
• PostgreSQL: Add ~* operator (bug #1271)
• Editor: Display tinyint(1) as checkbox (bug #1246, regression from 5.4.2)
• Croatian translation

Adminer 5.4.2 (released 2026-02-08)

• Avoid denial-of-service via version check (GHSA-q4f2-39gr-45jh, regression from 4.6.2)
• Pretty print JSON in edit
• Support multiline generated values in alter table
• Link //domain.tld values
• Improve print of nested tables
• Hide sort links on unsortable columns
• Display uneditable fields in edit form
• Shorten all but numeric and date types in select
• Fix escaping spaces in cookie value (bug #1208)
• Don't quote comma in TSV export (bug #1238)
• Autocomplete: fix in empty textarea (bug #1173)
• Prolong printed SQL query to 10000 characters (bug #1186)
• MySQL: Use information_schema to get routine definition (bug #1179, SF-711)
• MariaDB: Don't display checks with the same name from another table (bug #1135)
• PostgreSQL: Offer foreign keys in create table
• PostgreSQL: Add missing parentheses to CHECK export
• PostgreSQL: Allow creating NOT DEFERRABLE foreign keys
• PostgreSQL: Remove duplicate DEFERRABLE in foreign key export
• PostgreSQL: Add schema to sequence and view export
• PostgreSQL: Fix definition of complex generated columns
• PostgreSQL: Mark unique partial indexes as unique (bug #1172)
• PostgreSQL: Fix namespace in inheritance links (bug #1221)
• non-PostgreSQL: Display NOT NULL checks (bug #1237)
• ClickHouse: Fix offset (bug #1188)
• ClickHouse: Fix list of tables (bug #1176)
• Plugins: Methods showVariables() and showStatus() (bug #1157)
• Plugins: Allow to be in any namespace
• New plugin: IGDB driver

Adminer 5.4.1 (released 2025-09-26)

• SQL command: Unlink NULL primary keys
• Do not quote 0 in CSV export
• Warn about exceeded upload_max_filesize in imports
• Prolong queries saved from SQL command to URL (bug #1154)
• MySQL: Fix displaying routine definition (bug #1156, regression from 5.4.0)

Adminer 5.4.0 (released 2025-09-08)

• Allow specifying operator in search anywhere
• Do not order descending in GROUP BY select
• Allow exporting SQL in SQL command (bug #1092)
• Add section links in database overview
• Warn about exceeded max_file_uploads in import
• Display @ after username without server in existing logins
• Display data length and index length for materialized views
• Link routines from syntax highlighting
• Autofocus added field in alter table
• Executed SQL commands: Add button for copy to clipboard
• Load more: run syntax highlighter
• Allow connecting to IPv6 (bug #1095)
• MySQL: Fix saving empty enum (bug #1152)
• MySQL 5.0-: Do not load partitioning info in alter table (bug #1099)
• MariaDB: Parse COLLATE in routine definition (bug #1104)
• PostgreSQL: Show structure of inherited tables
• PostgreSQL: Display index expressions
• PostgreSQL: Add SQL operator to select
• PostgreSQL: Hide only partitions, not all inherited tables from menu
• PostgreSQL: Allow comparing json columns (bug #1107)
• PostgreSQL: Shorten values in hstore columns
• PostgreSQL: Quote edit value with interval operator
• PostgreSQL: Fix calling functions with name-less parameters
• PostgreSQL: Fix calling functions returning table
• PostgreSQL: Don't treat user types containing 'file' as blobs (bug #1118)
• PostgreSQL: Export DROP and CREATE DATABASE (bug #1140)
• PostgreSQL 11-: Avoid duplicate oid in table status (bug #1089, regression from 5.3.0)
• Elasticsearch: Support dropping aliases
• Plugins: Methods afterConnect(), processList() and killProcess()
• New plugin: Display row numbers in select (bug #1106)
• New plugin: Specify query timeout

Adminer 5.3.0 (released 2025-05-04)

• Align numeric functions right
• Autocomplete: Support table aliases
• Fix type error in Create function (bug #1053, regression from 5.1.1)
• Add border to column actions (bug #1072)
• Align money values right (bug #1071)
• MySQL: Avoid warning on selecting tables with fulltext indexes (bug #1036)
• MySQL, PostgreSQL: Support index algorithms (bug #1030)
• MySQL: Fix connecting to localhost:3306 (bug #1057, regression from 5.1.1)
• PostgreSQL, CockroachDB: Creating partitioned tables (bug #1031)
• PostgreSQL: Move partitioned tables from table list to parent table
• PostgreSQL: Support partial indices (bug #1048)
• PostgreSQL: Support calling functions returning table (bug #1040)
• PostgreSQL: Add NOT ILIKE operator (bug #1066)
• Editor: Fix bit and enum search (bug #1062)
• Designs: adminer.css with 'prefers-color-scheme: dark' doesn't disable dark mode
• Plugins: Method bodyClass() to add <body class>
• Plugins: Allow setting dark mode in css()
• Hindi translation

Adminer 5.2.1 (released 2025-04-11)

• Fix search anywhere (bug #1004, regression from 5.1.1)
• Fix import without primary key (bug #1017, regression from 5.1.1)
• PostgreSQL PDO: Fix bytea without primary key (bug #1021)
• non-MySQL: Parse '--' without trailing space as comment in SQL command (bug #1025, regression from 5.2.0)

Adminer 5.2.0 (released 2025-04-08)

• Autocomplete SQL commands
• Do not edit NULL values by Modify (bug #967)
• Fix foreign key actions (regression from 5.1.1)
• MySQL: Display number of found rows in group queries (regression from 5.1.1)
• PostgreSQL: Support COPY FROM stdin in SQL query (bug #942)
• non-MySQL: Parse '--' without trailing space as comment in SQL command (bug SF-842)
• MS SQL: Limit one INSERT in export to 1000 rows (bug #983)
• CSS: Add logo
• Editor: Move mass sending e-mails to a plugin
• Plugins: Support translations by extending Adminer\Plugin
• New plugin: Configure options by end-users and store them to a cookie
• New plugin: Configure menu table links
• New plugin: Set up driver, server and database in Adminer Editor

Adminer 5.1.1 (released 2025-04-02)

• Export: Fix tar (regression from 5.0.3)
• Select: Allow ordering by COUNT(*) (bug #966, regression from 5.0.2)
• Optimize retrieving columns for schema
• Elasticsearch: Make it work with Elasticsearch 8
• CSS: Hide menu on mobile
• CSS: Invert icons in dark mode
• Plugins: Allow changing CSP by more plugins
• New plugin: Use Monaco Editor for syntax highlighting
• New plugin: Use Prism for syntax highlighting

Internal

• Describe array shapes in doc-comments by the PHPStan syntax
• Declare parameter, return and property types in the code instead of the @param tag
• Require PHP 7.4 to run from source, strip the types when compiling to stay compatible with PHP 5.3
• Check the code by PHPStan level 6
• Add a common ancestor to the Db classes of all extensions
• Plugins: Call the plugins by __call(), register Adminer as the last plugin
• Remove all global variables
• Stop ignoring the notice about accessing an array offset on null
• Use strict mode in JavaScript
• CSS: Style the alter table images by background-image instead of <input type="image">
• CSS: Inline the images and remove them from the repository together with the code serving them
• CSS: Add variables for the default background and foreground color
• Tests: Generate the same test for all databases, add Elasticsearch, create the homepage screenshots

Adminer 5.1.0 (released 2025-03-24)

• Display collation at table structure if different from table
• Ctrl+click in select moves the cursor in modern browsers
• URL parameter ?ext=pdo to force using PDO
• PDO: Handle PHP warnings for internal queries
• PostgreSQL: Display auto_increment of inserted rows
• PostgreSQL: Display description of system variables
• PostgreSQL: Avoid warning about crdb_version (bug #924, regression from 5.0.5)
• PostgreSQL 11: Support PROCEDURE
• SQLite PDO: Display results in SQL query
• MS SQL: Fix collation issues when retrieving default values
• MS SQL PDO: Display last insert ID
• CSS: Sticky table headers (bug #918)
• CSS: Allow more custom styles with dark mode (bug #925)
• CSS: Increase maximum width of string edit (bug #930)
• CSS: Increase space after SQL result (bug #937)
• Plugins: Autoload plugins from adminer-plugins/
• Plugins: Configure plugins with adminer-plugins.php
• Plugins: Display loaded plugins in server overview
• New plugin: AI prompt in SQL command generating the queries with Google Gemini
• New plugin: Verify new versions from GitHub
• New plugin: IMAP driver created for fun
• New plugin: Display links to tables referencing current row
• New plugin: Allow switching light and dark mode (bug #926)
• New plugin: Confirm before unloading page with changed form
• Uzbek translation

Internal

• Modernize JavaScript: let and const instead of var, arrow functions, for...of, classList
• Report E_NOTICE and E_STRICT except accessing an undefined array element
• Docs: Notes for developers

Adminer 5.0.6 (released 2025-03-17)

• Align numbers right (bug #912)
• Display comment in title of field
• Remember export setting at SQL command
• Shorten queries saved from SQL command to URL (bug #917)
• SQL textarea: Open help on Ctrl+click
• Security: Disallow writing temporary files to symlinks (bug SF-855)
• MariaDB: Display MariaDB instead of MySQL
• CSS: Dark mode syntax highlighting
• CSS: Dark input fields in dark mode
• Designs named adminer-dark.css use dark basic style
• Plugins: Add method syntaxHighlighting()
• New plugin: Use Codemirror 5 for syntax highlighting and SQL with typeahead

Internal

• Move PhpShrink to a separate repository

Adminer 5.0.5 (released 2025-03-13)

• MySQL: Display converting function for binary, bit or geometry fields
• MySQL: Display default values of binary columns
• MySQL: Allow setting default values of json column
• MariaDB: Don't display NULL as default value (regression from 5.0.0)
• PostgreSQL PDO: Escape bytea values (bug SF-218)
• CockroachDB: Display version
• CockroachDB: Recognize unique_rowid() as auto_increment
• MS SQL: Fix editing rows with datetime column in primary key
• MongoDB: Move to plugin
• CSS: Add dark theme

Internal

• Tests: Run the whole suite also against MariaDB, PostgreSQL, CockroachDB and MS SQL
• Tests: Cover PhpShrink, revive code coverage

Adminer 5.0.4 (released 2025-03-11)

• Compile: Fix shortening in private methods (regression from 5.0.3)

Adminer 5.0.3 (released 2025-03-11)

• Fix gzip export (bug #896, regression from 5.0.0)
• Fix importing multiple SQL files not terminated by semicolon
• Use <datalist> for altering collations
• MySQL: Allow setting default values of text column
• MySQL: Stop treating enum and set as numbers (bug SF-475)
• MySQL, MariaDB: Fix default values with ' (bug #895)
• MariaDB: Fix creating and altering generated columns (bug #897)
• PostgreSQL: Fix "where" and "order" privileges (bug #902, regression from 5.0.2)
• SQLite: Fix creating table in compiled version (bug #901, regression from 5.0.0)
• Elasticsearch: Do not pass null values on insert (PR #892)
• Elasticsearch: Fix displaying sparse rows (PR #893)
• Plugins: Add method dumpFooter()

Adminer 5.0.2 (released 2025-03-10)

• PostgreSQL: Fix setting NULL and original value on enum (bug SF-884)
• CockroachDB: Add support via PostgreSQL driver
• Elasticsearch: Add support for "where" and "order" field privilege

Adminer 5.0.1 (released 2025-03-07)

• Fix bulk operations with tables (regression from 5.0.0)
• Remove duplicate columns from select (bug SF-670)
• MariaDB: Fix link to status variable doc (bug SF-658)
• PostgreSQL: Support indexes on materialized views (PR #467)
• Elasticsearch: Drop support for version < 7

Adminer 5.0.0 (released 2025-03-07)

• Speed up with disabled output buffering
• Allow creating generated columns (bug SF-857)
• Don't autofocus computed fields in insert form
• Skip generated columns in multi-edit (bug SF-882)
• MySQL: Display generated value in table structure
• MySQL: Drop support for MySQL 4
• PostgreSQL: Compute size of all databases (bug SF-881)
• PostgreSQL: Do not alter indexes with expressions
• PostgreSQL: Fix export of indexes with expressions (bug SF-768)
• PostgreSQL: Display ENUM types
• PostgreSQL: Export ENUM types (bug SF-587)
• PostgreSQL: Display ? instead of -1 rows in table overview (bug SF-883)
• PostgreSQL: Show accessible databases to non-owners (regression from 4.9.1)
• PostgreSQL: Skip editing generated columns
• PostgreSQL, MS SQL, Oracle: Hide table actions for information_schema
• SQLite: Support CHECK constraint
• SQLite: Support generated columns
• SQLite: Add command Check tables
• SQLite: Display all rows of variable values
• SQLite: Remove support for SQLite version 2
• MS SQL: Support export (bug SF-480)
• MS SQL: Display foreign keys ON UPDATE and ON DELETE
• MS SQL: Support computed columns
• MS SQL: Fix CSV import (bug SF-859)
• MS SQL: Fix altering foreign key
• MS SQL PDO: Support offset
• MS SQL: Remove support for MSSQL extension
• MS SQL: Add support for PDO_SQLSRV extension
• MS SQL: Link help from sys tables
• MS SQL: Fix highlighting columns as primary keys
• MongoDB: Remove support for deprecated extension mongo
• Elasticsearch: Fix text search on boolean fields
• Plugins: Adminer code is now in a namespace

Internal

• Formalize the coding style
• Remove most global variables

Adminer 4.17.1 (released 2025-02-25)

• MySQL: Fix typo in the date type (regression from 4.17.0)

Adminer 4.17.0 (released 2025-02-24)

• Hide index column options by default
• Offer original values in multi-row editing (regression from 4.16.0)
• Print SQL errors as comments in export (regression from 3.2.0)
• MySQL, PostgreSQL, MS SQL: Support CHECK constraint
• MySQL: Show comments at routine call (bug SF-874)
• MySQL: Don't offer empty enum value in edit
• MySQL 9+: Support vector type
• PostgreSQL: Link user defined types
• PostgreSQL: Constraint enum values in editing (bug SF-270)
• PostgreSQL: Export functions
• PostgreSQL 8+: Fix exporting table constraints
• SQLite: Show all supported pragmas in Variables
• MS SQL: Allow altering table in non-default schema (bug SF-405)
• MS SQL: Fix default values (bug SF-732, bug SF-733)
• MS SQL: Fix length of nvarchar columns
• Editor PDO: Select value of foreign key in edit (bug SF-847)
• Mobile devices: Use device width

Adminer 4.16.0 (released 2025-02-20)

• MySQL: Fix saving bit(64) values (bug SF-839)
• PostgreSQL: Preserve whitespace in EXPLAIN (bug SF-827)
• PostgreSQL: Support SSL
• PostgreSQL: Support altering auto_increment (bug SF-761)
• SQLite: Fix altering foreign keys (bug SF-841)
• SQLite: Fix expressions in default values (bug SF-860)
• MS SQL: Foreign keys in non-default schema (bug SF-833)
• Oracle: Include tables granted by other user
• Elasticsearch: Move to plugin
• MongoDB: Execute commands against the selected DB

Adminer 4.15.0

• Escape unknown field in select
• HTTP drivers: Don't allow path in server name
• HTTP drivers: Hide connection error message
• SimpleDB: Disable XML entity loader
• Latvian translation

Adminer 4.14.0

• Use autofocus HTML attribute
• PostgreSQL: Fix initial value of exported autoincrement
• PostgreSQL: Fix renaming a database

Adminer 4.12.0

• Fix SQL query code direction if RTL language is used
• MariaDB: Add support for UUID data type
• MS SQL, MongoDB: Connect to localhost with default port if server is not specified
• MongoDB: Fix parsing WHERE condition from SQL query

Adminer 4.11.0

• MySQL: Fix highlighting current table in menu on macOS
• MariaDB: Fix several links to documentation pages
• MS SQL: Prefix Unicode strings with 'N' so they are treated correctly

Adminer 4.10.0

• Print username next to the logout button
• Do not display empty action links in main menu

Adminer 4.9.4

• Unify displaying of 'New item' action based on privileges
• Firefox: Fix opening a database to the new browser's tab with Ctrl+click
• Editor: Fix array conversion to string (issue adminerneo#3).
• Editor: Fix building links with array parameters

Adminer 4.9.3

• MySQL, PostgreSQL: Fix queries splitting and string constants
• MySQL: Fix where clause for JSON column
• MySQL: Do not include unchanged PARTITION BY definition into ALTER TABLE query
• MariaDB: Support current_timestamp()
• PostgreSQL: Fix editing record that contains a field with GENERATED ALWAYS default value

Adminer 4.9.2

• PostgreSQL: Fix search fields configuration (regression from 4.9.0)
• PostgreSQL: Fix exporting CREATE TABLE query with GENERATED default values
• PostgreSQL: Fix exporting CREATE TABLE with sequence default value
• PostgreSQL: Fix search condition for network address types, add macaddr8 type

Adminer 4.9.1

• Support PHP 8.3
• PostgreSQL: Show only accessible databases

Adminer 4.9.0

• Validate connection to server in HTTP based drivers
• Elasticsearch 5: Make unusable driver usable again, move it to plugins
• Add new Elasticsearch 7 driver
• MySQL: Skip dump of generated columns

Adminer 4.8.2

• Support multi-line table comments
• MySQL: Use ST_SRID() instead of SRID() for MySQL 8 (PR #418)
• PostgreSQL: Don't reset table comments (regression from 4.2.0)
• PostgreSQL PDO: Allow editing rows identified by boolean column (PR #380)

Adminer 4.8.1 (released 2021-05-14)

• Internet Explorer or PDO in Adminer 4.7.8-4.8.0: Fix XSS in doc_link (bug SF-797)
• Fix more PHP 8 warnings (bug SF-781)
• Avoid PHP warnings with PDO drivers (bug SF-786, regression from 4.7.8)
• MySQL: Allow moving views to other DB and renaming DB with views (bug SF-783)
• MariaDB: Do not treat sequences as views (PR #416)
• PostgreSQL: Support UPDATE OF triggers (bug SF-789)
• PostgreSQL: Support triggers with more events (OR)
• PostgreSQL: Fix parsing of foreign keys with non-ASCII column names
• PostgreSQL < 10 PDO: Avoid displaying GENERATED ALWAYS BY IDENTITY everywhere (bug SF-785, regression from 4.7.9)
• SQLite: Fix displayed types (bug SF-784, regression from 4.8.0)

Adminer 4.8.0 (released 2021-02-10)

• Support function default values in insert (bug SF-713)
• Allow SQL pseudo-function in insert
• Skip date columns for non-date values in search anywhere
• Add DB version to comment in export
• Support PHP 8 in create table (regression from 4.7.9)
• MySQL 8: Fix EXPLAIN in SQL command
• PostgreSQL: Create PRIMARY KEY for auto increment columns
• PostgreSQL: Avoid exporting empty sequence last value (bug SF-768)
• PostgreSQL: Do not show triggers from other schemas (PR #412)
• PostgreSQL: Fix multi-parameter functions in default values (bug SF-736)
• PostgreSQL: Fix displaying NULL bytea fields
• PostgreSQL PDO: Do not select NULL function for false values in edit
• Oracle: Alter indexes
• Oracle: Count tables
• Oracle: Import from CSV
• Oracle: Fix column size with string type
• MongoDB: Handle errors
• SimpleDB, Firebird, ClickHouse: Move to plugin

Adminer 4.7.9 (released 2021-02-07)

• Fix XSS in browsers which don't encode URL parameters (bug SF-775, regression from 4.7.0)
• Elasticsearch, ClickHouse: Do not print response if HTTP code is not 200
• Don't syntax highlight during IME composition (bug SF-747)
• Quote values with leading and trailing zeroes in CSV export (bug SF-777)
• Link URLs in SQL command (PR #411)
• Fix displayed foreign key columns from other DB (bug SF-766)
• Re-enable PHP warnings (regression from 4.7.8)
• MySQL: Do not export names in quotes with sql_mode='ANSI_QUOTES' (bug SF-749)
• MySQL: Avoid error in PHP 8 when connecting to socket (PR #409)
• MySQL: Don't quote default value of text fields (bug SF-779)
• PostgreSQL: Export all FKs after all CREATE TABLE (PR #351)
• PostgreSQL: Fix dollar-quoted syntax highlighting (bug SF-738)
• PostgreSQL: Do not show view definition from other schema (PR #392)
• PostgreSQL: Use bigserial for bigint auto increment (bug SF-765, regression from 3.0.0)
• PostgreSQL PDO: Support PgBouncer, unsupport PostgreSQL < 9.1 (bug SF-771)
• PostgreSQL 10: Support GENERATED ALWAYS BY IDENTITY (PR #386)
• PostgreSQL 10: Support partitioned tables (PR #396)
• PostgreSQL 11: Create PRIMARY KEY for auto increment columns
• SQLite: Set busy_timeout to 500
• MS SQL: Don't truncate comments to 30 chars (PR #376)
• Elasticsearch 6: Fix displaying type mapping (PR #402)
• MongoDB: Fix password-less check in the mongo extension (PR #405)
• Editor: Cast to string when searching (bug SF-325)
• Editor: Avoid trailing dot in export filename

Adminer 4.7.8 (released 2020-12-06)

• Support PHP 8
• Disallow connecting to privileged ports (bug SF-769)

Adminer 4.7.7 (released 2020-05-11)

• Fix open redirect if Adminer is accessible at //adminer.php%2F@

Adminer 4.7.6 (released 2020-01-31)

• Speed up alter table form (regression from 4.4.0)
• Fix clicking on non-input fields in alter table (regression from 4.6.2)
• Display time of procedure execution
• Disallow connecting to ports > 65535 (bug SF-730)
• MySQL: Always set foreign_key_checks in export
• PostgreSQL: Support exporting views
• Editor: Fix focusing foreign key search in select

Adminer 4.7.5 (released 2019-11-13)

• Add id="" to cells with failed inline edit (bug SF-708)
• PostgreSQL: Fix getting default value in PostgreSQL 12 (bug SF-719)
• PostgreSQL, Oracle: Set schema for EXPLAIN queries in SQL command (bug SF-706)
• ClickHouse: SQL command
• Swedish translation

Adminer 4.7.4 (released 2019-10-22)

• Fix XSS if Adminer is accessible at URL /data:

Adminer 4.7.3 (released 2019-08-27)

• Allow editing foreign keys pointing to tables in other database/schema (bug SF-694)
• Fix blocking of concurrent instances in PHP >7.2 (bug SF-703)
• MySQL: Speed up displaying tables in large databases (bug SF-700, regression from 4.7.2)
• MySQL: Allow editing rows identified by negative floats (bug SF-695)
• MySQL: Skip editing generated columns
• SQLite: Quote strings stored in integer columns in export (bug SF-696)
• SQLite: Handle error in altering table (bug SF-697)
• SQLite: Allow setting auto increment for empty tables
• SQLite: Preserve auto increment when recreating table
• MS SQL: Support foreign keys to other DB
• MongoDB: Allow setting authSource from environment variable

Adminer 4.7.2 (released 2019-07-18)

• Do not attempt logging in without password (bug SF-676)
• Stretch footer over the whole table width (bug SF-624)
• Allow overwriting tables when copying them
• Fix displaying SQL command after Save and continue edit
• Cache busting for adminer.css
• MySQL: Fix displaying multi-columns foreign keys (bug SF-675, regression from 4.7.0)
• MySQL: Fix creating users and changing password in MySQL 8 (bug SF-663)
• MySQL: Pass SRID to GeomFromText
• PostgreSQL: Fix setting column comments on new table
• PostgreSQL: Display definitions of materialized views (bug SF-682)
• PostgreSQL: Fix table status in PostgreSQL 12 (bug SF-683)
• MS SQL: Support comments
• Elasticsearch: Fix setting number of rows

Adminer 4.7.1 (released 2019-01-24)

• Display the tables scrollbar (bug SF-647)
• Remember visible columns in Create Table form (bug SF-493)
• Add autocomplete attributes to login form
• PHP <5.4 compatibility even with ClickHouse enabled (regression from 4.7.0)
• SQLite: Hide server field in login form
• Editor: Allow disabling boolean fields in PostgreSQL (bug SF-640)

Adminer 4.7.0 (released 2018-11-24)

• Simplify storing executed SQL queries to bookmarks
• Warn when using password with leading or trailing spaces
• Hide import from server if importServerPath() returns an empty string
• Fix inline editing of empty cells (regression from 4.6.3)
• Allow adding more than two indexes and foreign key columns at a time (regression from 4.4.0)
• Avoid overwriting existing tables when copying tables (bug SF-642)
• Fix function change with set data type
• Increase username maxlength to 80 (bug SF-623)
• Make maxlength in all fields a soft limit
• Make tables horizontally scrollable
• MySQL: Support foreign keys created with ANSI quotes (bug SF-620)
• MySQL: Recognize ON UPDATE current_timestamp() (bug SF-632, bug SF-638)
• MySQL: Descending indexes in MySQL 8 (bug SF-643)
• PostgreSQL: Quote array values in export (bug SF-621)
• PostgreSQL: Export DESC indexes (bug SF-639)
• PostgreSQL: Support GENERATED BY DEFAULT AS IDENTITY in PostgreSQL 10
• MS SQL: Pass database when connecting
• ClickHouse: Connect, databases list, tables list, select, SQL command
• Georgian translation

Adminer 4.6.3 (released 2018-06-28)

• Disallow using password-less databases
• Copy triggers when copying table
• Stop session before connecting
• Simplify running slow queries
• Decrease timeout for running slow queries from 5 seconds to 2 seconds
• Fix displaying info about non-alphabetical objects (bug SF-599)
• Use secure cookies on HTTP if session.cookie_secure is set
• PDO: Support binary fields download
• MySQL: Disallow LOAD DATA LOCAL INFILE
• MySQL: Use CONVERT() only when searching for non-ASCII (bug SF-603)
• MySQL: Order database names in MySQL 8 (bug SF-613)
• PostgreSQL: Fix editing data in views (bug SF-605, regression from 4.6.0)
• PostgreSQL: Do not cast date/time/number/uuid searches to text (bug SF-608)
• PostgreSQL: Export false as 0 in PDO (bug SF-619)
• MS SQL: Support port with sqlsrv
• Editor: Do not check boolean checkboxes with false in PostgreSQL (bug SF-607)

Adminer 4.6.2 (released 2018-02-20)

• Semi-transparent border on table actions
• Shorten JSON values in select (bug SF-594)
• Speed up alter table form (regression from 4.4.0)
• Store current version without authentication and in Editor
• PostgreSQL: Fix exporting string default values
• PostgreSQL: Fix exporting sequences in PostgreSQL 10
• PostgreSQL: Add IF EXISTS to DROP SEQUENCE in export (bug SF-595)
• Editor: Fix displaying of true boolean values (regression from 4.5.0)

Adminer 4.6.1 (released 2018-02-09)

• Sticky position of table actions
• Speed up rendering of long tables (regression from 4.4.0)
• Display notification about performing action after relogin
• Add system tables help links
• MySQL: Support non-utf8 charset in search in column
• MySQL: Support geometry in MySQL 8 (bug SF-574)
• MariaDB: Links to documentation
• SQLite: Allow deleting PRIMARY KEY from tables with auto increment
• PostgreSQL: Support binary files in bytea fields
• PostgreSQL: Don't treat interval type as number (bug SF-474)
• PostgreSQL: Cast to string when searching using LIKE (bug SF-325)
• PostgreSQL: Fix condition for selecting no rows
• PostgreSQL: Support TRUNCATE+INSERT export
• Customization: Support connecting to MySQL via SSL
• Customization: Allow specifying server name displayed in breadcrumbs

Adminer 4.6.0 (released 2018-02-05)

• Fix counting selected rows after going back to select page
• PHP <5.3 compatibility even with Elasticsearch enabled
• Fully support functions in default values
• Stop redirecting links via adminer.org
• Support X-Forwarded-Prefix
• Display options for timestamp columns when creating a new table
• Disable autocompleting password on create user page
• Use primary key to edit rows even if not selected
• MySQL, PostgreSQL: Display warnings
• MySQL: Add floor and ceil select functions
• MySQL: Add FIND_IN_SET search operator
• MariaDB: Support JSON since MariaDB 10.2
• SQLite, PostgreSQL: Limit rows in data manipulation without unique key
• PostgreSQL: Support routines
• PostgreSQL: Allow editing views with uppercase letters (bug SF-467)
• PostgreSQL: Allow now() as default value (bug SF-525)
• SimpleDB: Document that allow_url_fopen is required
• Malay translation

Adminer 4.5.0 (released 2018-01-24)

• Display name of the object in confirmation when dropping it
• Display newlines in column comments (bug SF-573)
• Support current_timestamp() as default of time fields (bug SF-572)
• Hide window.opener from pages opened in a new window (bug SF-561)
• Display error when getting row to edit
• Store current Adminer version server-side to avoid excessive requests
• Adminer: Fix Search data in tables (regression from 4.4.0)
• CSP: Allow any styles, images, media and fonts, disallow base-uri
• MySQL: Support geometry in MySQL 8 (bug SF-574)
• MySQL: Support routines with comments in parameters (bug SF-460)
• MariaDB: Support fulltext and spatial indexes in InnoDB (bug SF-583)
• SQLite: Enable foreign key checks
• PostgreSQL: Respect NULL default value
• PostgreSQL: Display foreign tables (bug SF-576)
• PostgreSQL: Do not export triggers if not requested
• PostgreSQL: Export DROP SEQUENCE if dropping table
• PostgreSQL: Display boolean values as code (bug SF-562)
• MS SQL: Support freetds
• non-MySQL: Avoid CONVERT() (bug SF-509)
• Elasticsearch: Insert, update, delete
• MongoDB: Support mongodb PHP extension
• Editor: Fix displaying of false values in PostgreSQL (bug SF-568)

Adminer 4.4.0 (released 2018-01-17)

• Add Content Security Policy
• Disallow scripts without nonce
• Rate limit password-less login attempts from the same IP address
• Disallow connecting to privileged ports
• Add nosniff header
• PHP 7.1: Prevent warning when using empty limit
• PHP 7.2: Prevent warning when searching in select
• MySQL: Remove dedicated view for replication status (added in 4.3.0)
• PostgreSQL: Sort table names (regression from 4.3.1)
• Editor: Don't set time zone from PHP, fixes DST
• Editor: Display field comment's text inside [] only in edit form
• Editor: Fix doubleclick on database page
• Editor: Fix Search data in tables
• Customization: Always send security headers
• Hebrew translation

Adminer 4.3.1 (released 2017-04-14)

• Fix permanent login after logout (bug SF-539)
• Fix SQL command autofocus (regression from 4.0.0)
• PostgreSQL: Support JSON and JSONB data types
• PostgreSQL: Fix index size computation in PostgreSQL < 9.0 (regression from 4.3.0)
• PostgreSQL: Fix nullable fields in export

Adminer 4.3.0 (released 2017-03-15)

• Make maxlength in edit fields a soft limit
• Add accessibility labels
• Add Cache-Control: immutable to static files
• MySQL: Support MySQL 8
• MySQL: Support JSON data type
• MySQL: Add dedicated view for replication status
• MySQL: Support spatial indexes
• PostgreSQL: Export
• PostgreSQL: Don't treat partial indexes as unique
• MS SQL: Support pdo_dblib
• Elasticsearch: Support HTTPS by inputting https://server

Adminer 4.2.5 (released 2016-06-01)

• Fix remote execution in SQLite query
• SQLite: Require credentials to use
• PostgreSQL: Support KILL

Adminer 4.2.4 (released 2016-02-06)

• Fix remote execution in SQLite query
• MySQL: Support PHP 7
• Bosnian translation
• Finnish translation

Adminer 4.2.3 (released 2015-11-15)

• Fix XSS in indexes (non-MySQL only)
• Support PHP 7
• Greek translation
• Galician translation
• Bulgarian translation

Adminer 4.2.2 (released 2015-08-05)

• Fix XSS in alter table (found by HP Fortify)

Adminer 4.2.1 (released 2015-03-10)

• Send referrer header to the same domain
• MySQL: Fix usage of utf8mb4 if the client library doesn't support it
• MySQL: Use utf8mb4 in export only if required
• SQLite: Use EXPLAIN QUERY PLAN in SQL query

Adminer 4.2.0 (released 2015-02-07)

• Fix XSS in login form (bug SF-436)
• Allow limiting number of displayed rows in SQL command
• Fix reading routine column collations
• Unlock session in alter database
• Make master key unreadable to others (bug SF-410)
• Fix edit by long non-utf8 string
• Specify encoding for PHP 5.6 with invalid default_charset
• Fix saving NULL value, bug since Adminer 4.0.3
• Send 403 for auth error
• Report offline and other AJAX errors (bug SF-419)
• Don't alter table comment if not changed
• Add links to documentation on table status page
• Fix handling of 64 bit numbers in auto_increment
• Add referrer: never meta tag
• MySQL: Use utf8mb4 if available
• MySQL: Support foreign keys in NDB storage
• PostgreSQL: Materialized views
• SQLite: Support CURRENT_* default values (bug SF-417)
• Elasticsearch: Use where in select
• Firebird: Alpha version
• Danish translation

Adminer 4.1.0 (released 2014-04-18)

• Provide size of all databases in the overview
• Prevent against brute force login attempts from the same IP address
• Compute number of tables in the overview explicitly
• Display edit form after error in clone or multi-edit
• Trim trailing non-breaking spaces in SQL textarea
• Display time of the select command
• Print elapsed time in HTML instead of SQL command comment
• Improve gzip export ratio (bug SF-387)
• Use rel="noreferrer" for external links, skip adminer.org redirect in WebKit
• MySQL: Fix enum types in routines (bug SF-391)
• MySQL: Fix editing rows by binary values, bug since Adminer 3.7.1
• MySQL: Respect daylight saving time in dump, bug since Adminer 3.6.4
• MySQL 5.6.5+: Support ON UPDATE on datatime column
• SQLite: Support UPDATE OF triggers
• SQLite: Display auto-created unique indexes, bug since Adminer 3.5.0
• Editor: Fix login() method, bug since Adminer 4.0.0
• Translate numbers in ar, bn, fa
• Vietnamese translation

Adminer 4.0.3 (released 2014-02-01)

• MongoDB: insert, truncate, indexes
• SimpleDB, MongoDB: insert more fields at once
• SQLite: Fix creating table and altering primary key, bug since Adminer 4.0.0
• Don't store invalid credentials to session, bug since Adminer 4.0.0
• Norwegian translation

Adminer 4.0.2 (released 2014-01-11)

• Fix handling of long text in SQL textarea
• Support paste to SQL textarea in Opera

Adminer 4.0.1 (released 2014-01-11)

• Don't use type=number if a SQL function is used
• Disable highlighting in textareas with long texts
• Don't autofocus SQL textarea in Firefox
• Don't link NULL foreign key values
• Fix displaying images in Editor, bug since Adminer 3.6.0
• Fix uploading files, bug since Adminer 4.0.0
• MongoDB: Count tables, display ObjectIds, sort, limit, offset, count rows
• Elasticsearch: Fix compiled version, create and drop DB, drop table

Adminer 4.0.0 (released 2014-01-08)

• Driver for SimpleDB, MongoDB and Elasticsearch
• Highlight SQL in textareas
• Save and continue edit by AJAX
• Split SQL command and import
• Add a new column in alter table on key press
• Mark length as required for strings
• Add label to database selection, move logout button
• Add button for dropping an index
• Display number of selected rows
• Add links to documentation
• Disable underlining links
• Differentiate views in navigation
• Improve speed of CSV import
• Keep form values after refresh in Firefox
• Mark auto_increment fields in edit
• Don't append newlines to uploaded files, bug since Adminer 3.7.0
• Don't display SQL edit form on Ctrl+click on the select query, introduced in Adminer 3.6.4
• Use MD5 for editing long keys only in supported drivers, bug since Adminer 3.6.4
• Don't reset column when searching for an empty value with Enter, bug since Adminer 3.6.4
• Encrypt passwords stored in session by a key stored in cookie
• Don't execute external JavaScript when verifying version
• Include JUSH in the compiled version
• Protect CSRF token against BREACH
• Non-MySQL: View triggers
• SQLite: Allow editing primary key
• SQLite: Allow editing foreign keys
• PostgreSQL: Fix handling of nextval() default values
• PostgreSQL: Support creating array columns
• Customization: Provide schemas()
• Portugal Portuguese translation
• Thai translation

Adminer 3.7.1 (released 2013-06-29)

• Increase click target for checkboxes
• Use shadow for highlighting default button
• Don't use LIMIT 1 if inline updating unique row
• Don't check previous checkbox on added column in create table (bug SF-326)
• Order table list by name
• Verify UTF-8 encoding of CSV import
• Notify user about expired master password for permanent login
• Highlight table being altered in navigation
• Send 404 for invalid database and schema
• Fix title and links on invalid table pages
• Display error on invalid alter table and view pages
• MySQL: Speed up updating rows without numeric or UTF-8 primary key
• Non-MySQL: Descending indexes
• PostgreSQL: Fix detecting oid column in PDO
• PostgreSQL: Handle timestamp types (bug SF-324)
• Korean translation

Adminer 3.7.0 (released 2013-05-19)

• Allow more SQL files to be uploaded at the same time
• Print run time next to executed queries
• Don't drop original view and routine before creating the new one
• Highlight default submit button
• Add server placeholder to login form
• Disable SQL export when applying functions in select
• Allow using lang() in plugins (customization)
• Remove bzip2 compression support
• Constraint memory used in TAR export
• Allow exporting views dependent on each other (bug SF-214)
• Fix resetting search (bug SF-318)
• Don't use LIMIT 1 if updating unique row (bug SF-320)
• Restrict editing rows without unique identifier to search results
• Display navigation below main content on mobile browsers
• Get number of rows on export page asynchronously
• Respect 'whole result' even if some rows are checked (bug SF-339 since Adminer 3.7.0)
• MySQL: Optimize create table page and Editor navigation
• MySQL: Display bit type as binary number
• MySQL: Improve export of binary data types
• MySQL: Fix handling of POINT data type (bug SF-282)
• MySQL: Don't export binary and geometry columns twice in select
• MySQL: Fix EXPLAIN in MySQL < 5.1, bug since Adminer 3.6.4
• SQLite: Export views
• PostgreSQL: Fix swapped NULL and NOT NULL columns in PDO

Adminer 3.6.4 (released 2013-04-26)

• Display pagination on a fixed position
• Increase default select limit to 50
• Display SQL edit form on Ctrl+click on the select query
• Display SQL history from newest
• Recover original view, trigger, routine if creating fails
• Do not store plain text password to history in creating user
• Selectable ON UPDATE CURRENT_TIMESTAMP field in create table
• Open database to a new window after selecting it with Ctrl
• Clear column name after resetting search (bug SF-296)
• Explain partitions in SQL query (bug SF-294)
• Allow loading more data with inline edit (bug SF-299)
• Stay on the same page after deleting rows (bug SF-301)
• Respect checked tables in export filename (bug SF-133)
• Respect PHP configuration max_input_vars
• Fix unsetting permanent login after logout
• Disable autocapitalize in identifiers on mobile browsers
• MySQL: Compatibility with MySQL 5.6
• MySQL: Move ALTER export to plugin
• MySQL: Use numeric time zone in export
• MySQL: Link processlist documentation
• SQLite: Export indexes

Adminer 3.6.3 (released 2013-01-23)

• Display error code in SQL query
• Allow specifying external links
• Treat Meta key same as Ctrl
• Fix XSS in displaying non-UTF-8 strings
• Don't use type="number" for decimal numbers

Adminer 3.6.2 (released 2012-12-21)

• Edit values by Ctrl+click instead of double click
• Don't select row on double click
• Support NULL in routine calls
• Shorten printed values in varchar fields
• Display table default values on wide screens
• Display date in SQL history
• HTML5 input fields
• Display warning for missing UPDATE privilege
• Fix switching language on first load
• Support enabled mbstring.func_overload
• MySQL: Prolong comment length since MySQL 5.5
• PostgreSQL: Fix process list in version 9.2
• MS SQL: Support databases starting with number

Adminer 3.6.1 (released 2012-09-17)

• Fix compiled version on PHP with multibyte support

Adminer 3.6.0 (released 2012-09-16)

• Load more data in select
• Edit strings with \n in textarea
• Time out long running database list and select count
• Use VALUES() in INSERT+UPDATE export
• Style logout button as link
• Store selected database to permanent login
• Ctrl+click and Shift+click on button opens form to a blank window
• Switch language by POST
• MySQL: Support geometry data types
• selectQueryBuild() method (customization)
• Serbian translation

Internal

• Compress translations

Adminer 3.5.1 (released 2012-08-10)

• Support same name fields in CSV export
• Support Shift+click in export

Adminer 3.5.0 (released 2012-08-05)

• Links for column search in select
• Autohide column context menu in select
• Autodisplay long table names in tables list
• Display assigned auto_increment after clone
• SQLite: Full alter table
• SQLite: Better editing in tables without primary key
• SQLite: Display number of rows in database overview

Adminer 3.4.0 (released 2012-06-30)

• Link to descending order
• Shift+click on checkbox to select consecutive rows
• Print current time next to executed SQL queries
• Warn about selecting data without index
• Allow specifying database in login form
• Link to original table in EXPLAIN of SELECT * FROM table t
• Format numbers in translations
• MySQL: inform about disabled event_scheduler
• SQLite: support binary data
• PostgreSQL: approximate row count in table overview
• PostgreSQL: improve PDO support in SQL command
• Oracle: schema, processlist, table overview numbers
• Simplify work with NULL values (customization)
• Use namespace in login form (customization)
• Customizable export filename (customization)
• Don't use AJAX links and forms
• Indonesian translation
• Ukrainian translation
• Bengali translation

Internal

• Replace JSMin by better JavaScript minifier

Adminer 3.3.4 (released 2012-03-07)

• Foreign keys default actions (bug SF-188)
• SET DEFAULT foreign key action
• Fix minor parser bug in SQL command with webserver file
• Ctrl+click on button opens form to a blank window
• Trim table and column names (bug SF-195)
• Error message with no response from server in AJAX
• Esc to cancel AJAX request
• Move AJAX loading indicator to the right
• Don't quote bit type in export
• Don't check row while selecting text
• Fix invalid references line position on Database schema
• Disable selecting text on Database schema
• Ability to disable export (customization)
• Extensible list of databases (customization)
• MySQL: set autocommit after connect
• SQLite, PostgreSQL: vacuum
• SQLite, PostgreSQL: don't use LIKE for numbers (bug SF-202)
• PostgreSQL: fix alter foreign key
• PostgreSQL over PDO: connect if the eponymous database does not exist (bug SF-185)
• Boolean search (Editor)
• Persian translation

Adminer 3.3.3 (released 2011-08-12)

• Highlight checked rows
• Titles of links in database overview and navigation
• Fix trigger export (SQLite)
• Default trigger statement (SQLite, PostgreSQL)
• Remove search by expression (PostgreSQL, MS SQL)

Adminer 3.3.2 (released 2011-08-08)

• Display error with non-existent row in edit
• Fix minor parser bug in SQL command with webserver file
• Fix SQL command Stop on error
• Don't scroll with AJAX select order and alter move column
• Fast number of rows with big tables (PostgreSQL)
• Sort databases and schemas (PostgreSQL)

Adminer 3.3.1 (released 2011-07-27)

• Fix XSS introduced in Adminer 3.2.0
• Fix altering default values (PostgreSQL)
• Process list (PostgreSQL)

Adminer 3.3.0 (released 2011-07-19)

• Use Esc to disable in-place edit
• Shortcut for database privileges
• Editable index names
• Append new index with auto index selection (bug SF-138)
• Preserve original timestamp value in multiple update (bug SF-158)
• Bit type default value
• Display foreign key name in tooltip
• Display default column value in table overview
• Display column collation in tooltip
• Keyboard shortcuts: Alt+Shift+1 for homepage, Ctrl+Shift+Enter for Save and continue edit
• Show only errors with Webserver file SQL command
• Remember select export and import options
• Link tables and indexes from SQL command EXPLAIN (MySQL)
• Display error with all wrong SQL commands (MySQL)
• Display foreign keys from other schemas (PostgreSQL)
• Pagination support (Oracle)
• Autocomplete for big foreign keys (Editor)
• Display name of the referenced record in PostgreSQL (Editor)
• Prefer NULL to empty string (Editor, bug SF-162)
• Display searched columns (Editor)
• Customizable favicon (customization)
• Method name can return a link (customization)
• Easier sending of default headers (customization)
• Lithuanian and Romanian translation

Adminer 3.2.2 (released 2011-03-28)

• Fix AJAX history after reload

Adminer 3.2.1 (released 2011-03-23)

• Ability to save expression in edit
• Respect default database collation (bug SF-119)
• Don't export triggers without table (bug SF-123)
• Esc to focus next field in Tab textarea
• Send forms by Ctrl+Enter on <select>
• Enum editor and textarea Ctrl+Enter working in IE
• AJAX forms in Google Chrome
• Parse UTF-16 and UTF-8 BOM in all text uploads
• Display ; in history
• Use DELIMITER in history
• Show databases even with skip_show_database in MySQL 5
• Disable maxlength with functions in edit
• Better placement of AJAX icon
• Table header in CSV export (Editor)
• Time format hint (Editor)
• Respect order after search (Editor)
• Set MySQL time zone by PHP setting (Editor)
• Allow own code in <head> (customization)
• Polish translation

Internal

• Rework AJAX, the only visible change is the placement of the loading icon

Adminer 3.2.0 (released 2011-02-24)

• Get long texts and slow information by AJAX
• Most links and forms by AJAX in browsers with support for history.pushState
• Copy tables
• Ability to search by expression in select
• Export SQL command result (bug SF-99)
• Focus first field with insert (bug SF-106)
• Permanent link in schema
• Display total time in show only errors mode in SQL command
• History: edit all
• MS SQL: auto primary and foreign key
• SQLite: display 0
• Create table default data type: int
• Focus upper/lower fields by Ctrl+Up/Ctrl+Down
• Hide credentials for SQLite
• Utilize oids in PostgreSQL
• Homepage customization
• Use IN for search in numeric fields (Editor)
• Use password input for _md5 and _sha1 fields (Editor)
• Work without session.use_cookies (bug SF-107)
• Fix saving schema to cookie in Opera
• Portuguese, Slovenian and Turkish translation

Adminer 3.1.0 (released 2010-11-16)

• TSV export and import
• Customizable export
• Option to show only errors in SQL command
• Link to bookmark SQL command
• Recognize $$ strings in SQL command (PostgreSQL)
• Highlight and edit SQL command in processlist
• Always display all drivers
• Timestamp at the end of export
• Link to refresh database cache (bug SF-96)
• Support for virtual foreign keys
• Disable XSS "protection" of IE8
• Immunity against zend.ze1_compatibility_mode (bug SF-86)
• Fix last page with empty result set
• Arabic translation and RTL support
• Dual licensing: Apache or GPL

Adminer 3.0.1 (released 2010-10-18)

• Send the form by Ctrl+Enter in all textareas
• Disable creating SQLite databases with extension other than db, sdb, sqlite
• Ability to use Adminer in a frame through customization
• Catalan translation
• MS SQL 2005 compatibility
• PostgreSQL: connect if the eponymous database does not exist

Adminer 3.0.0 (released 2010-10-15)

• Drivers for MS SQL, SQLite, PostgreSQL, Oracle
• Allow concurrent logins on the same server
• Allow permanent login without customization
• In-place editation in select
• Foreign key options in Table creation
• Treat binary type as hex
• Show number of tables in server overview
• Operator LIKE %%
• Remember export parameters in cookie
• Allow semicolon as CSV separator
• Schemas, sequences and types support (PostgreSQL)
• Autofocus username in login form
• Allow to insert Tab in SQL textareas and send the form by Ctrl+Enter
• Disable spellchecking in SQL textareas
• Display auto_increment value of inserted item
• Allow disabling auto_increment value export
• Prefill auto_increment column name
• Ability to jump to any page in select by JavaScript
• Display comment in table overview
• Link last page above data in select
• Link table names in SQL queries
• Hungarian, Japanese and Tamil translation
• Defer table information in database overview to JavaScript (performance)
• Big tables optimizations (performance)

Internal

• Compile: Remove functions not supported by the driver
• Move the source code from SVN to Git

Adminer 2.3.2 (released 2010-04-21)

• Fix COUNT(*) link
• Fix Save and continue edit

Adminer 2.3.1 (released 2010-04-06)

• Add Drop button to Alter pages (regression from 2.0.0)
• Link COUNT(*) result to listing
• Newlines in select query edit
• Return to referrer after edit
• Respect session.auto_start (bug SF-42)

Adminer 2.3.0 (released 2010-02-26)

• Support for permanent login (customization required)
• Search in all tables
• Show status variables
• Print sums in tables overview
• Add Delete button to Edit page (regression from 2.0.0)
• Print error summary in SQL command
• Simplify SQL syntax error message
• Show SQL query info if available
• Delete length when changing type in alter table
• Ability to check table prefix in export

Adminer 2.2.1 (released 2009-11-26)

• Highlight current links
• Improve concurrency
• Move number of tables to DB info (performance)
• Search by foreign keys (Editor)
• Link new item in backward keys (Editor)

Adminer 2.2.0 (released 2009-10-20)

• Database list - bulk drop, number of tables
• Enlarge field for enum and set definition
• Display table links above table structure
• Link URLs in select
• Display number of manipulated rows in JS confirm
• Set required memory in SQL command
• Fix removed default in ALTER
• Display whitespace in texts (bug SF-11)
• ClickJacking protection in modern browsers
• E-mail attachments (Editor)
• Optional year in date (Editor)
• Search operators (Editor)
• Align numbers to right in select (Editor)
• Move <h1> to $adminer->navigation (customization)
• Rename get_dbh to connection (customization)

Internal

• Print checkboxes and selects by functions, which reduced the size

Adminer 2.1.0 (released 2009-09-12)

• Edit default values directly in table creation
• Execute SQL file stored on server disk
• Display EXPLAIN in SQL query
• Compress export and import
• Display column comments in table overview
• Use ON DUPLICATE KEY UPDATE for CSV import
• Print ALTER export instead of executing it
• Click on row selects it
• Fix Editor date format
• Fix long SQL query crash (bug SF-3)
• Speed up simple alter table
• Traditional Chinese translation

Adminer 2.0.0 (released 2009-08-06)

• Editor: User friendly data editor
• Customization: Adminer class
• Create single column foreign key in table structure
• Table relations (Editor)
• Send e-mails (Editor)
• Display images in blob (Editor)
• Localize date (Editor)
• Treat tinyint(1) as bool (Editor)
• Divide types to groups in table creation
• Link e-mails in select
• Show type in field name title
• Preselect now() for timestamp columns
• Clear history
• Prefill insert by foreign key searches
• Print number of rows in SQL command
• Remove Delete button from Edit page - use mass operation for it
• Faster multiple update, clone and delete
• Faster table list in navigation
• Download version checker and syntax highlighting from HTTPS
• Fix grant ALL PRIVILEGES with GRANT OPTION
• Fix CSV import
• Fix work with default values

Internal

• Use HTML Strict instead of XHTML
• Remove function minification in favor of performance and customization

Adminer 1.11.1 (released 2009-07-03)

• Fix problem with enabled Filter extension

Adminer 1.11.0 (released 2009-07-02)

• Connection through socket by server :/path/to/socket
• Simplify export
• Display execution time in SQL query
• Relative date and time functions
• Version checker
• Save queries to history and display it on SQL page
• Display MySQL variables
• Ability to select all rows on current page of select
• Always use the default style before the external one
• Always try to use the syntax highlighter
• All privileges in user rights
• Fix FOUND_ROWS() in SQL command
• Export only selected columns in select
• Bulk database creation
• Include views in drop and move on database overview
• Hide fieldsets in select
• Automatically add new fields in table creation
• Use \n in SQL commands

Internal

• Separate JavaScript functions, which allowed compressing and caching them
• Move the source to adminer/, editor/ and tests/, take JSMin and JUSH from externals/
• Add comments to the code
• Prefix the cookies so that they do not collide with other applications on the same domain

phpMinAdmin 1.10.1 (released 2009-05-07)

• Highlight odd and hover rows
• Partition editing comfort (bug SF-12)
• Allow full length in limited int

phpMinAdmin 1.10.0 (released 2009-04-28)

• Partitioning (MySQL 5.1)
• CSV import
• Plus and minus functions
• Option to stop on error in SQL command
• Cross links to select and table (bug SF-5), link new item
• Suhosin compatibility
• Remove max_allowed_packet from export
• Read style from phpMinAdmin.css if exists
• Russian translation

Internal

• Size reduction by minification of variables and functions

phpMinAdmin 1.9.1 (released 2008-10-27)

• Update translations

phpMinAdmin 1.9.0 (released 2008-10-16)

• List of tables and views with maintenance commands
• Clone rows
• Bulk edit and clone
• Function results in edit
• NOT operators in select
• Search without column restriction
• Use type=password for unhashed password
• Only one button for each action in select
• Choose language through option-list
• Don't set global variable in export
• SHOW DATABASES can be revoked
• Order by function result working also in older MySQL versions
• Tested on IIS

Internal

• XHTML syntax errors

phpMinAdmin 1.8.0 (released 2008-09-12)

• Events (MySQL 5.1)
• Access without login - accept ?username=
• Print SQL query in select, messages and warnings
• Display number of found rows
• Don't wrap lines in select table
• Italian and Estonian translation
• Order by COUNT(*)

phpMinAdmin 1.7.0 (released 2008-08-26)

• Customizable export (select objects to export, SQL or CSV)
• Ability to alter existing tables and drop old tables in export
• Choose columns in select, aggregation
• Order rows by clicking on table heading
• Truncate only search results
• Automatically select name for trigger
• Chinese and French translation
• Preserve default values when altering table
• Maintain auto_increment when moving columns
• Cache static files
• Faster checking of number of results

Internal

• Smaller multilingual file

phpMinAdmin 1.6.1 (released 2008-05-22)

• Set session parameters only if not session.auto_start

phpMinAdmin 1.6.0 (released 2008-05-16)

• Order of columns in table
• Set max_allowed_packet in dump and use extended insert
• Spanish and German translations
• Use images for editing buttons
• Protection against big POST data
• Logout by POST
• Information about logged user
• Last-Modified header for files
• Several bug fixes

Internal

• Separate stylesheet

phpMinAdmin 1.5.0 (released 2008-01-09)

• Mass delete
• Vertical privileges
• Specify connection port by colon in server
• Ignore length in date and time types
• Boolean fulltext search for all columns in MyISAM
• Remove maxlength from server and username
• Uncheck NULL by change
• Mark shortened fields in select

Internal

• Shrink compiled output

phpMinAdmin 1.4.0 (released 2007-08-15)

• Privileges
• New design
• Dutch translation
• Use NULL for auto_increment (bug SF-1)
• Fix dropping procedure parameters

phpMinAdmin 1.3.2 (released 2007-08-06)

• Next field by JavaScript in foreign keys
• Set time zone in dump
• Refresh lang cookie
• Remember drop result in case of faulty create
• Move vertical lines in schema properly
• Fix maximum page in select

phpMinAdmin 1.3.1 (released 2007-07-31)

• Move references lines in schema
• Fix dump
• Fix update links

phpMinAdmin 1.3.0 (released 2007-07-27)

• Breadcrumb navigation
• Operator IN
• Timestamp default values
• Draggable tables in schema
• Number of rows in navigation
• Display MySQL version and used PHP extension
• More friendly user interface
• Slovak translation

Internal

• Compile: Inline the favicon by base64, the data: URI was not supported by Internet Explorer

phpMinAdmin 1.2.0 (released 2007-07-25)

• Manipulate triggers
• Auto_increment value
• JavaScript for adding rows

Internal

• PDO Abstraction

phpMinAdmin 1.1.0 (released 2007-07-19)

• Routines manipulation
• Views manipulation
• Foreign keys manipulation
• Database schema with references
• Processlist
• Index length
• Dump individual tables
• JavaScript for next rows in table edit
• Cache databases list

phpMinAdmin 1.0.0 (released 2007-07-11)

• First official release

SF- means https://sourceforge.net/p/adminer/bugs-and-features/