Releases: dbeaver/dbeaver
Releases · dbeaver/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)
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
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
23.1.0
- 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
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)
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
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)
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
23.0.1
- SQL editor:
- Results tab now can be detached
- Editor toolbar now can be customized in preferences
- Query statistics tab now can be turned off
- Table metadata search was improved
- SSH:
- Support of new crypto ciphers was added
- SHH agents now works properly in Linux
- General UI:
- Zoom in text editors and data editors was fixed
- Navigator tree refresh after metadata change was fixed
- Default font size was increased for MacOS
- Text font configuration was fixed in multiple dialog windows
- Connection type settings change now affects UI properly
- Data export: exporting of BLOB values in TXT format was improved
- Native network proxy configuration was fixed
- TiDB: new driver was added (thanks to @Icemap)
- Clickhouse: driver version was updated to 0.4.2
- Firebird: procedure parameters defualt values support was added
- Oracle: additional properties in table info were added
- PostgreSQL: composite data type support was improved
- SQLite: STRICT mode support was added
- Sybase/SQL Anywhere: result set size limitation in SQL was fixed
- Vertica: expired password change feature was added
23.0.0
Changes since 22.3.5:
- SQL editor:
- Column metadata resolution was fixed for quoted column names
- SQL console now respects "open separate connection" option
- Variables resolve in
setand other commands was fixed - Copy/paste command was fixed for editors without associated connection
- Data editor:
- Spatial viewer: lasso tool was fixed for Safari browser
- Support of WKT format stored in BLOB columns was added
- Issues with image viewer and BLOB columns was fixed (NullPointer error))
- Selected columns/rows data export was fixed (issue with BLOB value turning into NULL in UI)
- Accessibility:
- Font settings are now respected in all editors/popups
- New keyboard shortcuts schema was added "DBeaver Keyboard Only"
- Many new keyboard shortcuts were added
- Catalog/schema selector now supports keyboard only mode
- Results tab pin/unpin command is now accessible from keyboard (thanks to hawthorne3341)
- Reader texts were localized
- Database dashboard create wizard UI was fixed
- Generate SQL dialog now supports connection invalidation
- Clickhouse: driver version was updated to 0.4.1
- Dremio: driver version was updated to 24.0
- Firebird: table colum comments support was added
- PostgreSQL:
- Issue with URL-based connections was resolved (invalid host name)
- Execution plan parameters are now saved
- Redshift: varbyte datatype suport was fixed
- SQL Server:
- UI for Kerberos authentication configuration was fixed
- Table colum comments support was added
- French localization was fixed (thanks to alexgille)
- Problems with Kerberos were resolved (we have reverted to Java 11)