DBeaver 5.1.3

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
Posted in Releases

DBeaver 5.1.2

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
Posted in Releases

DBeaver 5.1.1

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
Posted in Releases

DBeaver 5.1

DBeaver 5.1. has been released.

It is a major cumulative version.

Release notes:

  • Results viewer: Groupings panel was added (GROUP BY generator)
  • Results viewer: Aggregate panel was renamed to Calc
  • Results viewer: links navigation was fixed (references rendering)
  • Results viewer: show confirmation if panel data was modified
  • Results viewer: improved drag-n-drop support for all controls
  • Results viewer: icons were fixed
  • Mockdata: template generator was added
  • SQL editor: show stored procedures/functions in SQL completion
  • SQL formatting was fixed (single line comments)
  • XLS export: empty tables export was fixed
  • Update site management preference page was added
  • Columns visibility/order configuration dialog was improved
  • Date/time formatted was fixed (nanoseconds format pattern)
  • HANA: functions source code reading
  • Clickhouse: array data types support was added
  • Oracle: session elapsed time was added
  • Oracle: timestamp with timezone handler was fixed (check driver version)
  • PostgreSQL: drop sequence query was fixed
  • RedShift: driver configuration was fixed
  • Many minor UI bugfixes
Posted in Releases

DBeaver 5.0.6

Release notes:

  • Support of cells edit for queries with joined tables
  • SSH tunnels: test connection button was added
  • Results viewer: horizontal scroll with mouse wheel (with Shift key)
  • Results viewer: extra header tooltips were added
  • PostgreSQL: debugger – fix breakpoints support
  • PostgreSQL: data types loading performance was greatly increased
  • PostgreSQL: search_path updating was fixed
  • PostgreSQL: array data type support was improved
  • MySQL 8+ support was fixed
  • Oracle: jobs scheduling (thanks to Neil Crow)
  • Oracle: schema create dialog improvements
  • Oracle: error positioning was improved
  • Oracle: timestamp with timezone support was added
  • Oracle: CASE statements parser was fixed
  • SQL Server: triggers reading was fixed
  • SQL Server: drop trigger feature was added
  • Vertica: table columns editor (data type, nullability)
  • Redshift: driver version update
  • Cassandra: JSON formatter for all text columns
  • ERD: include nullability in attribute type description
  • Queries history browser was fixed
  • Some keyboard shortcuts were changed (results navigation)
  • Some icons were updated
  • Japanese localization was added (thanks to Ishibashi Takken)
  • Spanish localization was added (thanks to faibistes)
  • Misc minor UI bugfixes
Posted in Releases

DBeaver 5.0.5

Release notes:

  • PostgreSQL procedures debugger was added in CE
  • Search in query history feature was added
  • Query manager view was redesigned
  • DBUnit data export format support was added (thanks to Henrik Hansen)
  • Eclipse Mars (and earlier) support was fixed
  • Foreign key values browser was improved (progress visualizing, values ordering)
  • Results viewer/editor key bindings activation was fixed
  • Results viewer now respects database navigator filters (default column visibility)
  • Results viewer shortcuts (fetch page/fetch all) were changed to avoid conflicts with Linux def shortcuts
  • XLS data exporter was improved (column comments support)
  • SQL formatter was fixed (special characters processing)
  • SQL Editor: auto-completion was fixed for Generic driver (including SQL Server and Informix)
  • Connect, disconnect and invalidate timeouts were added
  • PostgreSQL: view comments and permissions support was added
  • PostgreSQL: asynchronous server output reading is now supported
  • PostgreSQL: schema create was fixed
  • MariaDB: packages support was added, procedures read was fixed
  • DB2: table columns create/edit supports was added
  • Oracle CASE statement parsing was fixed
  • Misc minor UI bugfixes
Posted in Releases


Important notice:

We decided that DBeaver deserves a second level domain.
So, eventually, the community web site has moved from dbeaver.jkiss.org to dbeaver.io.

All existing links should work fine (they will be just redirected to the same page link on dbeaver.io).

Posted in News

DBeaver 5.0.4

Release notes:

  • Different action icons were fixed (results viewer, SQL editor, file operations)
  • Results viewer: context menu was redesigned (compacted)
  • Results viewer: scrolling shortcuts were changed
  • HighDPI support: composite icons rendering was fixed
  • Data export: SQL INSERT format support for custom SQL queries
  • Mockdata: commands contributions (menu and toolbar) was fixed
  • SQL editor: object search now can search inside object names
  • SQL editor: auto-indent was fixed (identifier replace issue)
  • SQL editor: “to upper case/to lower case” command shortcuts were fixed
  • SQL editor: bold font style configuration
  • Bookmarks drag-n-drop inserts real object name
  • Database objects create: mixed case identifiers support was fixed
  • Database aliases support was added (DB2, Oracle)
  • Diagram viewer: support aliases drag-n-drop
  • Diagram viewer: tables/columns copy action was added, context menu was redesigned
  • Table truncate support (for data transfer, mock data generators, etc)
  • Oracle: default driver version changed to 12.2
  • Oracle: expired passwords change UI
  • Oracle: DROP INDEX was fixed
  • PostgreSQL: permissions reading was redesigned
  • PostgreSQL: table columns permissions view/edit support was added
  • PostgreSQL: create function dialog redesign
  • PostgreSQL: schema DDL support was added
  • PostgreSQL: schema comments edit support was added
  • PostgreSQL: tablespace edit support was added
  • PostgreSQL: constraint indexes support
  • PostgreSQL: default schema change was fixed
  • PostgreSQL: trigger attribute view
  • MySQL: enum columns parser was fixed
  • SQLite: read-only connections support was added
  • Firebird: driver version was updated. 2.x driver was removed.
  • Firebird: SET TERM command evaluation was fixed
  • Vertica: tables, projections and columns comments support was added
  • Clickhouse: metadata read fix
  • Misc minor UI bugfixes
Posted in Releases

DBeaver 5.0.3

Release notes:

  • Event notification UI was added (commit/rollback/reconnect events)
  • Results viewer: status bar update fixed (re-layout)
  • Results viewer: filters reset action enablement was fixed
  • Results viewer: ordered UUID transformer was added
  • Results viewer: support of grid columns drag-n-drop in text editor was added
  • Results viewer: filter dictionary reading was fixed (include NULL values)
  • Results editor: script generation was improved (column values are now correctly rendered)
  • Results editor: complex data type (structures, arrays) editor UI was fixed
  • SQL editor: autocomplete was fixed (word replacement)
  • SQL formatter: keyword case configuration UI was fixed
  • PostgreSQL: function permissions editor was added
  • PostgreSQL: active schema switching was fixed (search_path patching)
  • PostgreSQL: support of PG <= 8.4 (data types info reading)
  • PostgreSQL: table comments added in DDL
  • Oracle: synonyms reading was fixed (include broken synonyms)
  • Oracle: NUMBER data type scale/precision editor was added
  • Oracle: convert query line feeds for ORacle <= 10
  • SQL Server: procedures drop was added
  • SQL Server: table comments reading was added
  • Connection invalidate job was fixed (disable disconnect on first failure)
  • Connection editor was fixed (folder list)
  • Autocommit toolbar button state refresh was fixed (on editor switch)
  • CLI: connections duplications bug was fixed
  • Query manager colors configuration was added
  • Data transfer: extra output file name template variables were added
  • Global column filters support was added
  • ERD: fully qualified table names option was added
  • ERD: export in GraphML was fixed (column data type)
  • XLSX exporter was improved (configuration UI)
  • SSHJ extension was repackaged
  • Full text searcher UI was fixed (messages)
  • Mockdata wizard UI was improved
  • RPM package dependencies fix (Java 8)
  • Misc minor UI fixes
Posted in Releases

DBeaver 5.0.2

  • SQL editor:
    • Empty script close behavior config was enhanced
    • Resources leak (thread + memory) was fixed
  • Results viewer: plaintext + record mode error was fixed
  • PostgreSQL:
    • Permission grants in table DDL
    • Constraints comments support was added
    • Foreign keys comments support was added
    • Sequences support (v10) was fixed
    • Sequences comments support was added
    • Functions permissions UI was added
    • Triggers DDL was added
    • Inherited tables DDL was fixed
    • Foreign servers DDL was added
    • Foreign wrappers DDL was added
    • Database rename support was added
  • Oracle:
    • DBA views resolve was fixed
    • Standard function names highlight was fixed
  • Exasol: table row count support was added
  • SQL Server: URL generation (explicit port value) was fixed
  • Greenplum driver configuration was added
  • Data export: XLS format (NULL cell values, column comments) was fixed
  • Minor UI bugfixes
Posted in Releases