• Data viewer:
  • Record mode now supports multiple records view
  • Double-click behavior in filters popup was fixed
  • Spatial viewer now allows to copy point coordinates
  • Source tables resolution was fixed for CTE queries and sub-selects
• Navigator:
  • Quick filter was fixed (show connected only)
  • “Set connection from navigator” action behavior was fixed
• SQL editor:
  • Auto-completion for identifiers with special characters was fixed
  • SQL console now opens for selected schema
  • Table columns are shown in original order for auto-completion
  • Formatting of queries with embedded comments was fixed
  • Local variables coloring was added (Sybase, SQL Server, MySQL)
• Metadata editor:
  • Metadata search now supports search in procedures/views definition
  • Object info refresh was fixed
  • Table triggers loading performance was significantly improved for most databases
• Clickhouse:
  • Table DDL was fixed
  • Nested comments support was added
  • Data edit (update/delete) queries generator was fixed
• DB2 iSeries: schemas with long names loading was fixed
• Hive: constraints definition was fixed
• MySQL:
  • Execution plan explain for CTE queries was fixed
  • Use password escape was fixed
• PrestoDB/Trino: data and metadata editors were improved
• PostgreSQL:
  • Data type fully-qualified name now used instead of scale/precision
  • Custom data types (including geometry) resolution was improved
• SAP HANA: stored procedures results loader was improved (multiple cursors + atomic values)
• Snowflake: $$ parser was improved
• SQL Server:
  • Temporary table support was improved (metadata load, SQL auto-suggest)
  • datetime data type DDL was fixed
  • Active schema selector was fixed
  • BEGIN/END blocks support was added
• Vertica:
  • Flex tables metadata was fixed
  • Function body parser was fixed

• Connection recovery was improved. SSH tunnel infinite reopening cycle was fixed
• Data transfer:
  • Insert/replace method configuration was fixed
  • Cross-database column data type mapping was improved
• Project settings: corrupted folders configuration fix was added
• Legacy status icons were updated
• Application launch time was reduced
• SQL Editor:
  • Problem with results tab collapse was fixed
  • Dummy NullPointerException and StackOverflowError errors were fixed
• Data editor: LOB viewer shows error dialog on data load errors now
• CLI: reuseWorkspace parameter handler was fixed
• SQL Server:
  • Extended properties editor was added
  • New row insert for tables with calculated columns was fixed
• Oracle: synonyms search is now configurable
• PostgreSQL:
  • User password change feature was added
  • Domain arrays support was fixed
  • Role DDL now contains permissions information
  • Sequences DDL was fixed
  • VARBIT data type support was fixed
  • Default database switch was fixed
• MySQL: user rename feature was added
• Exasol: schema refresh was fixed
• Informix:
  • Table statistics feature was added
  • Function parameters read was fixed
• Snowflake: metadata read was fixed for case-sensitive schema names
• BigQuery: driver version was upgraded
• Bundled Java updated to version 11.0.11
• Many minor UI bugs were fixed

• Navigator:
  • Boolean properties editor behavior was redesigned
  • Broken shortcuts (F2, F4, etc) in object editor were fixed
  • Redundant help icons removed from standard dialogs
  • Language change validation and documentation was added
  • Quick filter now supports triggers
• SQL Editor:
  • Auto-completion was fixed for table aliases, joins and asterisks
  • Smart commit now ignores EXPLAIN statements
  • Big updated row count (>2gb) support was added
  • Output log enable/disable button was added
• Data editor:
  • Selected rows highlight was fixed
  • Bug with overlapping timestamp and FK values was fixed
  • Find/replace dialog now respects number formatting
• ERD viewer: property view support was fixed, entity/attributes context menu was fixed
• PostgreSQL:
  • Constraints and indexes support was added
  • Problem with constantly growing search_path was fixed
  • Fully-qualified table names in foreign keys DDL was fixed
  • PGPASS authentication now can be used with empty user name
  • NaN and Infinity numbers formatting was fixed
  • Data transfer: ON DUPLICATE query generation was fixed
  • Database size statistics was added (configurable, off by default)
  • CREATE DOMAIN DDL was fixed
• DB2: BEGIN/END blocks support was added
• Greenplum: DDL for replicated tables was fixed
• Oracle:
  • Procedure body formattign was fixed (for encoded procedures)
  • Procedures/triggers/packages DDL statements processing was fixed
• Redshift: view columns metadata read was fixed, extra data type aliases were added
• Vertica:
  • Table columns read was fixed for older Vertica versions
  • Sequences support was added
• BigQuery driver version was upgraded
• Eclipse plugin: bug with redundant .dbeaver folders was fixed
• System notifications support was added on Linux
• Jar code sign certificate was updated
• Big number of minor bigfixes

• Navigator:
  • Database statistics in simple mode was fixed
  • Legacy search icons were updated
  • Legacy edit toolbar and main toolbar items was removed
  • Columns reorder now supports multiple columns
  • Object lookup function now supports search in comments
  • DBeaver main menus are visible in DBeaver perspective only
• SQL editor:
  • Collapsed results panel expand was fixed
• Data editor:
  • Find/replace dialog was improved
  • Virtual unique key create dialog was redesigned
  • References panel was fixed for custom SQL queries
• SSH:
  • SSH Agent support was fixed
  • SSHJ extension install was fixed
• MySQL:
  • Column editor was fixed (DEFAULT_GENERATED clause removed)
  • Index editor was added
• PostgreSQL:
  • Schema data types read was fixed
  • Sequence editor was implemented
  • Data type rename support was added
• SQL Server:
  • Calculated columns support was added
  • Extended properties were added to table DDL
  • Default precision and scale for numeric data types was fixed
  • View triggers support was added
• Oracle:
  • Functions folder was added (in addition to Procedures)
  • Jobs support was added (read-only)
  • Data type compile action was fixed
  • Synonyms read was fixed for partitioned tables
  • Table triggers loading performance was improved
  • Trigger disable/enable tool was added
  • Procedure/function dependencies were added
  • Comments for views and view columns were added
  • Data type DDL was fixed for predefined types
• Redshift: problem with read-only resultset was fixed
• SAP HANA:
  • Table columns was fixed for table names with special symbols
  • Hex literal formatting was fixed
• Sybase IQ: SQL dialect support was improved
• Snowflake: drop procedure function was fixed
• DB2: stored procedures call generator was improved
• Vertica:
  • Table column create/edit was fixed
  • View constraints read was implemented
  • Unique key creation was fixed
• DuckDB driver configuration was added
• RMI server waas fixed (no more public port listeners)

• Dark theme support was improved (Windows 10 and GTk)
• Data viewer:
  • Copy As: format configuration editor was added
  • Extra configuration for filter dialog (performance)
  • Sort by column as fixed (for small fetch sizes)
  • Case-insensitive filters support was added
  • Plaintext view now support top/bottom dividers
  • Data editor was fixed (when column name conflicts with alias name)
  • Duplicate row(s) command was fixed for multiple selected rows
  • Edit sub-menu was returned to the context menu
  • Columns auto-size configuration was added
  • Dictionary viewer was fixed (for read-only connections)
  • Current/selected row highlighting support was added (configurable)
• Metadata search now supports search in comments
• GIS/Spatial:
  • Map position preserve after tiles change
  • Support of geometries with Z and M coordinates was added
  • Postgis: DDL for 3D geometry columns was fixed
  • Presto + MySQL geometry type support was added
  • BigQuery now supports spatial data viewer
  • Binary geo json support was improved
  • Geometry export was fixed (SRID parameter)
  • Tiles definition editor was fixed (multi-line definitions + formatting)
• SQL editor:
  • Auto-completion for objects names with spaces inside was fixed
  • Database objects hyperlinks rendering was fixed
• SQL Server: MFA (multi-factor authentication) support was added
• PostgreSQL: array data types read was fixed
• Oracle: indexes were added to table DDL
• Vertica: LIMIT clause support was improved
• Athena: extra AWS regions added to connection dialog
• Sybase IQ: server version detection was improved
• SAP ASE: user function loading was fixed
• Informix: cross-database metadata read was fixed
• We migrated to Eclipse 2021-03 platform

• SQL Editor:
  • Configuration of open editor action was added
  • Smart auto-completion of column values was improved
  • Problem with ambiguous column name resolution was fixed
  • Hyperlinks detection was fixed
  • Problems with SQL templates view freeze was fixed
  • SQL formatter of case and conditional operators was improved
  • Syntax highlighting for single and double quotes was fixed
  • SQL folding state is now saved for each script
  • Trim spaces command was added
  • Problem with double save/commit confirmations was fixed
• Database navigator:
  • Quick schema filter was fixed
  • Metadata changes save: single transaction processing was improved
  • Delete object(s) dialog UI was improved
• Data transfer:
  • Export to flat files now supports columns configuration
  • BOM support was added to CSV import
• Data viewer:
  • BLOB viewer now respects content type of cell value
  • Grouping panel: queries with trailing comment now handled properly
  • Custom resultset ordering support was fixed
• PostgreSQL:
  • Serial data types selector was fixed
  • Column default value editor was fixed
  • Numeric arrays rendering was fixed (number formatting removed)
• SAP HANA (thanks to @wernerdaehn):
  • Smart completion was improved
  • Public synonyms read was added
  • Metadata object search was redesigned
• SQL Server:
  • Default delimiter was changed to ; instead of GO
  • Synonyms support was improved
  • Check constraints added to table DDL
  • Unicode string literals generation was fixed
• Informix: SQL error position detector was added
• Snowflake: active catalog/schema selector was fixed
• DB2 LUW: extra embedded routines support added
• Google Spanner driver configuration was updated
• MariaDB: TIME data type support was fixed
• Vertica: column comments read and update support was added
• Redshift: table permissions read in table DDL was fixed
• APM Jenifer driver configuration was added
• Automatic version upgrade: app restart procedure was improved
• Application icons were updated

• Connection management:
  • Automatic ending of idle transactions was added
  • Network profiles configuration page was fixed
  • Filters in the connection selector dialog were fixed
• Data transfer:
  • Possibility to disable foreign keys was added (PostgreSQL, Oracle)
  • Numeric data types mappings were improved
  • “Skip all errors” button added in the error dialog
• Metadata editor:
  • Column delete now checks for dependent objects
  • Constraint/index create command now available in the columns edit tab
  • Problem with deleted object dup was fixed
• SQL editor:
  • Script selector popup panel UIX was improved
  • Hex constants and scientific numbers formatting was fixed
  • Columns alias generation was improved
  • Multi-line comments support was fixed
• Data editor:
  • Column filter UI was improved (value count column)
  • Extra configuration was added to SQL script generator
  • Better support of IE browser in the spatial viewer (GIS)
  • Virtual columns support (rows add/delete) was fixed
  • Cells selection was fixed (MacOS)
• Automatic app version upgrade was implemented
• Notification popup rendering in dark theme was fixed
• Perspective customization UI was fixed
• ERD:
  • Export as image: image cropping problem was fixed
  • Export in SVG format was improved
  • Diagram save now forces UTF encoding
  • Tables coloring was fixed
  • Show/hide system object option is now respected
  • Print command enablement was fixed
• PostgreSQL:
  • PgBouncer support was fixed (problem with prepared statements)
  • Data types read queries were fixed for older (8.4 and earlier) versions
  • Role permissions editor was fixed
  • Infinity timestamp values support was added
  • Auto-generated columns support was added
  • Role name DDL was fixed
• Teradata:
  • Triggers management was added
  • Views metadata read was fixed
• Informix: foreign key DDL was fixed
• Clickhouse:
  • Table data edit support was added
  • Tables and indexed create/drop DDL was fixed
• Sybase IQ support (server version detection) was fixed
• Vertica: view create/edit was fixed
• Firebird:
  • Procedure parameters’ default value read was fixed
  • View metadata read was improved
• Data Virtuality driver was added (thanks to @sebcom-gmbh)
• Preferences localization was updated

We switched to calendar versioning: version 21.0 comes after 7.3.

Main changes since 7.3:

• Big number of improvements in data transfer tool (insert or update, types mapping, ordering, etc)
• Spatial viewer: 3D objects support, custom tiles, SQLite support
• SQL editor panels (log, output, result tabs, toolbars) were significantly redesigned
• MacOS: a lot of UI rendering bugs were fixed, BigSur support added
• A lot of database-specific issues were resolved and new features were added
• All packages now include Java (no need to install it separately)
• New databases: Trino, PostgreSQL for Google Cloud

Changes since 7.3.5:

• MacOS: data grid renderer was fixed (bug with mess coloring)
• Linux: package for ARM arch was added
• Data transfer:
  • Multiple tables export ordering was improved
  • Tables manual reorder support was added
• MySQL:
  • Events editor was added
  • mysqldump command line parameters now respect client and server versions
• Oracle: tables statistics calculation was fixed
• PostgreSQL: array data types resolution was fixed
• Firebird: system objects detection was improved
• BigQuery: driver version was upgraded
• Exasol: SQL editor now supports LUA scripts (thanks to @Sargul)
• Clickhouse: driver version was upgraded (SQL parser fix)
• Redshift: bug with data types reading was fixed
• Problem with “Tip of the day” popup was fixed
• ERD: bug with broken notes layout after refresh was fixed
• Action icons rendering was fixed on Linux
• Many minor UI bugs were fixed

• Data viewer:
  • Advanced paste was fixed (multiple row paste)
• SQL editor:
  • SQL script toolbar was redesigned
  • Omit empty results tab for new editor
  • Copy as source code was fixed
  • Auto-completion disable was fixed
  • Query cancel UI was fixed (force cancel confirmation was removed)
• Data transfer:
  • 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
• Driver editor dialog was redesigned
• Clickhouse:
  • Driver download was fixed
  • Table column comments support was added
• Redshift: driver version was updated (“session is read-only” issue was resolved)
• MariaDB: sequences support was added
• MySQL:
  • JSON columns copy was fixed
  • mysqldump parameters are set according to the client version
• SQLite: column delete script was fixed
• PostgreSQL:
  • 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 (thanks to @olavloite)
• SQL Server: jTDS driver support was fixed (problem with schema list load)
• Exasol: grants refresh was fixed
• Ubuntu PPA update was resolved
• New tips of the day were added
• All application jars are signed with DBeaver code sign certificate
• Many minor UI bugs were fixed