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

DBeaver 6.0

DBeaver 6.0 is our new major release.

  • Changes since 5.0:
    • Added support for different cloud databases in AWS and Azure,
    • Significantly improved support for PostgreSQL and SQL Server
    • Increased number supported drivers to more than 70.
    • Renovated connection wizard and data migration tools.
    • Added analytical panels, customizable dashboards, mock data generators, SQL debugger.
    • Modernized UI, significantly improved dark theme support
    • Closed more than 1600 issues on GitHub.
    • And a lot of other things
      Thank you for your support!
  • Changes since 5.3.5:
    • Navigator:
      • Filters were fixed for multi-database drivers (PostgreSQL, SQL Server)
      • Folders management was improved (move, drag-n-drop, etc)
      • Scripts ordering was fixed
    • Data view:
      • Multiple cells editor was fixed (performance)
      • Plain text presentation was improved
      • Context menus were fixed
    • PostgreSQL:
      • Views dependencies tab was added
      • Composite data types rendering and editing was fixed
      • GIS data types rendering was fixed
      • Table columns collation support was added
      • Geometry type and SRID are shown in DDL
      • Support of triggers delete was added
    • SQL Server:
      • Tables DDL generation was improved
      • Column default values render was fixed
    • Sybase procedures loading was fixed
    • BigQuery: error position discovery was added
    • Generic driver: JDBC URL
    • Dashboards rendering was fixed
    • ERD: rendering was fixed (IDEF1X compatibility)
    • Tools editor opening was fixed (sessions, locks)
    • CSV import: support of custom data/tme format was added
    • SQL editor colors were updated for dark theme
    • Multiple shortcuts were fixed
    • CrateDB driver was added
    • Elasticsearch driver was fixed (6.6 compatibility)
    • Some icons in UI were updated
    • A lot of minor UI fixes
  • Posted in Releases

    DBeaver 5.3.5

    • Database health monitoring dashboards were added (for PostgreSQL, MySQL and MariaDB)
    • Bookmarks: navigate to object action was added
    • Content editor (XML, JSON): contents formatting was added (Ctrl+Shift+F)
    • Charts: copy image to clipboard action was added
    • SQL editor:
      • Morph to delimited text action was fixed (spaces processing)
      • Delete file action was added in tab context menu
      • Intelligent bracket auto-close was improved
      • Variables resolution was fixed (mixed letters case)
      • Script Save As in non-UTF encoding was fixed
      • Files delete: keep local history by default
      • Statistics panel rendering was fixed
    • Data editor:
      • JSON auto-format was fixed (null values)
      • Standalone editor of NULL values was fixed
      • Date-time editor in native format was fixed
      • Plaintext renderer was fixed (extra spaces)
    • SSH tunnel: keyboard-interactive AND publickey auth support was added
    • Open resources in embedded text editor support was added
    • Dark theme support was improved
    • Tips of the day dialog font was fixed (HighDPI)
    • PostgreSQL:
      • Arrays editor was fixed (new array create)
      • Indexes statistics was fixed (rel size)
      • Table dependencies info was added
    • SQL Server:
      • SQL errors processing was fixed (error inside stored procedures)
    • Oracle:
      • Objects search was fixed (synonyms resolution)
      • Procedures/packages compile was fixed (trailing delimiter, log error position)
    • CockroachDB:
      • Database schema browser was fixed (aggregate functions, rules)
      • Permissions reading was fixed (CRDB style)
    • MySQL: database dump without DROP statement option was fixed
    • Firebird: sequences metadata reading was fixed
    • Sybase:
      • Stored procedure reading was fixed (multiple databases)
      • Query processing was fixed (trailing semicolon issue)
      • Synonyms tab removed
    • Many minor UI bugfixes
    Posted in Releases

    DBeaver 5.3.4

    • Data viewer:
      • New UI for view switching (grid/text, record)
      • Columns search was added in data filter settings
      • Numeric data types rendering was fixed
      • Plaintext mode renderer was fixed
    • SQL Editor:
      • Action toolbar design was improved
      • Context menu was simplified
      • “Find paired bracket” command was added
    • Databse navigator: double-click behavior config was fixed
    • Quick object search dialog UI redesign (object types selector)
    • Data transfer:
      • Export from multiple SQL queries was added
      • Export into single file from multiple tables was added
      • Target file name generation was improved
    • Transaction log: history loading was fixed
    • Dark theme support was improved
    • Optional extensions install was fixed (Eclipse 2018-09 support)
    • Stored procedures calling was fixed for most databases
    • Auto-completion was added to selector controls (comboboxes)
    • New databases:
      • Apache Ignite driver was added
      • MapD (OmniSci) driver was added
      • Dremio database driver was added
    • PostgreSQL: sequences DDL was fixed
    • Greenplum: (thanks to GP team)
      • External tables create/edit support was added
      • GP functions DDL was improved
    • SQL Server: better support of SQL Server 2008 and earlier
    • Oracle: materialized view create/edit/refresh was added
    • DB2 iSeries: driver config was fixed (object descriptions read enabled)
    • SQLite: table DDL reading was fixed (indexes)
    • Eclipse plugin: older Eclipse versions (4.4-4.6) support was fixed
    • Interface localization was improved
    • Many minor UI bugfixes
    Posted in Releases