• Active database/schema selector behavior was significantly improved
• Smart commit mode was enhanced:
  • Switching to auto-commit after the end of transaction
  • Smart commit for table editors
  • Transactions preference page was added
• Data transfer:
  • CSV export parameters (quote mode) were added
  • Add/remove table to existing data transfer task was fixed
• SQL editor:
  • “Select all rows” query generation was fixed
  • Read data in console now uses correct default schema
  • Data viewer:
    • Show boolean values as checkboxes (configurable)
    • Row colors customization was fixed
  • Connection editor:
    • Multiple connection editor dialogs can be opened now
    • Extra variables were introduced, config UI was improved
  • Apache Phoenix:
    • Driver version was updated
    • Schema-less tables read was fixed
    • Index create support was added
    • SQL autocomplete was fixed
  • Exasol: metadata editor was significantly improved
  • Neo4j: complex data types (structs/arrays) support was fixed
  • Snowflake: index editor was fixed, view editor was fixed
  • PostgreSQL:
    • Backup for selected tables was fixed
    • Execute script on the selected database was fixed
  • Greenplum 6.x: table DDL was fixed
  • Oracle: PL/SQL parser was fixed (code blocks)
  • A lot of minor bugfixes
  Tweet

• Tasks:
  • SQL script execute task was added
  • Variables support was added
  • Grouping of tasks by project/type was added
  • Active database/schema now saved for custom SQL queries
  • Target table mapping was fixed for database-to-database data transfer
• Data viewer:
  • Column filter UI was improved (multi-value select, value search)
  • Null XML columns support was fixed
  • Column value transformations and coloring was fixed
  • Context menu was improved (layout was change, missing commands were added)
  • Problem with missing toolbar actions was fixed
  • Hex editor coloring was improved, dark theme support was added
• SQL editor:
  • Auto-complete now respects active schema
  • Database output read was fixed (async mode)
  • Hyperlinks and object navigation were fixed
  • Aliases generation algorithm was improved
• PostgreSQL:
  • Database restore task was fixed (target database)
  • SQL parser was fixed (BEGIN/END keywords)
• Oracle: procedures/views source code editor was fixed
• MySQL: database restore log level config was fixed
• Netezza: views and procedures source extraction was fixed
• Hive: view editor was fixed
• Neo4j: arrays support was fixed, SQL parser was fixed
• Metadata editor: current database detection was fixed
• Tooltips for database navigator were improved
• Variables in connection parameters now enabled by default
• Connection type permissions save was fixed
• Dark theme support was improved in the main toolbar and in different dialogs
• SSH agents support was fixed (now we use ssh-agent on Linux)
• SSH + private key + password: configuration dialog was fixed
• A lot of minor bugfixes

• 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