| Version | Change log |
| DBeaver 7.2.4 Nov 2, 2020 |
- Data transfer: - REPLACE/UPSERT support was added in SQL export format - Target format selector was fixed (Linux) - Bug in dump/restore credentials save was fixed - Data viewer: - Contrast color now used as foreground color - Bug with results fetch size disable was fixed - Preference pages structure was re-organized (get rid of Eclipse legacy) - Database navigator: - SQL editor context menu was enhanced - "Link wit editor" command was fixed for SQL scripts - Problem with empty/redundant tooltips was fixed - SQL editor: active query cancel on editor close - ER diagrams: table comments loader was fixed - Sample database now can be created from the main menu - Transaction deadlocks viewer was fixed - PostgreSQL: - Data type handler detection was fixed (uuid, name and other types) - Array editor was fixed (proper array item type discover). - Oracle: - Oracle 8 support was fixed (metadata read queries) - Ref cursors support was added - Multi-row INSERT support was added (for export in SQL format) - View and materialized view DDL was fixed (comments) - MySQL: - Dump/restore credentials override option was added - "Disable foreign key checks" option was added in database restore wizard - SQL Server: national charsets support was added for table/column comments - Informix: check constraints read was added - Hive: LIMIT clause support was added - Intersystems IRIS driver was added - Number of minor bugs were fixed |
| DBeaver 7.2.3 Oct 19, 2020 |
- Data transfer: - Data preview was fixed for custom SQL queries - Binary format mapping was fixed (BLOB->binary) - Target table name mapping was improved - Context data context menu item visibility was fixed - SQL format: extra options were added (including INSERT OR REPLACE support) - HTML format: additional export options were added - DbUnit format support was improved - SQL editor: - "Auto-save on edit" option was added - Procedures auto-completion was improved (use signature or parameter names depending on context) - Query cancel on editor close was fixed - Disable auto-formatting inside comments - Data viewer: minimum fetch size now limited by 100 rows - SSH configuration: bug with variables in connection parameters was fixed - Column reordering UI was fixed - PostgreSQL: - Serial data types support was improved - Trigger DDL was fixed - $$ rule parser was fixed - Informix: - Driver was updated to the latest version - Schemas/tables metadata extraction was fixed - Error in database switch in transactional mode was fixed - MySQL: - Zerofill flag support was added - NULL values of "text" type rendering was fixed - Oracle: - Expired password change feature was fixed - Connectivity problem ("ONS configuration failed") was fixed - SQLite: column drop feature was added - SQL Server: data read from clustered tables was fixed - Number of minor bugs were fixed |
| DBeaver 7.2.2 Oct 4, 2020 |
- Database navigator: - View only connected data sources filter was added - Quick search in connections/schemas options were added - Multiple objects delete confirmation dialog was redesigned - Tooltips visibility configuration was added in preferences - Windows installer: shortcuts for "All Users" were fixed - SSH tunnels: - Support for OpenSSH key format was added - Problem with dobule password prompt was fixed - Data viewer: - Grouping panel now supports column reordering - Column modifier icons (key, read-only) were updated - JSON/XML viewer performance was significantly improved - SQL editor: toolbar buttons enablement was fixed - Data transfer: - Native client selector was fixed - Extra file name pattern variables were added - Native date/timestamp format support was added to the SQL INSERTS export - Extra formatting options were added to the SQL INSERTS format - MySQL: user credentials of mysqldump overwrite local configuration now - SQL Server: - SSL support was added - Database create/drop/rename features were added - PostgreSQL: - Interval data type DDL was improved - Table storage parameters were added to DDL - "Connect as role" option was added in the connection settings - Materialized view comment edit was fixed - Trigger comment editor was added - Oracle: extra NLS parameters were added on the connection settings page - Snowflake: active schema set command was fixed - Derby: unique indexes metadata read was implemented - SQLite: column autoincrement option support was added - Firebird: data types information read was fixed - Several other minor UI bugs were fixed |
| DBeaver 7.2.1 Sep 21, 2020 |
- Preference pages structure was reorganized (in the standalone and plugin versions) - Database navigator: - Filters now support masks escape (_ and % characters) - Connection state icons were replaced and adapted to dark themes - SQL Editor: editor tab title now can include active database/schema name - MySQL: driver "MySQL 8" is now the default driver. "MySQL 5" driver can be used for older server versions. - Oracle: tables/views load performance was improved on some systems - PostgreSQL: - Latest PostGIS driver mapping was added - Geometry data types export was improved (proper SQL format + SRID) - Hidden databases can be loaded in the database navigater - CockroarchDB: role manager was fixed - DB2: runstats utility support was fixed (wrong syntax) - SQL Server: extra T-SQL dialect keywords were added - CUBRID driver configuration was fixed - Several UI freeze issues were fixed (deadlocks) - Import from CSV/XLSX: - Wrong rows can be skipped (with disabled "Batch import" option) - Import parameters documentation was updated - Several minor bugs were fixed (NPE and UI glitches) |
| DBeaver 7.2.0 Aug 31, 2020 |
Major changes since 7.1: - Simplified database structure view was added - Database maintenance tools can be saved as tasks now - Table and schema size statistics were added in the database navigator - Import from multiple CSV files was added. Files can be imported into new or existing tables - Many problems with UI freeze on disconnect or query cancel were fixed - Database navigator rendering was redesigned - A number of problems with keyboard shortcuts were fixed - Git integration was improved: now we show file status in the Project Explorer view - New database drivers were added: YugabyteDB and SQreamDB Changes since 7.1.5: - Problem with database list load was fixed (PostgreSQL, Redshift, MySQL, Oracle, SQL Server) - Metadata editor: edit property form rendering was improved (non-applicable fields are hidden) - Performance for table statistics reading was improved - Data viewer: - Column ordering was fixed (for custom SQL queries) - UUID transform: version 2 support was added - Default database name and default user name were added for many database drivers - Data export: custom data type formatting support was fixed - PostgreSQL: - Cursor fetch was fixed - Native client was upgraded to version 12 - Table OID support was fixed (PG 12) - PgPass parser was improved (support for escaped characters was added) - Oracle: - Materialized view comment editor was fixed - View definition reading was fixed (for non-DBA users) - Table reading now uses DBA views (optional) - Profile resources metadata reading was fixed - MariaDB/MySQL: table column resolving was fixed - CockroachDB: connectivity problem was fixed - Greenplum: - Metadata search was fixed (for procedures) - Table metadata reading was fixed - Dark theme support was improved (tab folders, toolbars) - A large number of minor UI bugfixes |
| DBeaver 7.1.5 Aug 17, 2020 |
- Data transfer: - Import from multiple CSV files was added - Import from files into new tables - Data import preview dialog was added - Target table create/alter DDL now supports database-specific options - Virtual columns are ignored in SQL INSERTs export - Problem with data transfer wizard and Darkest Dark theme was fixed - Problem with timestamp format for CSV/XLSX export was fixed - Case sensitive table/column names resolution was fixed - Database navigator: - Statistics render was fixed for MacOS and Linux - Database size statistics was added for PostgreSQL, MySQL, SQL Server, DB2 - Team work: - Problem with empty Git Repositories view was fixed - Git integration was added in project navigator view - PostgreSQL: - Native client version was upgraded to version 12 (Windows) - Check constraints read was fixed (PG 12+) - SQL results limit was fixed (for queries with LIMIT/OFFSET/FETCH clauses) - Object DDL generator was improved (comments, permissions) - Support of case insensitive full-text search was added - Table partitions statistics was added - Oracle: - TNS names search was fixed - Connection info was fixed for TNS/custom URL connections - Variables are now supported in custom JDBC URL (thanks to @insightfuls) - MysQL: - Problem with check constraints read was fixed - Table copy was fixed (bug with redundant indexes was resolved) - Redshift: problem with read-only resultsets was fixed - Snowflake: SQL dialect support was fixed ($$ comments) - A large number of minor UI improvements and bugfixes |
| DBeaver 7.1.4 Aug 3, 2020 |
- Database navigator: - Connection status icons and tooltips were redesigned - Icon decorations added for Git-integrated projects - Navigator view options were added in the context menu - Simple view support was improved (redundant objects removed from the navigator tree) - Icons for "Create new objects" action were fixed - Data editor: - Unique key detection was fixed (for data editor) - Advanced paste of multiple rows was fixed (redundant rows create was removed) - Column filter dialog move/resize was fixed on Linux - Grid data rendering performance was improved - Auto-complete of column names was fixed in the filter panel - SQL editor: - Search/replace/undio/redo shortcuts were fixed in embedded editors (view/procedure sources) - Parameter binding was fixed for multiple occurrences of the same parameter - Smart commit mode behavior was fixed for PostgreSQL (post-error transaction recovery) - Delete indent with single backspace was enabled by default - Server log panel now works for data modification triggers - Extract query from source code now shows notification popup - Multiple queries execution is now allowed (in separate tabs) - ERD editor: extra coloring was added for multi-schema diagrams - Oracle: - Metadata read performance was increased (Tables, materialized views) - Columns and constraints were added in materialized view editor - Numeric data type precision read was fixed - Support of implicit cursors in query results was added - View DDL reading was improved (view comments are included in DDL) - PostgreSQL: - Default schema detection and search_path overwrite was fixed - Multi-dimension arrays support was added - Table DDL for inherited tables was fixed - MySQL: - Active database change in read-only connections was fixed - CHECK constraints support was added - Table copy operation was fixed - User password management was improved (to avoid FLUSH PRIVILEGES) - Sybase: - Support of text editing in views was added - Schema indexes reading was fixed - New table columns create was fixed - CockroachDB: direct table data edit support was fixed - HSQLDB: UUID data type support was added - Query cancelling was improved (force cancel for hanging connections) - Transaction isolation level settings save was fixed - Error and debug logging was fixed - A large number of minor UI improvements and bugfixes |
| DBeaver 7.1.3 Jul 20, 2020 |
- Spatial presentation: tooltips rendering was fixed - DB2: UI tools were converted into database tasks - MySQL/MariaDB: database restore was fixed (binary data corruption) - PostgreSQL: data type DDL was improved + comment edit support was added - Oracle: problem with connect as SYSDBA was fixed - Exasol: (thaks to @Sargul) - Database error type discovery was added (proper handle of "connection lost" errors) - Metadata read performance was improved - Googlee Spanner: official driver configuration was added (thanks to @olavloite) - Simple view mode was fixed (redundant database objects were hidden) - Proxy configuration UI was fixed - MacOS installer was fixed (potential vulnerability was removed, thanks to @De4dCr0w) - Tasks management: error handing was improved (for deleted tables) - We reverted to Eeclipse 2020-03 platform (it resolves a set of UI glitches on some platforms) - A few minor UI and database-specific bugs were fixed |
| DBeaver 7.0.0 Mar 2, 2020 |
DBeaver 7.0 is our new major release. Changes since 6.0: - Tasks management: data transfer, backup-restore, SQL execution - Data viewer and data editor UI major improvements: - GIS/geo-spatial viewer - JSON viewer - Logical columns, primary and foreign keys - References panel - Advanced row coloring - SQL editor major improvements: - Smart-commit mode - Enhanced SQL parser and auto-complete proposals - Git integration - SSH agents and jump servers support - And a lot of other great things Moreover: - We increased number of supported drivers to 81 - We closed almost 2000 issues on GitHub. Thank you for your support! Changes since 6.3.5: - SQL script execute task: - Support of multiple scripts was added - Support of multiple connections was added - Configuration wizard was completely redesigned - SQL editor: - Auto-complete proposals were colorized - Auto-complete for table column possible values - Synonyms are now resolved as tables - Data viewer: - Filter panel auto-completion was fixed - Value viewer panel refresh was fixed - Boolean column transformation was added (view numeric columns as checkboxes) - Import from CSV: column mappings was fixed - Popup panels unexpected close was fixed - Invalidation of dead SSH tunnels was fixed - PostgreSQL: - Type cast for updates and filters is now used - Timestamp scale edit was fixed - SQL Server: - Driver version upgrade (to 8.2) - Data import for IDENTITY columns was fixed - MySQL: permission editor supports schema masks - Oracle: - PL/SQL parser was fixed - Comment editor for views and functions was fixed - TIMESTAMP WITH TIMEZONE support was improved - HANA: - GIS (geometry) data types support was improved (by @stefanuhrig) - Table column drop was fixed - OmniSci: driver version was updated. - Linux: UI freezes were fixed - A few minor UI improvements (icons, English localization, ERD colors, shortcuts) - A lot of minor bug fixes |
| DBeaver 6.3.3 Jan 20, 2020 |
- Tasks: - SQL script execute task was added - Variables support was added - Grouping of tasks by project/type was added - Active database/schema now saved for custom SQL queries - Target table mapping was fixed for database-to-database data transfer - Data viewer: - Column filter UI was improved (multi-value select, value search) - Null XML columns support was fixed - Column value transformations and coloring was fixed - Context menu was improved (layout was change, missing commands were added) - Problem with missing toolbar actions was fixed - Hex editor coloring was improved, dark theme support was added - SQL editor: - Auto-complete now respects active schema - Database output read was fixed (async mode) - Hyperlinks and object navigation were fixed - Aliases generation algorithm was improved - PostgreSQL: - Database restore task was fixed (target database) - SQL parser was fixed (BEGIN/END keywords) - Oracle: procedures/views source code editor was fixed - MySQL: database restore log level config was fixed - Netezza: views and procedures source extraction was fixed - Hive: view editor was fixed - Neo4j: arrays support was fixed, SQL parser was fixed - Metadata editor: current database detection was fixed - Tooltips for database navigator were improved - Variables in connection parameters now enabled by default - Connection type permissions save was fixed - Dark theme support was improved in the main toolbar and in different dialogs - SSH agents support was fixed (now we use ssh-agent on Linux) - SSH + private key + password: configuration dialog was fixed - A lot of minor bugfixes |
