21.0

Mar 8 2021
Changes since 7.3:
  • General improvements:
    • Popup errors during theme change were fixed
    • New connection driver selector was improved (performance)
    • DBeaver was migrated to Eclipse platform 2020-12
    • DBeaver build system was migrated to Tycho 2.0
    • Password field layout was fixed
    • Spanish localization was significantly improved
    • Content assistant was fixed for drop-down selectors
    • Connection configuration import now supports target folders
    • Clear message for Java version mismatch errors was added
    • Now DBeaver can be installed without bundled Java (Windows and Linux)
    • Problem with Eclipse Marketplace extension was fixed
    • Driver editor dialog was redesigned
    • Ubuntu PPA update was resolved
    • Problem with “Tip of the day” popup was fixed
    • New tips of the day were added
    • All application jars are signed with DBeaver code sign certificate
    • Many minor UI bugs were fixed
    • Extensions with Liquibase4 support were added
    • Yugabyte CQL driver support was added
    • AWS Keyspaces driver support was added
    • Navigation through connection properties after opening authentication profiles was fixed
  • Installers:
    • Windows installer packager was reworked
    • MacOS PKG installer was deprecated, DMG installer now includes JDK
    • Linux installers (DEB and RPM) now include JDK
    • All zip archives now include JDK
  • A lot of improvements for MacOS:
    • Problem with lines disappear in SQL Editor was fixed
    • Problem with connection driver properties editor were fixed
    • Problem with data filter history dropdown was fixed
    • Native client selector was fixed (MySQL, MariaDB, PostgreSQL)
    • Opening SQL files from shell was fixed (MacOS)
    • Number of errors with wrong focus tracking fixed on MacOS
    • Data grid renderer was fixed (bug with mess coloring)
  • Linux:
    • Package for ARM arch was added
    • Action icons rendering was fixed on Linux
  • Data editor:
    • Resultsets ordering configuration was added (client/server side or smart mode)
    • Columns pin flag now saved across different data filters
    • Default column values are now shown for new rows
    • LIKE filers now add % masks automatically
    • Tabs close confirmation dialog was fixed
    • Value filter drop-down was fixed (problem with column mismatch was fixed)
    • Boolean values view is now configurable
    • Result tabs drag-n-drop behavior was fixed
    • Export in TXT (plaintext) format was improved (proper formatting added)
    • Documentation for date/time format patterns was added
    • Import from file: file selector wizard page was fixed
    • Drop-down inline editor was fixed (Linux)
    • Epoch time transformer now supports timezones
    • Copy As SQL: now uses correct SQL dialect
  • Data transfer:
    • Data import now supports INSERT OR REPLACE mode (Oracle, MySQL, PostgreSQL, SQLite, Firebird)
    • Column mapping is now saved between different runs (no need to make the same assignments multiple times)
    • Data type mapping was improved (better type matching)
    • Export in TXT format: max column length detection was improved
    • Import from CSV format: column length detection was improved
    • Database to database transfer: tables order now depends on existing foreign keys
    • Manual tables reorder support was added
    • Bug with binary columns + copy to clipboard was fixed
    • Table/column mapping type selector was fixed
    • Multiple tables export ordering was improved
    • Tables manual reorder support was added
    • Import data from XML format was added
    • Values truncation when table is exported to txt was fixed
  • Metadata editor:
    • Boolean values view is now configurable
    • Virtual foreign keys editor was fixed
    • Incorrect column length (zero or negative) was fixed
    • Support of pure unicode identifiers was added
  • Connection editor:
    • Password field is disabled when it is not used
    • Driver selector page was redesigned
    • Driver properties editor was fixed (empty property values save)
  • GIS (spatial) data viewer:
    • MapBox tile configuration was fixed
    • 3D geometry objects now can be displayed on map
    • Geometry transformer for binary format (WKB) was added
  • Schema compare:
    • Vertica schema comparison support was added
    • “Compare/Migrate Schema” UI was fixed
    • Netezza extension added
    • Comparison of two default schemas was fixed
    • Problem with wrong types recognizing during Oracle-Oracle migration was fixed
    • Issues while migration from Oracle to SQL Server were fixed
    • Ability to change type of compared objects was added
    • JSON report type configuration was fixed
    • Commit changes were implemented
    • Schema comparison for non-default databases that contain comparison schemas was fixed
    • Migrated to Liquibase 4
  • Data compare:
    • Now statistics in summary is correct
    • Problem when comparing Oracle and Postgres was fixed
    • Many UX bugs were fixed
    • A wizard to choose tables/constraints was added
  • MockData:
    • Multi entity support was added
    • Settings page emprovements were added
    • Perfomance was improved
    • A new wizard was implemented
  • VQB:
    • The option which will disable creating joins automatically was added
    • FQN for tables was made optional
  • Data viewer: Advanced paste was fixed (multiple row paste)
  • Tasks editor view: collapse/expand behavior was fixed
  • Task scheduler: Support proper date format for one time jobs was added
  • ERD: bug with broken notes layout after refresh was fixed
  • SQL Editor:
    • Tabs management was redesigned and improved (naming, pins, reordering)
    • SQL folding performance was significantly improved
    • SQL formatting was fixed (IN clause)
    • SQL auto-completion was improved for procedures
    • Auto-completion performance was improved
    • Auto-completion disable was fixed
    • Problem with unicode characters in script file names was fixed
    • Problem with parameters binding dialog was fixed (bad performance during parameter value change)
    • SQL generation: extra options were added
    • Server Output and Execution Log panels were redesigned
    • Server Output auto-show was added (configurable)
    • “Open SQL console” action was added to the main toolbar and context menu
    • Support of very long sql scripts was improved
    • Parser hanging was fixed (partially) for queries with a lot of parenthesis
    • SQL script toolbar was redesigned
    • Omit empty results tab for new editor
    • Copy as source code was fixed
    • Query cancel UI was fixed (force cancel confirmation was removed)
  • PostgreSQL:
    • Permission grant queries were fixed
    • New schema + new table + new column create UI was fixed
    • Roles DDL view was added
    • SQL formatting for custom data types was fixed (geometry and others)
    • Backup/restore now support non-standard authentication (e.g. IAM)
    • Redundant data types removed from navigator tree (arrays)
    • Nested multiline comments support was added
    • Database template list now contains all databases
    • Data types cache read was improved
    • Cross-schema type resolution was fixed
    • Database settings navigator was added
    • Column options were added for foreign tables
    • Google Cloud PostgreSQL driver was added
    • Array data types resolution was fixed
  • MySQL:
    • GIS data types support was fixed
    • Table columns mapping was improved in data transfer
    • JSON columns copy was fixed
    • Events editor was added
    • Mysqldump command line parameters now respect client and server versions
    • Correct DDL is used for created objects
  • Oracle:
    • Session manager now supports Oracle 9
    • Dependencies information was added for tables, views and packages
    • dependencies information was enhanced (+dependents)
    • Tables statistics calculation was fixed
  • SQL Server:
    • User data type list was fixed (redundant types were removed)
    • Stored procedures invocation was fixed
    • Composite indexes metadata read was fixed
    • Database delete was improved (close other connections before delete)
    • MERGE queries support was improved (erroneous row count limit was removed)
    • jTDS driver support was fixed (problem with schema list load)
  • MongoDB:
    • Order by working was fixed
    • Ability to UPDATE multiple records was added
    • Highlighting of LIKE and SQL functions was added
    • Now ISODate can accept dates with missing time and numeric UNIX timestamps (milliseconds)
    • Possibility to write functional words in upper and lower case was added
    • LIKE operator enhancements
    • Connection to MongoDB via SSL was fixed
    • Grouping panel was added
    • Now focus is correctly set when trying to create new entry
    • Incorrect connection host name shown in DB Navigator was fixed
    • Connection can be established if Save Password Locally is unchecked
  • Redshift:
    • Geometry/geography types support was added
    • Extra data types (non-PostgreSQL) support was added
    • Strings parser was fixed (escape with backslash)
    • Driver version was updated (“session is read-only” issue was resolved)
    • Bug with data types reading was fixed
  • Clickhouse:
    • ALTER TABLE scripts for new columns was fixed
    • Driver download was fixed
    • Table column comments support was added
    • Driver version was upgraded (SQL parser fix)
  • Firebird:
    • Procedure parameters domain type names were fixed
    • SQL parser was fixed (code blocks)
    • Table/view type recognition was improved (for older FB versions)
    • System objects detection was improved
  • SQLite:
    • Spatial (gis) data viewer was added
    • Metadata refresh was fixed (wrong foreign key name)
    • Column delete script was fixed
  • Redis:
    • Redis 6 authentication support was added
    • Problem with export key from redis to redis or import table from csv was fixed
  • Netezza:
    • Incorrect reading DDL for views and procedures and incorrect reading primary keys list were fixed
    • Drop constraint via UI was fixed
  • MariaDB:
    • Default driver version upgraded to 2.7.1
    • Sequences support was added
  • SAP HANA:
    • Connection settings page redesigned
    • vConnection editor was enhanced (port numbers)
  • Presto/Trino:
    • GIS transformers support was added
    • Trino (ex-PrestoSQL) driver was added
  • Exasol:
    • Grants refresh was fixed
    • SQL editor now supports LUA scripts
  • Greenplum: partitions and child tables read was fixed
  • Informix: stored procedures DDL formatting was fixed
  • BigQuery: driver version was upgraded