DBeaver 6.1.4

  • Many problems with workspace migration were fixed
  • Data viewer:
    • UI look and feel was significantly improved
    • New interface for rows/columns coloring
    • Logical foreign key creation was simplified
    • Many bugs were fixed in References panel rendering
    • Column filters UI was fixed (dups, dictionary reading errors)
    • Unique key detection was fixed (use indexes with nullable columns if no other identifiers found)
  • Entiy diagrams: logical foreign keys can be created/deleted right in the diagram editor
  • Data transfer: auto-generated (identity) columns handler was added
  • DDL generation: now we generate tables DDL according to their foreign keys order
  • Geometry viewer: simple (flat) geometry support was added
  • Execution log: reading of row count for DML statements was fixed
  • SQL Editor:
    • SQL formatter was fixed (DECLARE statements)
    • Copy SQL to Java code was improved (thanks to loro2)
  • PostgreSQL:
    • Array data type handler was fixed
    • Indexes metadata reading was fixed
    • Execution plan visualization was fixed for CTE nodes
  • SQL Server:
    • Support of identity columns creation was added
    • Session manager was fixed
  • Oracle:
    • Scheduled jobs metadata reading was fixed
    • Session management was fixed for RAC mode
  • Firebird: views and indexes metadata reading was fixed
  • Apache Hive: many bugfixes related to complex (struct/array) data types handling
  • Apache Drill: driver was fixed (missing JDK modules were added)
  • Many other minor UI bugs were fixed
Posted in Releases

DBeaver 6.1.3

  • New project configuration format was implemented. Main advantages:
    • Better security (now we keep user credentials separately)
    • Better support for version control systems (e.g. Git)
    • Now we use standard (OS-specific) directories for configuration location
  • Major features:
    • Logical foreign keys
    • Data viewer: “References” panel was added (browse values by foreign and reference keys)
    • Network profiles support was added: you may configure SSH/Proxy settings once and reuse them for any number of connections
  • Other:
    • Connection page was redesigned
    • Data viewer filter panel UI was improved
    • Snowflake: procedures DDL, connection page fix
    • Google Spanned database support was added
    • PostgreSQL: struct/array data types support was fixed
    • MySQL: privileges viewer was fixed (global privileges grant/revoke)
    • DB2 i: procedure list and DDL reading was fixed
    • Many minor UI bugs were fixed
Posted in Releases

DBeaver 6.1.2

  • Git integration:
    • Create projects in remote repositories
    • Pull/commit/push automation from the DBeaver perspective
    • Integrate existing projectys with Git repositories
  • Problem with SSH and SSL connections was solved
  • Problem with missing legacy character encoding was fixed
  • Data editor:
    • “Delete cascade” feature was added
    • Problem with column order was fixed (when result contains multiple columns with the same name)
    • Problem with duplicated values in column filters was fixed
    • “Default” values were added for numbers, strings and booleans
  • Data transfer:
    • Export to a single file was fixed
    • TXT format: extra options were added
    • CSV import: timestamp columns parser was fixed
  • PostgeSQL:
    • Extensions management was added
    • Partitions DDL was added
    • Partitions create/drop support was added
    • Object description reading was fixed (+ problem with duplicated objects was solved)
    • Complex data types rendering was fixed
    • float4 data type support was fixed (wrong value render)
  • Greenplum: ERD renderer was fixed
  • Oracle:
    • Problem with read-only tables was fixed (for some Oracle versions)
    • View management: problem with semicolons was fixed
  • DB2 for iSeries:
    • Procedures DDL was added
    • Problem with schema list reading was fixed
  • Generic driver (SQLite and others): problem with view create command was fixed
  • Plenty of minor UI bugs were fixed
Posted in Releases

DBeaver 6.1.1

  • We have migrated to Java11 (Windows and MacOS bundled JRE is OpenJDK 11.0.3)
  • ERD: diagram refresh fixed (do not re-layout elements)
  • ERD: support of zoom with mouse wheel was added
  • PostgreSQL: ref cursor data type support was fixed
  • Oracle: bootstrap queries execute was fixed
  • DB2 for iSeries, DB2 for z/OS: schema list reading was fixed
  • SQLite: datetime columns support was fixed
  • SAP HANA: triggers support was added (read-only)
  • Data views: calc panel was fixed (min/max functions evaluation)
Posted in Releases

DBeaver 6.1

New intermediate DBeaver release 6.1.
A lot of performance improvements for data transfer and XLSX format export.
Stable release of geo spatial data viewer, many UI improvements and bug fixes.
  • Data viewer:
    • Spreadsheet column-based coloring support was added
    • Copy as HTML now uses html clipboard format
    • Focus loss bug was fixed (MacOS)
  • Data transfer:
    • Export to XLSX format: performance was greatly improved
    • Table truncate confirmation was added
    • Plaintext export was fixed (datetime data types formatting)
  • SQL editor:
    • SQL execution plan save/load support was added
    • Bug with keywords in comments was fixed
    • Active connection/schema selectors were fixed in the main/context menus
    • Workbench/J formatter was fixed
  • ERD diagram: Dark theme support was improved
  • Database navigator:
    • New object create context menu redesigned
    • Duplicated nodes bug was fixed
  • Spatial viewer:
    • Coordinates inversion was fixed (MySQL)
    • Column SRID and coordinates flip settings are now saved between sessions
  • Oracle:
    • Constraints metadata reading was fixed (fixes table editor as well)
    • Indexes DDL reading was added
  • PostgreSQL:
    • Backup of “quoted” schemas and tables was fixed
    • Functions’ dependencies information was added
    • Struct data types parser was fixed (boolean fields extraction)
  • MySQL:
    • BEGIN keyword handler was fixed
    • View DDL was fixed (extra delimiters)
  • SQL Server: drop index qury was fixed
  • Eclipse plugin installer was fixed (missed bundles)
  • Many minor UI bug fixes
Posted in Releases

DBeaver 6.0.5

  • Database navigator:
    • Create object menu was improved (no redundant sub-menu)
    • Connection folders creation was fixed
    • Elements coloring was improved (for different connection types)
    • Shortcuts processing was fixed (broken shortcuts after some actions)
    • Table editor tabs activation was fixed
  • Columns editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
    • Geography/geometry value editor (plaintext, WKT)
    • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
    • Multiple query result sets support was added
    • Table partitions information was extended
    • Native database backup was fixed
    • Database creation was fixed (special characters in db name)
    • Sequence rename was fixed
    • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
  • Many minor UI bug fixes
Posted in Releases

DBeaver 6.0.4

  • Data editor:
    • Value transformers for custom queries and pseudo columns
    • Advanced data coloring configuration
    • Logical entity structure editor
    • Gradient colors for numerical/datetime columns
    • Navigate to FK/references: multiple rows support
    • Extra shortcuts were added
  • Spatial (GIS) viewer:
    • CRS (SRID) transformations support was added
    • Inverted coordinates support was added
    • Support of geography data type was added
    • Support of curved geometries was added
    • Open map in browser command
    • Maximum geometry objects limitation was added
    • Numerous bug fixes (tooltips, actions)
  • SQL editor:
    • Indentation was fixed (keyword-based indents were disabled)
    • Process @set commands in data export
    • “Format” context menu was fixed
  • Schema selector toolbar was fixed (missing database name)
  • Global native clients configuration was added
  • Shortcuts for connection/schema selectors were fixed
  • PostgreSQL:
    • Full schema DDL generation was added
    • Function create was fixed (function body)
    • Trigger create support was added
    • Columns DDL was added
  • MySQL: query metadata extraction was fixed (bug with wrong database name)
  • Oracle: metadata reading was fixed
  • SQL Server:
    • Procedures auto-completion was fixed
    • Support of older Azure versions was added
  • Redshift: external tables (spectrum) data reading was fixed
  • Clickhouse additional array data type support was added
  • Korean localization was added (thanks to Seongbae Chang)
  • Many minor UI bug fixes
Posted in Releases

DBeaver 6.0.3

  • Connection/schema selector toolbar was redesigned
  • Create object context menu was redesigned
  • Data viewer:
    • Panels UI was redesigned
    • “Copy As” command was added (CSV, HTML, JSON, etc)
    • IN filter UI was improved (previous selection save)
    • Statistics view was improved (proper view of multiline queries)
  • SQL editor: auto-indent was fixed
  • GIS spatial data viewer beta version (PostgreSQL, MySQL/MariaDB):
    • Viewer panel was redesigned, special results presentation was added
    • Multiple objects viewing support was added
    • Copy/save as picture, print, SRID selector
  • Data transfer:
    • Export progress monitoring was fixed
    • Export from custom SQL queries performance was improved (using fetch size)
    • Split output file feature was added
  • Reset UI settings menu item was added
  • Backup/restore wizards: native client configuration was added in the dialog
  • MacOS X installer was updated (JRE version update)
  • PostgreSQL:
    • Schema/tables backup wizard was fixed
    • Triggers enable/disable tool was added
    • Greenplum: tables reading for GP 4.x was fixed
  • SQL Server:
    • Use TOP to limit queries fetch size
    • Dynamic parameters binding bug was fixed
    • Table triggers enable/disable tool was added
    • Support of special characters in object names was added
  • Oracle:
    • New config option for metadata reading performance fix
    • Subpartitions browser was added
    • PL/SQL blocks parser was improved
    • Configuration of system views usage was added
    • DDL reading was fixed (problem with string truncate with some driver versions)
  • Many minor UI bug fixes
Posted in Releases

DBeaver 6.0.2

  • Eclipse 2019-03 is now the default platform
  • Embedded editor activation problem fixed (Linux)
  • SQL editor:
    • SQL errors now shown in results panel instead of modal dialog (configurable)
    • Certain long strings visibility problem was fixed
    • Auto completion was fixed for CALL/EXEC keywords
    • Tables/schemas were removed from columns proposals
    • Context menu was improved (redundant items were removed)
    • Numerous NPE errors were fixed
    • Multi-statements scripts formatter was improved (adding statement delimiters)
    • Database-specific named parameters prefix was added
    • SQL formatting was fixed
    • Morph delimited list formatter was fixed (spaces in tokens)
  • Data editor:
    • Unnecessary focus changing was fixed
    • Calc panel: strings/numbers aggregation toggle was added
  • Data transfer: fetch size was added in export settings (may significantly improve performance)
  • ERD (custom diagrams):
    • Additional styles were added for notes (colors, transparency, border, font settings)
    • Notes now can be connected with entities
  • Dashboards:
    • Timeseries dashboards rendering was fixed.
    • New dashboards extraction model was added (statistics reading by intervals)
    • Exasol dashboards were added
  • PostgreSQL:
    • Alpha version of GIS/spatial data viewer (maps) was added
    • Explain for queries with parameters was fixed
    • Database description reading was fixed (PG < 9.4)
  • Greenplum: tables reading for GP 4.x was fixed
  • Oracle:
    • Public synonyms in auto-completion
    • Session manager now shows instance ID (for clusters)
  • MySQL/MariaDB:
    • New database dialog now uses server charset/collation defaults
    • Native client was updated (problems with dump/restore compatibility)
  • MS SQL Server/Azure: driver version was updated, support of AD MSI authentication was added
  • Elasticsearch: metadata reading was fixed (schema/table names escaping)
  • Pervasive SQL driver configuration was added
  • MySQL NDB cluster driver configuration was added
  • Google BigQuery driver was updated
  • Numerous localization bugs were fixed
  • Many minor UI bug fixes
Posted in Releases

DBeaver 6.0.1

  • Eclipse 2018-12 is now the default platform
  • 32-bit versions were obsoleted
  • Charts colors configuration
  • Navigator resource folders visibility configuration
  • Mock data: new random texts generators were added
  • Data editor: inline editor focus handler was fixed
  • Plaintext format: show Western European characters
  • Data transfer: new connection close fix
  • Snowflake: tables and columns comments edit support was added
  • Oracle:
    • Session manager now tracks global sessions (RAC)
    • Procedures/packages save/compile command was fixed
  • PostgreSQL:
    • Multi-tenant databases support was improved
    • Database description reading was added
  • MySQL: execution plan build fix
Posted in Releases