• Object (tables, columns, etc) editor was redesigned
• Statistics/misc tab was added to object editors
• Data transfer supports document-oriented databases now
• Table rename procedure is available from the table editor (MySQL, PG, Oracle, DB2)
• Long operations canceling was fixed
• “Tip of the day” popup was added
• Java 11 support was added
• Azure SQL driver was added
• AWS Athena support was significantly improved
• AWS Redshift:
  • Spectrum and external tables support was added
  • Columns and foreign keys metadata reading was fixed
• Cockroach: foreign keys reading was fixed (for ERD)
• Vertica: performance for data reading from big tables was improved
• PostgreSQL: support transactions in tools (Truncate and others) was added
• Oracle: TIMESTAMPTZ and TIMESTAMPLTZ data types support was fixed
• Greenplum: session manager was added
• SQL Server: sequences info reading was fixed
• Clickhouse: GROUP BY/ORDER BY functions in grouping panel were fixed
• Eclipse 2018-09 is now the default platform.
• Extra command line parameters were added
• German and Russian localizations were significantly improved
• A lot of minor UI fixes

Release notes:

• Google BigQuery extension was added
• DBF files driver was added
• SOCKS proxy: support for proxies on localhost
• New version release checker was fixed (NPE)
• SQL editor:
  • Selection occurrences highlighting was improved
  • Auto-completion: fuzzy completion is now used for all database objects
  • Extra formatting configuration was added
  • Active query tab switch bug was fixed
  • SQL joins auto-completion was fixed (quote column names)
• Results viewer:
  • Filtering + ORDER BY was fixed
  • All long string editors now support xml/json formatting
  • Native date/time formatting support was added
  • Date/time columns justify config was added
  • Bit string values support was fixed
• Data transfer:
  • Max string column length is respected when generating DDL
  • TXT format support was fixed (column widths)
• Query/long tasks canceling was improved (configuration)
• Connection default transaction isolation level configuration was fixed
• Driver version selector was fixed (MacOS)
• Apache Hive/Spark/Impala:
  • Table data edit support was added
  • Table/view source reading was implemented
  • Driver version was upgraded (2.6.5)
• Firebird: table columns rename/reorder/edit is now supported
• PostgreSQL:
  • Indexes predicate support was added
  • Domain data types (timestamp) resolve was fixed
• Oracle 11: NULL timestamp bug was fixed
• Clickhouse: driver config was fixed (catalogs)
• SQL Server: native driver version upgrade (7.0.0)
• Generic driver connection page UI was fixed (long URLs problem)
• Many minor UI fixes

Release notes:

• SQL editor: highlighting all occurrences of selected word (configurable)
• DBeaver extensions installer was improved: admin permissions are not required any more
• Color Theme extension support was added including Solarized Dark/Light themes
• Problem with upgrade from DBeaver 3.x was fixed
• Server session manager was improved:
  • UI was redesigned
  • Session manager is now present in Tools menu
  • “Explain execution plan” tab was added
  • Long operations panel was added
  • Oracle: many additional session properties were added
• RPM package was fixed (with newer RPM packager)
• Data transfer: option “Selected columns/rows only” were fixed
• “Read data in SQL console” behaviour was fixed (use SQL scripts instead of console)
• Extra commands were added to Database navigator context menu: for data edit, ERD, etc
• Grouping panel was improved: default ordering, duplicates finder, SQL Server syntax support
• UI for the connection selection dialog was improved
• Procedures editor was fixed (Generic driver)
• Results viewer:
  • Columns widths resize issue was fixed
  • Row deletion for custom SQL without unique key was fixed
• SQL Editor:
  • Paste from source code
  • formatting was improved (line feeds)
  • SQL indentation was fixed (DDL statements)
  • Formatter preferences page was redesigned
  • SQL Workbench formatter was added
• ERD editor: note delete command was fixed
• Generic connections (Impala and some others) create was fixed (buttons enablement)
• Oracle: “Connections has timed out” error was fixed
• SQL Server: IPv6 hosts support was added
• Vertica: tables metadata reading performance was greatly increased
• PostgreSQL: generic (Legacy) driver metadata reading was fixed
• Redshift/PostgreSQL: array data types support was improved (NULL arrays)
• Added localization for many UI strings
• Many minor UI fixes

Long waited major release. There are lots of bug fixes and improvements.
Changelist:

• New connection wizard was significantly simplified
• Database navigator now loads long table lists by segments (configurable)
• Problem with data transfer wizard and connection wizard auto-resize was fixed
• Results viewer:
  • Show error when cell value can’t be read from a database (instead of NULL)
  • Plaintext renderer was fixed (NULL values render)
  • Actions enable/disable state was fixed
  • Export to Excel now respects filters and orderings
• Mock data:
  • Wizard was fixed (error with missing native client)
  • Batch size configuration was added
  • UUID data type support was added
  • String generator was fixed
• CSV import:
  • Column mappings were fixed
  • Support literal for NULL mark
• SQL editor:
  • Problem with procedures/views editor cursor reset on save was fixed
  • SQL formatter was fixed (spaces after brackets)
  • Completion of fully-qualified names was fixed
  • Error position highlight was improved
• Long LOB values editor fix
• New version check dialog can be suppressed for a particular version
• ERD: show table/constraint comments
• CockroachDB extension was added
• PostgreSQL:
  • Active database switch was fixed
  • Native client selector was fixed. Binaries were upgraded to PG 10.5 version.
  • Improved support of PostgreSQL 7.x and 8.x
  • Allow to select directory in restore wizard
• MySQL:
  • Problem with zeroDatetimeBehavior property was fixed
  • Duration data type support
• Elasticsearch: driver version updated to 6.4
• Redshift:
  • Native Redshift table DDL generator was added
  • Driver version update to 1.2.16 (now use Maven artifact)
• SQLite: custom unique key editor was fixed
• Vertica: SELECT INTO limit problem was fixed
• H2: schema browser was fixed
• MSSQL and Generic driver: support filters for procedures/packages
• Misc minor UI problems were fixed

Release notes:

• Generic driver: new objects creation was fixed
• Foreign keys creation was fixed
• Schema loading was fixed (Generic driver)
• Native client download feature was added (MySQL, MariaDB, PostgreSQL)
• Database objects search was fixed
• Long CLOB value editor was fixed
• Configuration for edit toolbar visibility was added (toolbar is disabled by default)
• Keyboard shortcuts activation was fixed
• Security:
  • SSH tunnel initialization fix (NPE)
  • SSH keyboard-interactive method: now use saved password
  • Advanced security (BouncyCastle) is now used for SSL/SSH cryptography by default (if present)
  • ed25519 support was updated
• SQL editor:
  • Auto-completion was improved (fully-qualified names)
  • Source code paste transformer was improved
  • Indentation was fixed
• Redshift:
  • PostgreSQL driver is used for connection
  • Data editor was fixed (read-only state)
• Vertica: table list loading performance issue was fixed
• MySQL: zeroDateTime configuration was fixed (solves performance issue)
• PostgreSQL:
  • Table DDL was fixed (GRANT commands)
  • Foreign table DDL was fixed (OPTIONS clause)
• SQL Server: BIT data type editor was fixed
• SQLite: datatime/numbers formatting support was added
• Many minor UI fixes
• After all we have reverted to Eclipse 4.7 platform. There were too many bugs and problems with latest version. Especially with Linux platforms

Release notes:

Release notes:

• Data viewer:
  • Foreign keys/references navigation was improved
  • Unique key detection was changed (ROWID is used only if no natural key was found)
  • String filter editor was fixed
• Full-text search history navigation was fixed
• SQL formatter was fixed/improved
• ERD: self-referencing tables rendering was fixed
• Error dialog was enhanced (scrollable text for all errors, default focus is on Ok button)
• Database navigator double-click behavior was extended (open new editor)
• Database driver search was improved (search in descriptions)
• Snowflake connection configuration UI was added in CE
• Elastic Search driver configuration was added
• AWS Athena driver configuration was added
• Exasol extension now relies on v6 driver
• PostgreSQL:
  • Multiple databases filter was fixed
  • Active database detection was fixed
  • Function list reading was fixed for PG < 8.4
  • Foreign server user mapping was added (thanks to @johnatanDM)
  • Permission editor UI was fixed
  • Many minor UI fixes
• MariaDB/Galera: users editor was improved
• MySQL/MariaDB: view creation was fixed
• Oracle:
  • DATE data type support was fixed
  • Table statistics/storage information was added
  • Synonyms support was added in metadata extraction
  • Extra columns were added to Explain Plan nodes
  • Multiline editor for table/column comments
• Firebird: sequences and triggers reading was fixed for older FB versions
• Phoenix: metadata reading bug was fixed (databases with single schema)
• Shortcuts with Ctrl+Alt were changed on Ctrl+Shift
• DBeaver was migrated to Eclipse 4.8 platform. Besides other improvements this fixes a few old UI bugs on MacOS and Linux.

Release notes:

• Database objects search fixed (GoTo object dialog)
• Database full-text search was improved (state loading, bug were fixed, search history was fixed)
• Default error dialog was redesigned (allow message copy-paste and scrolling)
• Drivers download errors was fixed (missing Maven artifacts handling)
• ERD looks-and-feel was fixed. Extra configuration was added.
• SQL editor:
  • Query comments processing was fixed
  • Left toolbar rendering was fixed (background color issue)
  • SQL formatter for sub-selects was fixed
• Results viewer:
  • Presentation switch error was fixed
  • Sorting by ambiguous columns was fixed
  • Visualize read-only columns in grid header (different background color + tooltip)
  • Value view panel read-only state handling was fixed
  • Search in value view panels was added
  • Execution log and output panel toggle shortcuts were changed
• PostgreSQL:
  • Driver version updated to 42.2.3
  • Multi-database support was improved (no need to switch active database on access)
  • Foreign table DDL was fixed
  • Materialized view DDL was fixed
  • Domain data types resolution was fixed (problems with date/time types)
  • Debug perspective switch was fixed
• MySQL:
  • New driver for MySQL 8.x was added
  • Timestamp time zone issue was resolved
• Oracle:
  • Tablespace storage information was fixed
• Yellowbrick driver configuration was added
• Timescale driver connection page was fixed
• SAP HANA: activate database switch was added
• Data export in SQL: null table name issue was fixed
• Data transfer by segments + table truncate was fixed
• Database output log contents filtering was added (zero characters)
• Database navigator: icons position was fixed
• New table columns rename was fixed
• MacOS installer was fixed (CE and EE version on the same machine issue)
• Debug logging was fixed (do not log secure information)
• Many minor UI fixes

Release notes:

• SQL editor:
  • Commands toolbar was redesigned
  • SQL formatting for JOINs was fixed
  • Indentation in auto-formatter was fixed
  • Vertical editor selection bug was fixed
  • Support multiple values in @SET command
  • Command shortcut processing was fixed
• Results viewer:
  • Filter editor behavior was fixed (Enter key processing)
  • Glitch with text edit panel (CLOBs) was fixed
  • Column (row) drag-n-drop in record mode is now supported
• ERD:
  • Entity render was improved
  • Associations (foreign keys) resolution was fixed
• PostgreSQL:
  • Active database switching was fixed
  • Metadata editor was improved (materialized views tablespace, table extra options)
  • Materialized views refresh tool
  • Explain plan conditions formatting was added
  • Index columns view was improved
• MariaDB/MySQL:
  • Server time zone selected add in connection edit page (MySQL only)
  • Show view algorithm in metadata viewer
  • Save view was fixed
  • Save Trigger was fixed
  • Permissions grant was fixed for HISTORY privilege (MariaDB)
• Oracle:
  • Show used/available space for tablespaces
  • View source extraction was fixed (extra semicolon issue)
  • Procedures auto-completion was fixed
• DB2: sequence creation was fixed
• SQLite: sequence reading was fixed
• SAP HANA: procedures and functions were separated
• Timescale: driver configuration was added
• GoTo database object dialog: connection health checking was added
• Row count calculation for custom queries was fixed
• Metadata editor supports dialog with multiline editor for comments/remarks
• Output log viewer auto-clear option was added
• Connection invalidate was fixed (do not show notifications for alive connections)
• Many minor UI and localization fixes

Release notes:

• Results viewer:
  • Filter text can be expanded (for multi-line filter values)
  • Filter editor now supports undo/redo and drag-n-drop
  • Text value editor was fixed (undo/redo commands)
  • Grouping panel UI was fixed (settings save, dark theme, keys navigation)
  • Table ordering is saved between foreign keys navigation
  • Context menu was refactored
• SQL Editor:
  • Parser performance was improved
  • SQL formatting was improved
  • Support special characters in table names for auto-completion
  • Stored procedures execute was improved
  • Stored procedures names auto-completion was added
• Driver manager dialog was fixed
• ERD:
  • Palette is visible by default
  • Notes edit was fixed (+ undo/redo)
• Table/tree editors UI was fixed for MacOS
• Ping/keep-alive background jobs visualization was fixed
• PostgreSQL:
  • Use fully qualified data type names in DDL
  • View default values for procedure parameters
  • Enum/set values editor was fixed
  • Revoke all permissions command was fixed
  • Show template databases
• MySQL:
  • Event DDL was fixed
  • View DDL was fixed
• SQL Server: datetime/datetime2 data types handle was fixed
• HSQLDB: synonyms support was added
• Data transfer:
  • CSV values escaping was fixed
  • Support export in SQL format for custom SQL queries
  • Finish wizard message can be suppressed
• Localization was improved