DBeaver 4.0

Big release. Eventually we have migrated to Eclipse 4.6.
Besides other changes this means that DBeaver now requires Java 8.
Note: only Community Edition version was released. EE version will be released a bit later.

Changelist:

  • Migration on Eclipse 4.6 platform:
    • DBeaver now requires Java 8
    • Support of HighDPI monitor
    • SQL editor zoom in/out function
    • Many UI fixes in GTK mode (CPU usage)
  • Transaction monitor
  • Pending transactions monitor dialog
  • Commit/Rollback commands are enabled only if transaction is active
  • SQL editor: performance fixes (CPU usage in idle mode)
  • SQL editor: tabs switch shortcuts added
  • SQL editor: memory leaks fixed (multiple result tabs)
  • SQL completion: quoted identifiers completion has been fixed
  • Results view: custom coloring fixed (multiple color settings for single column)
  • Results view: attributes hide/show fixed (visibility change doesn’t require results refresh)
  • Query manager view: rows coloring was fixed
  • Data export: execute external process on finish
  • CSV export: NULL value rendering configuration
  • Create index: ability to set column ordering
  • Connection keep alive now reopens failed connections
  • Status bar: shows current time zone and locale
  • Connection editor: connection folder settings save was fixed
  • SSH tunnel config: ask for password if password wasn’t saved in connection settings
  • BLOB value rendering was fixed
  • HSQLDB: embedded database shutdown fix
  • MySQL: SSL support has been improved (certificate private key support, Google Cloud support)
  • Oracle: PL/SQL packages navigation was improved (navigate from procedures and from SQL editor)
  • Oracle: fix of metadata reading for version <= 8
  • PostgreSQL: numeric columns scale/precision are now editable
  • PostgreSQL: case-insensitive autocompletion was fixed
  • PostgreSQL: new tables/columns comments save was fixed
  • SQLite: data editor was improved (SQLite synamic data type system support)
  • SQLite: read and edit of triggers and sequences
  • SQLite: native tables/views/triggers DDL
  • SQLite: tables rename support
  • Many minor bug fixes
Posted in Releases

DBeaver 3.8.5

This is a hotfix version. It fixes performance issues in 3.8.4 and also adds a few minor improvements.
Changelist:

  • SQL editor performance fix (auto-completion)
  • Export from SQL query fix
  • Results advanced copy/paste: quote complex cell values
  • Results viewer: value view panel refresh fixed
  • Foreign key dialog: schema selector added
  • Metadata editor: copy/paste in search control fixed
  • Metadata editor: columns configuration dialog fixed
  • Generate SQL action fixed
  • PostgreSQL: schema selector fixed
  • A few minor UI fixes
Posted in Releases

DBeaver 3.8.4

Changelist:

  • Resultsets refresh UI was improved
  • SQL editor: connection selector was redesigned
  • SQL editor: auto-indent/completion was fixed
  • Use virtual keys in generated SQL
  • Generate SQL UPDATE for resultsets
  • Connection editor save was fixed
  • DBeaver identification config added
  • Maven repositories configuration UI has been improved
  • Preferences pages were reorganized
  • German localization (thanks to @Sargul)
  • PostgreSQL: table/role permissions viewer was added
  • PostgreSQL: new column create dialog added
  • PostgreSQL: disable BEGIN/END blocks processing
  • Exasol: auto-completion was fixed
  • MS SQL: DDL generation was fixed
  • Cassandra: NULL values read/write fixed
  • Data export: JSON format was fixed
  • Many minor UI fixes/improvements

I hope that this is the last 3.x version.
4.0 release is planned at the end of February.

Posted in Releases

DBeaver 3.8.3

  • Metadata viewer: columns are configurable
  • Navigator filters toggle command
  • SSH tunnel auth (password/public key) fix
  • SSH tunnel invalidate fix
  • SQL templates formatting fixed
  • SQL script execution fixed (blank lines)
  • SQL editor: empty files delete fix
  • Data viewer UI improved (column description in header)
  • Date editor: include combo-box editor was fixed
  • Connection wizard UI improved
  • Keep connection user name in secured storage
  • Connection properties edit/save fixed
  • MySQL: zero date/time value support
  • MySQL: drop index fix
  • PostgreSQL: procedure parameter names reading fix
  • PostgreSQL: sequence properties reading fix
  • PostgreSQL: CHECK constraints support
  • Teradata: JSON editor
  • Exasol: maven driver added
  • Eclipse Marketplace support added (EE version)
  • Many minor UI fixes
Posted in Releases

DBeaver 3.8.2

  • Hierarchical connection folders support added
  • New folders browser was added
  • Object (table, schema, etc) editor activation (after restart) was improved
  • SSH tunnel invalidation fix
  • SSH keep-alive config was fixed
  • Connections copy/paste was fixed
  • Metadata search results UI fixed
  • Data export wizard was fixed (bad performance for long SQL queries)
  • Results viewer: total row count action added
  • Results editor: drop-down editor fixed, activation on key-down fixed
  • PostgreSQL: JSON support (value copy, array view) fixed
  • PostgreSQL: extra keywords & data types highlighting
  • Firebird: SQL delimiter redefine support added
  • Oracle: procedures/packages
  • check compile status on save
  • Oracle: PL/SQL blocks execution was fixed
  • DB2: session manager UI was fixed
  • DB2: tools (runstats, reorg, etc) UI was fixed
  • Teradata: JSON support
  • Exasol: views/tables descriptions, misc fixes
  • Exasol: now uses Maven repository for driver download
  • Cassandra: new rows edit was fixed
  • Cassandra: date/time values edit fixed
  • Misc UI fixes
Posted in Releases

DBeaver 3.8.1

DBeaver 3.8.1 is mostly a bug fix version. Brief changelist:

  • Object editor: many fixes in properties editor/refresh
  • Results editor: row data refresh after insert/update
  • ERD: refresh action was fixed
  • SQL queries execution was fixed (multiple statements, params binding)
  • SQL completion was fixed
  • Generic: auto-increment columns creation support (H2, Derby, Teradata, MSSQL)
  • H2: new database extension (supports views source, sequences)
  • MySQL: dump/restore wizard fixed
  • PostgreSQL: local client home configuration fixed
  • PostgreSQL: triggers properties improved
  • Oracle: triggers caching fixed (performance)
  • Cassandra: SSH tunnel support added
  • MongoDB: support of replica servers
  • Secure passwords storage support (EE)
  • Misc minor UI fixes
Posted in Releases

DBeaver 3.8.0

  • SQL editor tabs management was redesigned
  • Object editor UI was redesigned
  • Basic icons were updated
  • Results viewer: web hyperlinks support, URL transformations, web pages viewer
  • PostgreSQL: database dump/restore support was added (pg_dump/pg_restore)
  • PostgreSQL: admin tools added (analyze, vacuum, truncate)
  • PostgreSQL: trigger properties were fixed
  • PostgreSQL: view triggers support
  • MariaDB: local client detection fixed
  • Cassandra: query trace panel added
  • Oracle: tablespace management was added
  • Oracle: SQL error position detection improved
  • Exasol: high speed load/unload to csv
  • Exasol: Virtual schema support
  • MacOS: product info (plist) was fixed
  • SQL Editor: dynamic parameters binding fixed (+dialog redesign)
  • SQL Editor: status toolbar was fixed/improved (warning list)
  • SQL completion fix (extra options in preferences)
  • SQL generator fix (DDL for complex objects like packages)
  • Many minor UI fixes
Posted in Releases

DBeaver 3.7.8

This is a hotfix version.
This is the last 3.7.x version release (hopefully).

Brief changelist:

  • Results viewer was fixed (numerous bugs were fixed in refresh, navigation, filters, ordering, etc)
  • FK create dialog was fixed
  • Oracle: schema filters were fixed
  • Oracle: NLS date format config
  • SQL Server/Generic: procedure names were fixed
  • Taradata: driver config was fixed
  • Evaluate SQL Expression command was added
  • A few minor UI problems were fixed
Posted in Releases

DBeaver 3.7.7

Changelist:

  • Results viewer UI redesign
  • Exasol extension (by Karl Griesser). Basic features:
    • DDL for views, tables, scripts
    • Table editor
    • Connection objects browser
    • Session manager
    • Security browser
    • Explain execution plan
  • Table/constraint/index edit dialogs were improved
  • Date/time values rendering was redesigned (for export and SQL generation).
  • CLOBs encoding problem was fixed
  • DBeaver version check/update was fixed
  • Statements timeout config fixed (+Cassandra support)
  • SQL Editor: script execution visualization was added
  • ERD: types names rendering was fixed
  • Drivers download UI was improved
  • Disconnect All command added
  • MySQL: triggers create/refresh was fixed
  • MySQL: column creation dialog
  • PostgreSQL: hyperlinks/object navigation was fixed
  • Oracle: CLOB/BLOB export was improved
  • ODBC: connection initialization was fixed
  • MacOS: product icon was fixed (thanks to Jose de Modena)
  • MacOS/Linux: checkbox editor rendering was fixed
  • Linux: results viewer rendering was fixed
Posted in Releases

DBeaver 3.7.6

Changelist:

  • ODBC: database metadata reading was fixed
  • PostgreSQL: SQL autocomplete fixed (with schema name)
  • PostgreSQL: multi-dimension arrays support
  • Oracle: advanced constraint types support
  • MS SQL: drop table in non-active database fix
  • SQL execution: query metadata reading is now configurable
  • Results viewer: metadata extraction (attribute binding) is now configurable
  • Results viewer: copy column/row names command introduced
  • Results editor: fixed activation on key press
  • SQL completion: auto completion improved and enabled by default
  • SQL formatting: special characters formatting was fixed
  • Windows installer: fixed support of target folder (/D) in silent install (/S)
  • ERD: fixed problem with multiple unique keys
  • Metadata browser: objects refresh was fixed
  • Metadata browser: column values rendering fixed
  • CSV export: data formats settings fixed
  • UI fixes for better GTK support
  • Added support of Open JDK 9
  • Many minor UI bugfixes
Posted in Releases