Release Notes

DBeaver EE 5.3

Dec 10 2018
  • New features:
    • Charts as an additional view in Data Editor, Grouping panel and results of SQL request
    • Various options of words highlighting in SQL Editor
    • Support for script sharing in Git: information about connection can be stored in the SQL script now
    • Data migration from SQL databases to MongoDB and Cassandra
    • Administrative panel for remote connections management for PostgreSQL, Oracle, DB2, MySQL, MariaDB and MongoDB.
    • Easy way to install additional extensions
    • Tip of the day
  • Major UI improvements:
    • Metadata Editor was completely renewed.
    • Keyboard shortcuts were reworked to fit various languages and OSes better.
    • A lot of new options were added to preferences for better flexibility and drivers tuning.
    • Support for Darkest Dark theme was added.
    • SQL completion proposals was improved: better objects search, better performance.
    • German, Chinese and Russian localization were significantly improved.
  • New databases:
    • Google BigQuery
    • Microsoft Azure
    • DBF files
  • The wide range of new features for databases:
    • MS SQL Server: new advanced extension with all main specific features support
    • Apache Hive/Spark/Impala:
      • table data edit support
      • table/view source reading
      • driver version upgrade
    • Greenplum: native metadata support
    • AWS Athena: new special connection page
    • AWS Redshift
    • Google BigTables
    • PostgreSQL
    • Oracle
    • Firebird
    • Clickhouse
    • Cockroach

DBeaver EE 5.2

Sep 10 2018
  • New features:
    • Visual Query Builder – the new simple way to construct SQL queries
    • Import from CSV files: direct import from CSV into your database table(s)
    • Native database backup and restore for MySQL/MariaDB and PostgreSQL
    • Support for special security tools:
      • SSH over SOCK proxy support
      • Advanced cryptography and authentication algorithms
  • Major UI improvements:
    • Connection manager interface was significantly simplified.
    • Entity diagram design became more convenient and attractive.
    • Quick access to all main controls in the SQL-editor was implemented.
    • SQL formatter and autocompletion was significantly improved.
    • Mockdata generator now works for MongoDB and Cassandra
  • New supported databases:
    • InfluxDB:
      • Full support of InfluxQL
      • Time series charts rendering
      • Database schema browser
    • TimescaleDB: timeseries database based on SQL interface
    • AWS Redshift: brand new driver with Redshift specific features
    • Yellowbrick: super-fast analytical database
    • CockroachDB: distributed SQL database built for data survival
    • Elasticsearch: JDBC driver for Elasticsearch SQL
    • Other: AWS Athena, Progress OpenEdge
  • New driver versions for:
    • PostgreSQL 10+
    • MySQL 8.x
    • Apache Hive 1.2+
    • Cassandra 3.5.1
    • MongoDB 3.8.0
    • Snowflake: new connection page design
  • The wide range of administration features was added for:
    • PostgreSQL
    • MySQL/MariaDB
    • Oracle
    • MS SQL server
    • SAP Hana
    • Vertica

DBeaver EE 5.1

June 11 2018
  • UI was significantly improved:
    • a possibility to expand the filter field for the long requests was added
    • high resolution screen was supported
    • some icons were updated
    • problems with editable fields were fixed
  • New analytical features:
    • a new panel for data grouping was added
    • existing aggregation panel was improved (and renamed into Calc)
  • Interaction with data in result viewer table was simplified:
    • drag-n-drop for columns was improved
    • navigation by links was improved
    • some shortcuts were replaced for to avoid conflicts with native OS shortcuts
  • SQL Editor became more stable and clear:
    • memory and resource leaks were fixed,
    • SQL formatting was made more clear
    • procedures were added to the autocomplete function
  • Data in a user-specific format can be generated through the Mock data generator
  • New formats were added to Data Export:
    • Markdown and DbUnit formats were added
    • Export to XLS format was improved
    • Export to SQL INSERT was fixed
  • New improvements for ER-diagrams:
    • Columns and tables can be copied from the ERD
    • Export to images and SVG was fixed
    • Drag-n-drop was improved
  • Search in query history was added
  • Database-specific improvements:
    • Postgres:
      • stored procedures debugger was added
      • permissions editor was significantly improved
      • active schema switch was redesigned
      • a lot of metadata read/edit functions were added
      • PostgreSQL v10 support was improved
    • MySQL: MySQL v8 support was added.
    • MariaDB: packages support was added
    • Oracle:
      • JDBC driver version was upgraded to 12g
      • expired password change support was added
      • timezone support was added
      • jobs scheduling was added
      • PL/SQL parser was improved
      • error position detection was improved
      • metadata read was improved
    • SQL Server: metadata read/edit was improved
    • MongoDB:
      • JSON renderer was improved
      • date/time attributes renderer was fixed
    • Cassandra:
      • Support for complex data types was added: text columns viewer, collections of complex types, tuple types support, UDT support
      • materialized view DDL was added
      • error position detection was added
    • Vertica:
      • table columns editor was added
      • metadata reading was improved
    • DB2: table columns editor was added
    • Redshift, Firebird: driver version was updated

DBeaver EE 5.0

March 12 2018

DBeaver EE 5.0 is the first major Enterprise version release. Tons of bugfixes and improvements oriented on enterprise customers were made. A few extra enterprise databases were added in the list.

  • New features
    • Mockdata generator (EE version bundled with advanced generators).
    • Referencing foreign keys navigation in results viewer
    • JOINs auto-complete in SQL editor
    • Git integration (using external Eclipse Git plugin)
  • General improvements
    • Chinese, German, French and Russian localizations were significantly improved. UI language can be changed in preferences
    • Icons were replaced with new custom DBeaver icon set
    • HighDPI monitors support has been improved
    • Some keyboard shortcuts were fixed (conflicts with MacOS/Linux OS shortcuts)
    • Auto-reconnect feature has been added (optional, can be configured in preferences)
    • SQL editor: extra warnings, stored procedures quick execute, syntax highlighting and other features were added
    • Connection properties dialog was improved
    • Results viewer has been improved (grid and plaintext UI renderer, UI, data types coloring)
    • Foreign keys/references navigation was improved
    • A lot of small UI fixes was added
  • Database specific
    • GIS (geometry) data types support was added to MySQL, MariaDB and PostgreSQL
    • Ref cursors support was fixed for PostgreSQL and Oracle.
    • Objects DDL generate was improved in Oracle, PostgreSQL and MySQL
    • Extra metadata objects support was added for PostgreSQL, MySQL, MariaDB, Oracle, HANA, Firebird
    • PostgreSQL: role permission management was implemented
    • MS SQL and Sybase : schema/tables list reading was fixed (including older SQL Server versions)
    • MS SQL: modern Microsoft driver was added
    • Sybase/SAP ASE: native jConnect driver configuration was added
    • Vertica: extra features support was added (flex tables, projections), driver is bundled in distribution.
    • Firebird: Jaybird 3.0 driver support was added
    • Snowflake extension has been added
    • MongoDB: multiple bugfixes, datetime data type support was improved
    • Cassandra: list, set and map data types support was improved. Driver TCP/IP configuration was added.
    • A lof of small db-specific bugfixes and improvements

DBeaver EE 4.3

December 11 2017

DBeaver EE version 4.3 is the first real Enterprise version. We are thankful to everyone who have bought DBeaver licenses and thus supported our development efforts. And we are really inspired by the multiple things that we can do for the product thanks to the Enterprise version.

When working on this release, we mostly concentrated on the standard workflow for big customers and attempted to simplify the integration process of DBeaver to a corporate environment.

Here are the main features that were added to DBeaver version 4.3:

  • All major database drivers included in distribution: Oracle, DB2, MySQL, PostgreSQL, Vertica, CSV, Derby, Firebird, H2, Apache Hive, HSQLDB, Informix, SQL Server, Sybase, ODBC, MS Access
  • MacOS X installer (PKG)
  • no need to setup Java any more
  • Eclipse plugin version
  • DBeaver now based on the most recent Eclipse 4.7 platform
  • Java 9 support
  • Office integration: opening query results directly in Excel/Calc
  • Vertica extension: support of native Vertica metadata model
  • Configuration of new drivers: OrientDB, Neo4j, Solr, Cloudera Impala, CUBRID, PrestoDB
  • Chinese, Russian and German localizations fixed and added back to default distribution
  • Improved HighDPI monitors support
  • Fixed connectivity problems for Mongo DB: SSH tunnels, replica sets, etc.
  • Fixed key browser in the multi-database mode for Redis
  • Major changes for results viewer:
    • Referencing tables navigation
    • Viewer zoom support
    • Data types coloring
  • Improved multi-cell copy-paste support
  • ERD: diagrams custom coloring, export in SVG format
  • Many fixes and improvements in SQL auto-complete, auto-format and specific dialects support
  • Major user interface improvements
  • A lot of minor UI fixes

DBeaver EE 4.2

September 10 2017
  • Sample database (SQLite) is included in DBeaver distribution
  • Oracle, DB2, MySQL, PostgreSQL and Vertica drivers are included in DBeaver distribution
  • Results viewer: save filters settings for each table
  • Results viewer: columns reordering with drag-n-drop
  • Results viewer: open in Excel
  • Results viewer: dark theme support was improved
  • Results viewer: copy column names/row numbers configuration
  • Custom (named) object filters support was added
  • SQL editor: variables support was fixed (global vars)
  • SQL editor: quoted identifiers support was improved
  • ERD: bring to front/send to back, notes coloring
  • ERD: export in SVG
  • SQL editor: delimiters transform utility
  • Database navigator: additional view customisation
  • Full-text search processor was fixed (fail on first error)
  • MySQL: local client detection was fixed, multiple metadata reading fixes
  • PostgreSQL: XML values view/edit were fixed
  • PostgreSQL: SSL configuration was fixed
  • PostgreSQL: access methods/operators metadata support was added
  • PostgreSQL: database dump wizard was improved
  • Exasol: object comments support was improved, DEFINE command support was added
  • SQL Server: support of [] quotes
  • Informix: active database change was added
  • Informix: metadata reading was fixed and improved
  • Redshift: driver version was updated
  • Drivers download was fixed
  • EE version Windows installer was fixed
  • A number of minor UI bugs (including UI freeze issues) were fixed