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

    DBeaver 5.3

    DBeaver 5.3 is ready. Mostly it is a bugfix or “stabilizing” release so there were no new major features.
    Changelist:

    • Data editor:
      • Dictionary tables lookup/search was added
      • Grouping panel now supports different presentations
      • Unpin all tabs command was added
    • SQL editor:
      • Auto-completion algorithm was improved
      • SQL formatter was improved (UPDATE, BEGIN/END)
      • Multi-tab context menu was fixed
    • Connection wizard: settings page UI was redesigned
    • Foreign key creation dialog: unique indexes usage was added
    • SQL processing: LIMIT usage was fixed
    • Connection ping (keep-alive) was improved (ping CALLED only during idle periods)
    • FireBird: SQL execution plan analyzer was added (thanks to tomas303)
    • SQL Server:
      • Database objects search was fixed
      • Metadata reading (unique keys) was fixed
      • Table comments editor was fixed
      • DateTimeOffset data type support was fixed
      • New extension requires Microsoft driver only
    • Oracle:
      • Timestamp handling was fixed (for some Oracle server versions)
    • PostgreSQL:
      • Non-default databases are disabled by default
      • Native psql invocation was fixed (for old PG versions)
    • CSV files: columns and foreign keys reading was fixed
    • H2: embedded database shutdown procedure was fixed
    • A lot of minor fixes in UI and metadata processing
    Posted in Releases

    DBeaver 5.2.5

    • SQL Server (MSSQL) database extension was added:
      • Native SQL Server metadata
      • Table/columns/indexes/constraints editor
      • View/edit objects’ comments
    • Connection invalidate/reconnect action was redesigned (now forces reconnect always)
    • Data viewer:
      • Cell rendering was fixed in the plaintext view
      • Data save/reject key bindings were fixed
      • Support of right align for numbers and dates in plaintext view was added
    • SQL editor:
      • Tabs management was redesigned (now all tabs are pinnable and closeable)
      • SQL completion was significantly improved/fixed
      • Additional configuration for SQL formatter
    • Object editor:
      • Problem with “jumping” focus was fixed
      • Links rendering was fixed
      • Checkboxes are now grouped together
    • Data transfer: problem with multiple tables mappings was fixed
    • Read-only connections now restrict metadata edit
    • Driver properties editor UI was improved (password properties masking)
    • Project explorer UI was fixed (header column sizes)
    • PostgreSQL:
      • View and functions rename support was added
      • PostGIS support improved (now supports creation of new geometry values)
      • Data type DDL was added
      • Functions DDL was improved (comments)
      • JDBC driver default version changed to 42.2.5
    • MySQL:
      • Multiple/excluding schema filters were fixed
      • Presto: table elements reading was fixed (performance)
      • DB2 z/OS: driver config was fixed (foreign keys reading)
      • A lot of minor UI fixes
    Posted in Releases

    DBeaver 5.2.4

    • Results viewer:
      • Ordering confirmation config was fixed (issue with “unsortable” results fixed)
      • Toolbars layout was changed
      • Grid presentation: columns width stretching (fit screen/value) commands were added
      • Plaintext presentation: tabs support was fixed
    • SQL editor:
      • Associated connection info can be placed in the first line of script (can be shared between different users)
      • Unnecessary objects information reading was disabled (completion performance was greatly improved)
      • Auto-completion was fixed (identifier replacement)
      • Use different syntax for store functions and procedures invocation
      • Fix for the “Search inside names” option support
    • Object editor:
      • Property editor form was redesigned/fixed
      • Glitch with jumping cursor fixed
      • Grid visibility config was added
    • Read-only connections detection was fixed
    • Light theme is now default DBeaver theme (instead of Classic)
    • Preferences pages were reorganized. SQL scripts processing pref page was added.
    • Driver selection page: new design (optional)
    • Linked folder/file handling was fixed (do not delete broken links)
    • Data transfer wizard: progress monitor was fixed
    • Greenplum:
      • Functions header/footer was added to DDL
      • Table DDL generation was enhanced
    • SQL Server: procedure names fixed in auto-completion
    • AWS Athena: connection page was fixed
    • ORacle: do not use DBA_* views by default
    • Mock data generation wizard was improved:
      • Possibility to skip columns
      • Column generator settings save/load was fixed
      • Skip auto-generated columns by default
    • Darkest Dark theme support was fixed
    • German language localization update (thanks to Bullnados)
    • Chinese language localization update (thanks to fengchao)
    • Maven configuration was redesigned (now Maven project nature can be used in Eclipse)
    • A lot of minor UI fixes
    Posted in Releases

    DBeaver 5.2.3

    • Object (tables, columns, etc) editor was redesigned
    • Statistics/misc tab was added to object editors
    • Data transfer supports document-oriented databases now
    • Table rename procedure is available from the table editor (MySQL, PG, Oracle, DB2)
    • Long operations canceling was fixed
    • “Tip of the day” popup was added
    • Java 11 support was added
    • Azure SQL driver was added
    • AWS Athena support was significantly improved
    • AWS Redshift:
      • Spectrum and external tables support was added
      • Columns and foreign keys metadata reading was fixed
    • Cockroach: foreign keys reading was fixed (for ERD)
    • Vertica: performance for data reading from big tables was improved
    • PostgreSQL: support transactions in tools (Truncate and others) was added
    • Oracle: TIMESTAMPTZ and TIMESTAMPLTZ data types support was fixed
    • Greenplum: session manager was added
    • SQL Server: sequences info reading was fixed
    • Clickhouse: GROUP BY/ORDER BY functions in grouping panel were fixed
    • Eclipse 2018-09 is now the default platform.
    • Extra command line parameters were added
    • German and Russian localizations were significantly improved
    • A lot of minor UI fixes
    Posted in Releases