DBeaver 6.2

Posted on by Serge
  • Data viewer:
    • JSON highlighting/formatting was added
    • Select/deselect rows with alt+click was improved
    • Reference panel now supports virtual foreign keys
    • “Set to default value” action was fixed (for timestamp columns)
    • Dictionary read was fixed
  • ERD:
    • Table/schema diagram edit is now supported
    • Virtual foreign keys support was added
  • Database navigator:
    • Transactions tracking was improved (+now commit/rollback actions are always active)
    • Cross-project connections copy-paste and drag-n-drop was fixed
    • Navigator tree state save (and restore on restart) was added (thanks to loro2)
    • Columns reordering was fixed
    • Global filters configuration was fixed
    • Connection permissions are now supported in connection type (prod, dev, test)
  • SQL editor:
    • Query execution time logging was fixed
    • Generate SQL dialog was improved (FQ names, copy to clipboard)
    • Script selector panel UI was fixed
    • Variables binding now can be skipped for a query/script
    • JDBC fetch size now set for custom SQL queries
  • Data export now reuses SQL editor connection
  • Metadata editor: columns drop was fixed
  • SQL Server:
    • NVARCHAR/NCHAR length calculation was fixed
    • Column default value edit support was added
    • DDL for TEXT/NTEXT data types was fixed
  • PostgreSQL:
    • Driver now uses URL template (by default)
    • Column comments for new tables now saved properly
  • SQL Server Data Warehouse support was added
  • MySQL: bit stream data type support was fixed
  • CockroachDB: table metadata read was fixed
  • Apache Derby driver was upgraded
  • Teradata: multiple resultsets support was added
  • Test connection dialog was redesigned
  • Driver libraries cache was fixed (re-download of Maven artifacts)
  • Widows registry reading was fixed (Java 8 compatibility)
  • Many other minor bugs were fixed
Posted in Releases

DBeaver 6.1.5

Posted on by Serge
  • Data viewer:
    • Virtual primary/foreign keys editors were enhanced
    • Problem with filters on data refresh was fixed
    • Added confirmation dialog before opened result tabs closing
    • Problem with missing updated row count (in script mode) was fixed
    • References panel now remembers last FK/reference selection
    • Value view panel now supports Find/Replace
    • Float values rendering was fixed (numbers rounding is disabled by default)
  • Data transfer:
    • Save of previous target container selections was added
    • Export of tables/queries with complex data types (structs, objects) was improved
  • Connection management:
    • Connection permissions config was added (restrictions of data/metadata changes for a particular connection or connection type)
    • Problem with bootstrap queries and auto-commit state save/load was fixed
    • Multi-project support was improved (use selected project for new connections)
    • Support of empty database passwords was added
    • Copy/paste and drag-n-drop connections between different projects was fixed
  • Database navigator:
    • Default double-click behavior configuration was added (view properties/data/erd)
    • Object edit dialogs are properly sized now (problem with too small dialog window was fixed)
    • Connection type coloring in the main toolbar is back
    • DBeaver toolbars visibility was fixed (for Eclipse plugin version)
  • New DBeaver version automatic downloading (optional) was added
  • MySQL:
    • Datetime columns edit was fixed. Problems with timezone were fixed.
    • Legacy MySQL <4 driver was added (again)
  • PostgreSQL:
    • Automatic transaction error recovery was added (famous “current transaction is aborted” error)
    • Partition management was added (partition create/drop)
    • Support of VACUUM tool for older PG version was fixed
    • Enum items order was fixed (in metadata editor)
    • Legacy PostgreSQL <= 8 driver was added
  • SQL Server: index DDL was improved (now it contains all index properties)
  • Redshift: table DDL generation was fixed (“diststyle AUTO” and other improvements)
  • Hive: struct/array data types support was added
  • Presto: array data types support was fixed
  • DB2 i: routine list reading was fixed
  • We have migrated to the Eclipse 2019-06 platform (fixes many minor UI bugs on Linux)
  • Many other minor bugs were fixed
Posted in Releases

DBeaver 6.1.4

Posted on by Serge
  • 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

Posted on by Serge
  • 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

Posted on by Serge
  • 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

Posted on by Serge
  • 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

Posted on by Serge
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

Posted on by Serge
  • 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

Posted on by Serge
  • 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

Posted on by Serge
  • 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