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

    DBeaver 5.3.3

    • Connection wizard was completely redesigned.
    • Database driver icons were updated.
    • “Tip of the day” dialog was redesigned, tips were added
    • SQL editor:
      • Parameters binding was improved
      • @set command now supports variables
    • Data transfer:
      • Tables/columns mapping UI was enhanced
      • Auto-mapping button was added
      • Summary page was redesigned
    • ERD: attributes visibility configuration was fixed
    • SQL Server:
      • Active directory and Kerberos authentication were added
      • Server sessions/connections manager was added
      • Error position highlighting was added
      • Auto-completion and object search was fixed
      • Schema list reading was fixed
      • Views, triggers and stored procedures editor was added
      • Foreign key navigation was fixed
      • Metadata read was improved
    • Sybase: stored procedures reading was fixed
    • Greenplum:
      • External tables browser was added
      • Greenplum-specific tables DDL was added
    • PostgreSQL:
      • Problem with RDS/SSL connections was resolved
      • Data types reading was fixed
      • Extra tables and indexes statistics was added
      • Debugger break-point toggle command was fixed
    • Exasol: comments edit support was added
    • SQLite: metadata editor was fixed
    • MS Access: metadata reading was fixed
    • CSV: export/import settings save/load was fixed
    • SAP HANA: native table DDL reading was added
    • Dark theme: data editor colors were fixed
    • Windows installer now supports silent instalation (/S and /D flags
    • see WIKI)
    • Unexpected editors “modified” mark was removed (Linux Mint)
    • CSV: export/import settings save/load was fixed
    • Older Eclipse (Mars) now supported by plugin version
    • Object delete confirmation message was fixed
    • Dangerous confirmation popups were removed
    • Workspace switching (from menu) was fixed
    • Numerous localization bugs were fixed
    • Many minor UI bugfixes
    Posted in Releases

    DBeaver 5.3.2

    • Data editor:
      • Open With menu was added (web browser and Excel)
      • Next page auto-fetch was fixed
    • UUID/GUID generate function was added
    • ERD:
      • Save as picture function was fixed (case-insensitive file path)
      • Attributes visibility configuration was improved
    • Data transfer: “truncate target table before load” function was fixed
    • SQL editor:
      • Parameters biding dialog + results scrolling glitch was fixed
      • Glitch with first time reading of proposal was fixed
      • Stored procedure auto-completion was fixed
      • Syntax coloring: Color Themes support was fixed
    • SQL Server:
      • Default schema detection was fixed
      • Column data type resolution was fixed
      • Identifiers auto-completion was fixed
      • NVarchar(MAX) data type resolution was fixed
    • Exasol:
      • Exasol V6.1 support was added
      • Metadata reading performance was significantly improved
      • Partitions information was added
      • Security management was improved (roles, priority groups, policies, etc)
    • PostgreSQL:
      • Rules support was added (read-only)
      • Stored procedures (PostgreSQL 11) support was added
      • Aggregate functions meta information support was added
      • Database tablespace edit support was added
      • Reserved keywords update was added
    • Greenplum:
      • External table DDL generation fixes were added
    • Redshift: column encoding information was added
    • Oracle: PS/SQL blocks parser was fixed
    • Huge code refactoring was made (separation of model and UI plugins)
    • Many minor UI bugfixes
    Posted in Releases

    DBeaver 5.3.1

    Merry X-Mas everyone!

    DBeaver 5.3.1 release notes:

    • Java 11 support was added
    • Data transfer: saving for tables/columns mappings was added
    • Extensions installation/update were fixed on Windows (infinite restart loop)
    • Object editor:
      • Actions toolbar UI was fixed
      • Expand/collapse actions for all list items were added
      • Foreign key creation dialog was fixed
    • Data editor:
      • Dictionary value viewer/editor was fixed (null values, SQLite foreign keys)
      • Tooltips for foreign key links were added
      • Shortcuts for data view panels were added (customizable)
      • Results pagination now supports full data refresh (configurable)
      • Grid columns width calculation was fixed
    • SQL editor:
      • Query timing was fixed
    • Linked files/folders rename was fixed
    • PostgreSQL:
      • UI for active database switching was improved
      • Interval data type support was improved
      • Database backup was fixed (schema name quote)
      • Support for table triggers comment view/edit was added
    • Greenplum:
      • Tables DDL show GP-specific options now
      • Partition tables view was fixed
    • DB2 z/OS: views definition reading was added
    • Sybase/SAP ASE/SQL Anywhere: stored procedure list reading was fixed
    • Vertica: projection columns comments view/edit support was added
    • MonetDB: driver configuration was added
    • Many minor UI bugfixes
    Posted in Releases