github vrana/adminer v6.1.1

8 hours ago
  • Fix editing identity (PostgreSQL, Oracle, Firebird), rowversion (MS SQL), key (ClickHouse)
  • Select: Fix modifying rows with a NULL value (uncompiled only, regression from 6.1.0)
  • Edit: Do not round big numbers in json (MySQL) and jsonb (PostgreSQL) when saving the row (regression from 5.4.2)
  • DB overview: Keep the table names on the screen when scrolling the list of tables horizontally
  • Select: Keep the checkboxes on the screen when scrolling horizontally
  • Select: Enable saving the modified values again after an error (regression from 6.0.0)
  • Select: Highlight the searched text
  • Select: Search anywhere by IS NULL and IS NOT NULL without a value
  • Show documentation links as 📖, link it from the heading
  • Menu: Group system databases and schemas
  • Trigger: Name a new trigger with more events by all of them
  • PDO: Preserve the exact value of double (bug #1214)
  • PostgreSQL, MS SQL, Oracle: Do not highlight a valid date or time value as too long
  • PostgreSQL: Alter the trigger function from table structure
  • PostgreSQL: Do not highlight an array value as too long
  • PostgreSQL: Fix renaming a column and making it a foreign key at the same time
  • PostgreSQL: Export and alter the default values of enum and array columns (bug #1342)
  • PostgreSQL: Edit the enum values containing an apostrophe
  • PostgreSQL: Alter table: Offer and quote the user types with uppercase letters
  • SQLite: Disallow ATTACH and VACUUM INTO prefixed by BOM (GHSA-r9r5-j5q8-8c59)
  • SQLite: Deny writing files by an authorizer (PHP 8.0+, PDO PHP 8.5+)
  • MS SQL: Export and alter the precision of datetime2, time and datetimeoffset
  • MS SQL: Keep fractional seconds and the time zone offset when saving a row with the sqlsrv extension
  • MS SQL Dblib: Display uniqueidentifier (bug #1339)
  • MS SQL Dblib: Show the server version
  • MS SQL Dblib: Fix creating generated columns and indexed views
  • MS SQL Dblib: SQL command: Rollback an unfinished transaction
  • Oracle: Treat SYS and SYSTEM as read-only
  • Oracle: Support identity columns
  • Oracle: Alter timestamp and interval columns, display their type without a duplicate precision
  • ClickHouse: Offer the geometry types, Time and Time64, group the types as in the other drivers
  • ClickHouse: Display the number of rows to a read-only user
  • ClickHouse: Shorten the links to rows with a long string or geometry by its MD5 hash
  • ClickHouse: Do not round big integers and decimals, e.g. UInt64 or Decimal128, display empty maps and maps with numeric keys as objects
  • ClickHouse: Save the decimals in Array, Map and Tuple exactly, save a Map with other than String keys
  • ClickHouse: Do not turn \b into a backspace (regression from 6.0.0)
  • Editor: Describe foreign keys by the first string column, not only varchar
  • Editor: Shorten long descriptions of foreign keys

Plugins

  • Driver plugins: Driver::disconnect() to forget the logged user
  • Driver plugins: Connect to the privileged ports of the driver's own protocol (ClickHouse, Elasticsearch, IMAP)
  • Driver plugins: Driver::hasEstimatedRows() to recount the rows only after an estimate
  • Driver plugins: Driver::md5() to shorten the links to rows with a long value
  • Driver plugins: Driver::isSystem() to group the system databases and schemas
  • Method namePattern() to customize the names of new indexes, foreign keys, checks and triggers
  • Plugin igdb: Log in by the client secret instead of an access token obtained manually
  • New plugin select-foreign: Display the first string column of the referenced row instead of a foreign key value, same as in Adminer Editor
  • New plugin name-patterns: Name new indexes, foreign keys, checks and triggers by your own convention

Don't miss a new adminer release

NewReleases is sending notifications on new releases.