• 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

• SQL editor:
  • “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
  • Auto-completion performance was improved
• Data editor:
  • Drop-down inline editor was fixed (Linux)
  • Epoch time transformer now supports timezones
  • Copy As SQL: now uses correct SQL dialect
• Metadata editor: support of pure unicode identifiers was added
• Content assistant was fixed for drop-down selectors
• Connection configuration import now supports target folders
• 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
• Trino (ex-PrestoSQL) driver was added (thanks to @mosabua)
• MariaDB: default driver version upgraded to 2.7.1
• SQLite:
  • Spatial (gis) data viewer was added
  • Metadata refresh was fixed (wrong foreign key name)
• PostgreSQL:
  • 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
• Redshift: driver version was upgraded (bug with “session is read-only”)
• Presto/Trino: GIS transformers support was added
• Firebird:
  • SQL parser was fixed (code blocks)
  • Table/view type recognition was improved (for older FB versions)
• Number of errors with wrong focus tracking fixed on MacOS
• 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
• Several minor UI bugs were fixed

• SQL Editor:
  • Server Output and Execution Log panels were redesigned
  • Server Output auto-show was added (configurable)
  • SQL formatting was fixed (IN clause)
• Data editor:
  • 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
• 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)
• MySQL:
  • GIS data types support was fixed
  • Table columns mapping was improved in data transfer
• Oracle: dependencies information was enhanced (+dependents)
• SAP HANA: connection editor waa enhanced (port numbers)
• SQL Server:
  • 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)
• Greenplum: partitions and child tables read was fixed
• Informix: stored procedures DDL formatting was fixed
• Spanish localization was significantly improved (thanks to @ adamantike)
• Several minor UI bugs were fixed

• Data editor:
  • 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
• Metadata editor:
  • Boolean values view is now configurable
  • Virtual foreign keys editor was fixed
  • Incorrect column length (zero or negative) was fixed
• Data transfer:
  • Data type mapping was improved (better type matching)
• Password field layout was fixed
• Tasks editor view: collapse/expand behavior was fixed
• Opening SQL files from shell was fixed (MacOS)
• SAP HANA: connection settings page redesigned (thanks to @kai-morich)
• PostgreSQL: roles DDL view was added
• Redshift:
  • Extra data types (non-PostgreSQL) support was added
  • Strings parser was fixed (escape with backslash)
• SQL Server: stored procedures invocation was fixed
• Clickhouse: ALTER TABLE scripts for new columns was fixed
• Many minor UI bugs were fixed

Well, 2020 is almost over (phew).

• 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
• MacOS (BigSur):
  • 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)
• 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 editor:
  • Resultsets ordering configuration was added (client/server side or smart mode)
  • Columns pin flag now saved across different data filters
• SQL editor:
  • Tabs management was redesigned and improved (naming, pins, reordering)
  • SQL folding performance was significantly improved
  • SQL auto-completion was improved for procedures
  • 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
• PostgreSQL:
  • Permission grant queries were fixed
  • New schema + new table + new column create UI was fixed
• Oracle:
  • Session manager now supports Oracle 9
  • Dependencies information was added for tables, views and packages
• Redshift: geometry/geography types support was added
• SQL Server: user data type list was fixed (redundant types were removed)
• Firebird: procedure parameters domain type names were fixed
• 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
• Many minor UI bugs were fixed
• Note: if you experience any problems starting dbeaver after the version upgrade
• please try to reset workspace

New major release:

• A lot of improvements for MacOS:
  • Problem with toggle checkboxes was fixed
  • Problems with inline value editors were fixed
  • Problem with connection editor open on single click was fixed
  • Problem with metadata viewer in BigSur was fixed
• SQL editor:
  • Complex SQL queries parser was improved
  • Query folding now respects active SQL dialect
  • Problem with focus loss after query execute was fixed
• Data transfer:
  • Imports from CSV/XLS: date columns support was added
  • Export in SQL INSERT format: support of various INSERT/REPLACE/UPSERT dialects was added
  • Problem with active schema switch during task execute was fixed
  • Export from query: task UI configuration was fixed (active schema select)
• ERD: table copy-paste was fixed
• Project delete now requires confirmation of project files delete
• Command line: connection credentials now can be passed along with connection name/id
• SSH: private key format conversion was improved (Linux)
• SQL INSERT query generator now skips auto-generated columns
• PostgreSQL:
  • Table DDL was fixed (serial columns)
  • Role members/permissions viewer was fixed
  • Permission editor now supports sequences and materialized views
  • Bug with partition list read was fixed
• SQLite: table column delete feature was added
• Teradata: active schema selector was added
• Firebird: problem with missing views was fixed. View source editor was fixed
• Exasol: table index create UI was fixed
• SQL Server: index create UI was improved (index type selector)
• Hive: SQL dialect was improved (extra keywords)
• MySQL/MariaDB: privileges editor UI was fixed
• Oracle:
  • PL/SQL parser was significantly improved
  • View DDL read was fixed
  • Session manager now supports Oracle 9 and 8
• BigQuery:
  • Problem with missing resultsets was fixed
  • Driver version was upgraded
• HANA: triggers metadata reading was fixed (bug with wrong schema)
• Many minor UI bugs were fixed

• SQL Editor:
  • Folding support was improved and enabled by default
  • Current/selected word highlighting support was improved
  • SQL formatting was fixed for DDL queries (like CREATE TABLE)
  • “Find in Google” command was added
  • SQL-related preference pages were redesigned
  • Parser of complex SQL blocks (e.g. PL/SQL) was significantly improved
  • Problem with missing query results for some DDL queries was fixed
• Data editor:
  • ROWID columns support was fixed
  • Binary values copy-paste support was added
  • Column auto-completion in the filter panel was fixed
• Data transfer:
  • Automatic columns mapping added for CSV without header column
  • Import from CSV/XLS: timezone parameter was added for date/time columns
  • Export from SQL query with custom variables: UIX was improved
• Boolean value editor UI was changed (text instead of icons)
• User authentication UI was fixed when “Save password” option is off
• SSH: private key format transform was improved on Linux
• PostgreSQL:
  • Arrays edit support was fixed
  • Inet and other custom data types edit was fixed
  • “Generate SQL” action for varchar arrays was fixed
  • Create/alter trigger functions were fixed
  • Partition create/drop/alter actions were added
• Hive:
  • Indexes metadata read was added
  • Index create/drop functions were added
  • Column add/delete support was added
  • Table rename support was added
• Oracle:
  • Extra metadata read performance options were added
  • Foreign key metadata read was fixed (ON DELETE rules)
  • View DDL was fixed (column comments)
• Many other minor bugs were fixed