DBeaver 6.2.2

  • Task management: now all data transfer operations (export/import) can be saved as tasks:
    • New task management view
    • Running saved tasks in two clicks
    • Task execution logs
  • Data transfer:
    • Output file names were fixed
    • Previous wizard settings save was fixed
    • Many minor improvements
  • Virtual table columns:
    • Supported for all tables and views
    • Supports expressions, math functions and geometry transformation functions
  • Virtual foreign keys config save/copy was fixed
  • Data viewer:
    • Hex viewer was added for string content
    • Long CLOB text viewer was fixed
    • Filter dialog was fixed (orderings, distinct value reading)
  • SQL editor: parameters binding was improved:
    • Show dialog before script execution
    • Show current query text
  • Object editor: new command for expensive properties (row count) reading
  • SAP HANA
  • new extension developed (thanks to @kai-morich):
    • Driver auto-download
    • Sequences, synonyms, triggers
    • SQL execution plan
    • Object searcher
  • H2GIS: spatial data viewer was added
  • Redshift: stored procedures support was added
  • Yellowbrick: driver config was fixed for better performance
  • Oracle: view column comments edit support was added
  • A lot of minor UI fixes
Posted in Releases

DBeaver 6.2.1

Release notes:

  • Data viewer:
    • Spatial (GIS) presentation improved (tooltips, different shape colors for different columns)
    • JSON render performance was significantly improved
    • XML value viewer was fixed (proper error handle)
    • XML auto-formatting was fixed (extra whitespaces)
    • Context menu “Navigate” was added (returned)
    • Floating numbers representation was fixed (exponential view)
    • Columns transformation settings dialog was fixed
  • SQL Editor: update row count calculation was fixed
  • MySQL: date/time formatting was fixed
  • PostgreSQL: 3D geometry columns render was fixed
  • SQL Server: problem with identifiers with “go” characters was fixed
  • Oracle: SQL parser was fixed (CASE WHEN ELSE END)
  • Connection settings:
    • Load multiple data-sources*.json files
    • Respect preference changes (timeouts and other) in “Test Connection” dialog.
    • Project export/import wizard was fixed
  • Database metadata search wizard was fixed
  • New database drivers:
    • H2GIS
    • Kognitio
    • Opendistro (Elasticsearch)
  • A lot of other minor UI bugs were fixed
Posted in Releases

DBeaver 6.2

  • 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

  • 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

  • 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