• Database backup/restore/sql tools (PostgreSQL, MySQL, Oracle) now can be saved as tasks
• Smart auto-commit mode was introduced (enable transactions vefore data modifying query execute)
• SQL editor:
  • Alias generation was improved
  • Output log flush eas fixed
  • Default database assign (for SQL script) was fixed
• Data editor: advances paste now respects NULLs for dates and numbers
• PostgreSQL:
  • $$ strings parser was fixed
  • Domain type arrays support was fixed
• DB2 (iSeries, z/OS): new connection issue was fixed
• Oracle: session manager now shows servr-side execution plans (thanks to @SergDzh)
• MySQL: database backup/restore was fixed
• Firebird: unique key DDL was fixed
• Number of fixes and improvements in backup/restore tools
• Workspace switch: last chosen workspace is now saved between app restarts
• Dark theme support was improved (toolbars, dark colors customization)
• Eclipse 4.6 support was fixed
• Problem with missing toolbar buttons was fixed (Linux)
• A lot of minor bugfixes

• SQL editor:
  • Active database/schema change now affects current editor only
  • Server-side output now works with huge outputs
  • New command @unset was introduced
  • Table alias generation was fixed (conflicts with SQL keywords were fixed)
  • Query parameters dialog now doesn’t appear on scrolling/refresh
  • Code templates now saved in utf-8
• Data editor:
  • Smart option “Use all columns” for virtual identifier
  • Inline cell editor now uses the same font as in grid
  • Decimal values formatting was fixed
• Data transfer:
  • Selected rows/columns option support was fixed
  • CSV import was fixed
  • Export to single file was fixed (timestamp pattern)
  • Export from query now works with variables
• Transaction log/query manager: dark theme support was fixed
• Dashboards + timeseries + minute interval support was fixed
• SSH with private key + password support was fixed
• Extra locales (pt and ru) support was added in bundled JDK
• SAP HANA: GIS/spatial data type viewer support was added (thanks to @stefanuhrig)
• Presto: metadata reading was improved (dummy errors suppressed)
• AWS Athena: URL template now respected in new connections
• MySQL:
  • Database backup can be saved as task now
  • Events editor (DDL) was fixed
• PostgreSQL:
  • Connection dialog was improved (new tab was added)
  • $$ and $tag$ parser was improved (new config options were added)
  • JSON and struct data types support was fixed
• DB2: table truncate command was fixed
• Oracle: new function DDL was fixed
• Snap repository dbeaver-ce is now official. We will update it on every version release
• A lot of minor bugs were fixed
• Merry Christmas and Happy New Year!

• SSH Agent support was added (pageant and ssh-agent)
• Disconnect project/folder/all actions were reworked
• Problem with connection properties save was fixed
• Connection properties dialogs UI was improved (test connection, password save, pref page search)
• Task management UI was improved (task create/save actions in data transfer wizard)
• ER diagrams: dummy errors are now suppressed (now they present in log file only)
• Legacy Eclipse plugins installation support was added (with hold update site format)
• Dark theme support was significantly improved
• Auto-commit mode behavior change:
  • Toolbar toggle now affects current connection only
  • Mode change affects active DBeaver session only
• Data export:
  • Export from SQL script now supports commands (@set and others)
  • Saved settings loading was fixed
  • XLSX exporter now respects export configuration
• Data editor:
  • Fetch size can be changed before query execute
  • Spatial viewer now supports different pluggable tiles (mapbox, osm, etc)
  • Wrong date/time format now treated as error
• SQL Editor: editor layout now saved between DBeaver sessions
• Object editor (tables, views, etc) now checks for object name duplicates
• Oracle: now we use full type name presentation by default
• PostgreSQL: support of extra type aliases and array data types was added
• CockroachDB: native CDB data types were added
• Impala: active schema change support was added
• A lot of minor UI/DB-specific bug fixes

• Problem with context menu was fixed (on Linux)
• Problem with mixed global/connection settings was fixed
• SSH: “jump” server support was added (thanks to bsv798)
• Data editor:
  • Vertical and horizontal scroll position is now saved between data refresh/filter
  • Smooth scroll mode is now the default mode (and configurable)
  • Large json loading performance was improved
  • Ordering by unnamed columns was fixed
  • Grouping panel refresh was fixed
  • Data export/copy as: use the same connection by default
• Object editor: property change and object rename was fixed (right order of DDL queries)
• SQL editor: CASE/WHEN formatting was fixed
• Oracle: data type editor UI was fixed
• MySQL: events DDL was fixed (interval)
• PostgreSQL: array-based domain data types handle was fixed
• SQL Server: synonyms search was added
• HANA: table column create was fixed
• Greenplum 6+: table DDL (distribution) was fixed
• Full-text search dialog render was fixed
• Application startup speed was improved
• Several rendering glitches on HighDPI screens were fixed
• Many other minor UI fixes

• SQL editor:
  • Select row count from custom query was fixed (ORDER BY now allowed)
  • Parameters/variable binding was fixed
  • Export from query with parameters was fixed
  • Number of improvements in intellisense algorithms
• Data viewer:
  • Smooth scrolling mode was added
  • Number of fixes in floating point numbers handling
  • Option for short/fully qualified table names in SQL script was added
  • Grid state save/restore (after ordering/filter apply) was fixed
  • Tabs pin + drag-n-drop behavior was fixed
• Tables navigation was fixed (filter value refresh)
• Query manager: query ordering/refresh was fixed
• ERD: problem with broken layout after config change was fixed
• CSV export: row separator config was added
• PostgreSQL:
  • $$ delimiters handle was fixed
  • Function parameters default value reading was fixed
• Oracle: table column comments save was fixed
• SQL Server: functions and synonyms support was added in object search
• Java version in Windows ad MacOS installers was upgraded to OpenJDK 11.0.5
• A lot of other minor UI fixes

• SQL Editor: parameters binding dialog improvements (value preview)
• Data viewer:
  • Result tabs drag-n-drop support was added
  • Spatial data viewer was fixed (tooltips generator)
• Task editor: add/remove tables for existing task was fixed
• Virtual foreign keys support was fixed (table rename support)
• Oracle: Q-style quoting support was added
• PostgreSQL:
  • Foreign Data Wrappers configurator wizard was added
  • $$-quote support was fixed
  • Dependencies info reading was fixed (PG12)
  • Function signature generator was fixed (FQ type names)
• MySQL: column autoincrement flag editor was fixed
• Elasticsearch: driver version was updated
• Windows: app crash problem was fixed
• MacOS: app notarization added for all distributions
• Eclipse plugin: create .dbeaver folder on demand
• A lot of minor UI fixes

• Task management: now all data transfer operations (export/import) can be saved as tasks:
  • New task management view
  • Running saved tasks in two clicks
  • Task execution logs
• Data transfer:
  • Output file names were fixed
  • Previous wizard settings save was fixed
  • Many minor improvements
• Virtual table columns:
  • Supported for all tables and views
  • Supports expressions, math functions and geometry transformation functions
• Virtual foreign keys config save/copy was fixed
• Data viewer:
  • Hex viewer was added for string content
  • Long CLOB text viewer was fixed
  • Filter dialog was fixed (orderings, distinct value reading)
• SQL editor: parameters binding was improved:
  • Show dialog before script execution
  • Show current query text
• Object editor: new command for expensive properties (row count) reading
• SAP HANA
• new extension developed (thanks to @kai-morich):
  • Driver auto-download
  • Sequences, synonyms, triggers
  • SQL execution plan
  • Object searcher
• H2GIS: spatial data viewer was added
• Redshift: stored procedures support was added
• Yellowbrick: driver config was fixed for better performance
• Oracle: view column comments edit support was added
• A lot of minor UI fixes

Release notes:

• Data viewer:
  • Spatial (GIS) presentation improved (tooltips, different shape colors for different columns)
  • JSON render performance was significantly improved
  • XML value viewer was fixed (proper error handle)
  • XML auto-formatting was fixed (extra whitespaces)
  • Context menu “Navigate” was added (returned)
  • Floating numbers representation was fixed (exponential view)
  • Columns transformation settings dialog was fixed
• SQL Editor: update row count calculation was fixed
• MySQL: date/time formatting was fixed
• PostgreSQL: 3D geometry columns render was fixed
• SQL Server: problem with identifiers with “go” characters was fixed
• Oracle: SQL parser was fixed (CASE WHEN ELSE END)
• Connection settings:
  • Load multiple data-sources*.json files
  • Respect preference changes (timeouts and other) in “Test Connection” dialog.
  • Project export/import wizard was fixed
• Database metadata search wizard was fixed
• New database drivers:
  • H2GIS
  • Kognitio
  • Opendistro (Elasticsearch)
• A lot of other minor UI bugs were fixed

• Data viewer:
  • JSON highlighting/formatting was added
  • Select/deselect rows with alt+click was improved
  • Reference panel now supports virtual foreign keys
  • “Set to default value” action was fixed (for timestamp columns)
  • Dictionary read was fixed
• ERD:
  • Table/schema diagram edit is now supported
  • Virtual foreign keys support was added
• Database navigator:
  • Transactions tracking was improved (+now commit/rollback actions are always active)
  • Cross-project connections copy-paste and drag-n-drop was fixed
  • Navigator tree state save (and restore on restart) was added (thanks to loro2)
  • Columns reordering was fixed
  • Global filters configuration was fixed
  • Connection permissions are now supported in connection type (prod, dev, test)
• SQL editor:
  • Query execution time logging was fixed
  • Generate SQL dialog was improved (FQ names, copy to clipboard)
  • Script selector panel UI was fixed
  • Variables binding now can be skipped for a query/script
  • JDBC fetch size now set for custom SQL queries
• Data export now reuses SQL editor connection
• Metadata editor: columns drop was fixed
• SQL Server:
  • NVARCHAR/NCHAR length calculation was fixed
  • Column default value edit support was added
  • DDL for TEXT/NTEXT data types was fixed
• PostgreSQL:
  • Driver now uses URL template (by default)
  • Column comments for new tables now saved properly
• SQL Server Data Warehouse support was added
• MySQL: bit stream data type support was fixed
• CockroachDB: table metadata read was fixed
• Apache Derby driver was upgraded
• Teradata: multiple resultsets support was added
• Test connection dialog was redesigned
• Driver libraries cache was fixed (re-download of Maven artifacts)
• Widows registry reading was fixed (Java 8 compatibility)
• Many other minor bugs were fixed

• Data viewer:
  • Virtual primary/foreign keys editors were enhanced
  • Problem with filters on data refresh was fixed
  • Added confirmation dialog before opened result tabs closing
  • Problem with missing updated row count (in script mode) was fixed
  • References panel now remembers last FK/reference selection
  • Value view panel now supports Find/Replace
  • Float values rendering was fixed (numbers rounding is disabled by default)
• Data transfer:
  • Save of previous target container selections was added
  • Export of tables/queries with complex data types (structs, objects) was improved
• Connection management:
  • Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
  • Problem with bootstrap queries and auto-commit state save/load was fixed
  • Multi-project support was improved (use selected project for new connections)
  • Support of empty database passwords was added
  • Copy/paste and drag-n-drop connections between different projects was fixed
• Database navigator:
  • Default double-click behavior configuration was added (view properties/data/erd)
  • Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
  • Connection type coloring in the main toolbar is back
  • DBeaver toolbars visibility was fixed (for Eclipse plugin version)
• New DBeaver version automatic downloading (optional) was added
• MySQL:
  • Datetime columns edit was fixed. Problems with timezone were fixed.
  • Legacy MySQL <4 driver was added (again)
• PostgreSQL:
  • Automatic transaction error recovery was added (famous “current transaction is aborted” error)
  • Partition management was added (partition create/drop)
  • Support of VACUUM tool for older PG version was fixed
  • Enum items order was fixed (in metadata editor)
  • Legacy PostgreSQL <= 8 driver was added
• SQL Server: index DDL was improved (now it contains all index properties)
• Redshift: table DDL generation was fixed (“diststyle AUTO” and other improvements)
• Hive: struct/array data types support was added
• Presto: array data types support was fixed
• DB2 i: routine list reading was fixed
• We have migrated to the Eclipse 2019-06 platform (fixes many minor UI bugs on Linux)
• Many other minor bugs were fixed