- Data editor:
- Dictionary viewer panel UI was redesigned
- Spatial data types: curved geometries linearizing was fixed
- Issue was result tab close on data save was resolved
- Column tooltips was fixed
- Charts rendering errors visualization was improved
- SQL editor:
- Autocompletion in single-line comments was fixed
- Variable value editor was fixed
- Smart completion for CTE queries (WITH/SELECT) was fixed
- @include command handler was fixed (reuse the console for the same included script)
- INSERT SQL query generation was fixed (identity columns)
- Issue with text search/replace in hidden files was fixed
- ERD editor: grid foreground color was fixed
- General UI:
- Objects sorting in tables now can be reset to the original ordering
- Network handlers (SSH, SSL, etc) UI was redesigned
- New object creation shortcut was added (Alt+Insert)
- External files opening was fixed on MacOS and Linux
- Command line connection opening was fixed
- User name/password prompt dialog as fixed for SSH tunnels
- Issue with preference pages in Eclipse plugin was resolved
- Accessibility:
- JAWS and Narrator support was improved for data editor and vertical tabs
- High contrast theme support was significantly improved
- Databases:
- Clickhouse: map and array data types visualization was added
- Greenplum: tables DDL was fixed (for version 7)
- OpenGauss DB: json data types support was added
- PostgreSQL: default native clients (pgsql, pg_dump) version was changed to 15
- Yellowbrick: stored procedures drop query was fixed
- Localization:
- Chinese localization was updated (thanks to @bianyun)
DBeaver 23.1.5
Posted in Releases
DBeaver 23.1.4
- SQL editor:
- Table alias generation was fixed (issue with duplicated aliases)
- Auto-proposals now respect option “empty line is a query delimiter”
- Auto-proposals calculation performance was significantly improved in some cases
- Aliases completion was fixed (issue with redundant spaces)
- Table name completion was fixed for invalid SQL queries
- Spelling errors and other annotations now work in console mode
- @import command behavior is now configurable
- Data editor:
- Filters/orderings/colors reset UI was significantly improved
- Spatial viewer now hides empty labels
- Copying of spatial viewport/selection bounds was fixed
- Drag-n-drop in grouping panel fixed on Linux
- Data transfer: previous export settings loading was fixed
- General:
- Auto-commit mode switch behavior was fixed
- CLI processing was fixed in multi-workspace environment
- “Tip of the day” now shows OS-specific shortcuts corectly
- Redundant logs of SSH tunnel closing were removed
- Logical database structure settings can be disabled or reset in the connection editor dialog
- Driver search UI was fixed on MacOS
- Number of minor UI bugs were resolved
- Database:
- Athena: multi-catalog support was added
- Derby: grouping queries generation fixed
- DuckDB: time/timestamp data types support was added
- MySQL: issue with missing table partitions folder was resolved
- Oracle: table DDL shows permission grants in “full” mode
- PostgreSQL: issue with duplicated tables was resolved
- Redshift: SQL dialect was enhanced with extra keywords
- Yellowbrick: execution plan visualization was fixed
Posted in Releases
DBeaver 23.1.3
- Spatial data viewer:
- Geometry object labels were added to the map (configurable)
- Curves rendering was implemented
- Coordinates and viewport bounds copy was implemented
- EWKT format support was added
- Toolbars and lasso visibility toggle was fixed
- Data transfer:
- Import of multiple tables from an XLSX was implemented
- Lazy initialization of configuration pages was implemented
- Issue with duplicated file selector dialog was fixed
- Export in XML format was fixed (doctype section is not optional)
- Issue long filenames on Windows was fixed
- Data Editor:
- Find/Replace dialog and shortcut in the Value view panel were fixed
- Column description was added to the Metadata panel
- Folding in the XML presentation was fixed
- Displaying of images in the the value view panel was fixed on Linux
- Confirmation dialog for the result set filtering was improved
- Accessibility:
- JAWs screen reader can now read data in the Data grid
- General UI:
- Tips of the day were updated
- Creation of objects with mixed-case identifiers was fixed
- DDL generation for sequence was fixed
- Logical project deletion was fixed
- Issue with opening of a local project was fixed
- AI:
- New GPT 3.5 Turbo 16К model was added
- Issue with long metadata information sending was fixed
- Connections:
- Duplicates on driver creation were removed
- Issue with maven artifacts editing was fixed
- Certificate management UI was improved
- New drivers:
- Materialize database driver was added (thanks @bobbyiliev)
- Crate DB via PostgreSQL driver was improved (thanks @proddata)
- Databases:
- DB2: users can see Column Mask Objects
- TimescaleDB branding was updated
- Localization:
- Chinese Simplified localization was improved (thanks @bynyun)
- German localization was improved (thanks @fjf2002)
Posted in Releases
DBeaver 23.1.2
- SQL editor:
- Mouse hovering over editor annotations was fixed
- Trailing DDL query delimiter processing was fixed
- Data editor:
- References panel refresh was fixed
- XML presentation was fixed (NULL value handler)
- General UI:
- Settings reset UI and behavior were redesigned
- Editor tab tooltip now contains information abut resource’s project
- CLI parameter for app version print was added
- Objects with mixed case names caching was fixed
- Issue with program launch with wrong Java version was fixed
- Preferences export/import UI was improved
- Maven snapshot repository was added to default configuration
- Connections: kerberos support in legacy JDBC drivers (Hive) was fixed
- Data transfer: table information for tasks with broken connection was fixed
- Databases:
- BigQuery: driver version was upgraded to 1.3.3 (thanks to @fredlegaucher)
- DuckDB: LIST data type support was added
- Firebird: filters and sorting in grouping panel were fixed
- IBM i: driver download was fixed
- Oracle:
- Partitions cache refresh was fixed
- Stored procedures edit/save was fixed
- PostgreSQL: enum columns alter was fixed
- Snowflake:
- Client application name set was fixed
- Quoted identifiers auto-completion was fixed
- Misc: internal app controller server now uses HTTP instead of RMI
Posted in Releases
DBeaver 23.1.1
- SQL Editor:
- User can configure the options on the toolbar by pressing the gear button in the editor
- Issue with missing “Copy file path” option was fixed
- Data Editor:
- Statistics view now can be disabled
- Issue with References tab was fixed
- Spatial tiles configuration was fixed (thanks to @otbutz)
- ER Diagram: issue with element removal after using View Style option was fixed
- Data transfer: issue with exporting a table without data when using bulk loading was fixed
- New drivers: TDengine database is now supported (thanks @sangshuduo).
- General UI:
- Users can export DBeaver settings and import them
- Notifications in Dark theme became topic “Notices in the dark” became readable
- Users can use drag-n-drop to copy scripts, open database objects and insert Navigator node names into the editor
- Connectivity:
- User can add snapshot maven repository
- “Automatically end long idle transactions” option was redesigned
- Authentication failure when connecting via SSH was fixed
- Now users can connect with jump server using SSHJ
- Issue with connecting to Azure SQL Server using Active Directory was fixed
- Security: SQLite driver version was updated
- Databases:
- DB2z and Denodo: “Show duplicates” button in Grouping panel was fixed
- Greenplum: function DDL was fixed (default parameter values)
- Oracle:
- Dates of creation and modification appeared in the information about the packages
- Table partitions and subpartitions reading was fixed
- Issue with missing tablespace statistics after object update was fixed
- Snowflake: quotation rules for object identifiers were added
- Localization:
- Users can now select Portuguese as the default language during installation or in Preferences
- Portuguese localization was improved (thanks to @brlarini)
- German localization was improved (thanks to @coderkun)
- Misc: we switched to Eclipse 2023-06 and Java-17 as a base platform
Posted in Releases
DBeaver 23.1
- SQL Editor:
- Autocomplete now supports [ ] and ` as quotes for identifiers
- Shortcut confict on macOS was fixed
- JSQLParser was reverted to the version 4.5 and is now faster
- Issue with substitution variables in text with \n line feeds was fixed
- Autocomplete case with FROM right after SELECT is now handled
- Autocomplete for SELECT query without FROM was fixed
- ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
- Autocomplete for columns in tables without alias was fixed
- Completion analyze errors are now written to the debug log
- Comment with a tab after a double dash is now handle
- Issue with hiding cursor position after resizing the editor was fixed
- Exeption when updating editor annotations was fixed
- Data Editor:
- Data ordering was improved
- General UI:
- Changing the size and position of the connection dialog is now saved
- Issue with the application freezing when creating a table when the connection hangs was fixed
- Tips of the day were revised
- Connectivity:
- Option to disable SSHJ hostname verification was added (thanks to @ryanc-me)
- Issue when switching from Community to PRO version and vice versa was fixed
- Databases:
- ClickHouse: display of large numbers was fixed
- MariaDB: partition support was added
- Oracle:
- Issue issue with native clients hanging when running SQLPlus scripts was fixed
- Issue with setting the wrong schema after connecting or changing the Data Editor was fixed
- PostgreSQL:
- Issue with an exception when loading attribute information was fixed
- Reading a numeric array was fixed
- Trino: error handling was improved
- Localization:
- German localization was improved (thanks to @hype11)
- Italian localization was improved (thanks to @Gnafu)
- Misc:
- Images for all DBeaver Eclipse extensions were added
- Legacy ODBC driver based on the obsolete Java 7 was deprecated due to many issues
Posted in Releases
DBeaver 23.0.5
- SQL Editor:
- Autocomplete for WHERE and SELECT shows aliases with the aliased table
- Hovering information for SQL errors and spelling annotations was added
- Variable and parameter names in the binding dialog are now displayed in their original case
- Information about assigning a non-dynamic variable was added to the binding dialog
- Issue with incorrect icon for Execute SQL Statement after opening Output tab was fixed
- Query Manager: ‘Restore Default’ button behavior was improved
- Ability to directly execute SQL scripts in native clients was added
- Data transfer:
- Ability to trim string values when exporting to XLSX was added
- Handling of datetimeoffset was added
- General UI:
- Part divider UI was redesigned
- Option to increase formatting time was added in Preferences
- Issue with closing pinned tabs using ‘Close Tabs to the Left’ was fixed
- Connectivity:
- Issue with driver fallback not being updated was fixed
- Databases:
- ClickHouse: driver was updated to 0.4.6 (thanks to @zhicwu)
- Databricks: handling of data types without parameters was added
- Hana: comments handling was fixed
- MySQL: partitions are now supported
- Oracle: TNS import was fixed
- PostgreSQL:
- Issue with duplicate tables with generated columns in Database Navigator was fixed
- Error message about line on the map created with a single point was added
- Schema refresh was fixed
- SQLite: ability to open ER Diagram in the Simple View was added
- Localization:
- German localization was improved (thanks to @hype11)
- Italian localization was improved (thanks to @Gnafu)
Posted in Releases
DBeaver 23.0.4
- Data Editor:
- Bottom toolbar became customizable
- Disconnected editors can be easily reconnected
- Issue with Ctrl+1 shortcut not working was fixed
- SQL Editor:
- Issue with refresh button closing active resul tab was fixed
- Issue with not correct dislaying of \r\n sequence was fixed
- Issue when generating the same UUID for all rows was fixed (thanks to @SiyaoIsHiding)
- Data Transfer:
- Ability to change the target column type on import to BIGINT was added
- Export from query to CSV was fixed
- Git: Missing git buttons and menus were added on macOS (Apple Silicon)
- Databases:
- ClickHouse: Catalog support was added
- Informix: issue with extra spaces in table name was fixed
- MySQL:
- Event reading for quoted schemas was fixed
- Time handling in MySQL was improved
- Oracle:
- Issue with parcing IF EXISTS statements was fixed
- The display of DATE with additional settings in the Result Set was fixed
- Inromation about latest statistics update was added
- PostgreSQL:
- Generation of ALTER table SQL for foreign tables was improved
- Role settings were added in generated DDL
- IDENTITY SEQUENCE were added in generated DDL
- Snowflake: issue with incorrect import with BIGINT, INT, REAL, FLOAT, DOUBLE PRECISION, and DECIMAL data types was fixed
- Trino: issue with import files with varchar data type was fixed
- Misc:
- SalesForce driver was updated
- ODBC connection error was fixed
- Java native libraries were added to DBeaver installation directly to avoid app crash cased by system restrictions.
- DBeaver started to collect user statistics. It is anonymous and optional
Posted in Releases
DBeaver 23.0.3
- General UI:
- Issue with zoom in and out with Ctrl++ and Ctrl+
- in SQL Editor and Data gird was fixed
- ER Diagram font now depends on the Main font
- A lot of UI rendering improvements were made
- SQL Editor:
- Moving with Ctrl+Right/Left now considers words with an underscore and a dollar as a whole word (configurable)
- Autocomplete for mixed-case was improved
- Issue with crashing when closing the SQL Editor tab was fixed
- Order by parsing was improved
- AI: issue with changing settings was fixed
- Data Editor:
- Data filters support in the Grouping panel was added
- Opening TXT, JSON, and XML files in external editors was improved on macOS and Linux
- Rendering of non-display characters was improved
- Issue with disappearing filter option, when a query returns nothing, was fixed
- Microseconds epoch transformer was added (thanks to @BobrPetr)
- Database Navigator: issue with creating a new view was fixed
- Data transfer:
- Issue with set max column length when exporting in TXT was fixed
- Issue with export JSON to TXT was fixed
- Databases:
- Firebird: recognition of procedure parameter data types was improved
- SQLite: issue with database synchronization with the server was fixed
- Redshift: issue with renaming a view in Database Navigator was fixed
- MySQL: issue with the empty privileges list was fixed
- Snowflake: displaying the creation time of Snowflake views was added
- TiDB Cloud: telemetry support was added (thanks to @Icemap)
- PostgreSQL: array presentation was improved
- Localization of Brazilian Portuguese was improved (thanks to @brlarini)
Posted in Releases
DBeaver 23.0.2
- ER Diagrams:
- Accessibility support (text reader) was added
- Many keyboard shortcuts were added
- Issue with diagram re-layout after options change was resolved
- Issue with moving focus when searching was fixed
- General UI:
- Database editors remain open after disconnect (configurable)
- Clickable hints are now displayed as links
- Issue with missing icons in the toolbar on MacOS was fixed
- Font and color changes in the Result Set were improved
- Large fonts now display correctly on MacOS
- SQL Editor:
- Auto-completion for INSERT/UPDATE/DELETE queries was improved
- Font changes are now applied without a restart
- Data Editor:
- Show numeric values (e.g. infinity) rendering was improved
- Issue with opening images from value panel in external editor was fixed
- Connectivity:
- Legacy SSH algorithms support was added
- Confirmation dialogs now remember user selection
- The number of attempts to reopen the connection was reduced
- Ability to connect via SSHJ with unsaved password was added
- Maven artifacts configuration now supports classifier
- Data transfer: column description support was added for CSV and XLS formats
- AI (ChatGPT): unsupported AI models were replaced with new ones
- Databases:
- Firebird: default parameters in procedure definitions were added
- PostgresSQL: materialized views dependencies were added
- Databricks: support of table comments were added
- Oracle: issue with cropped ‘q’ at the end of the string was fixed
- SQLite: triggers delete was implemented
- SQL Server: issue with duplicated data types was resolved
- Localization:
- Traditional Chinese localization was updated (thanks to @hwhsu1231)
- Traditional Chinese language was added to Windows installer
- Misc:
- Microsoft store: issue with application installation was fixed on most machines
- We switched to Java 17 (again)
- We switched to Eclipse 2023-03 as a base platform
Posted in Releases