Version | Change log |
DBeaver 24.3.3 Feb 1, 2025 |
SQL Editor: Added support for SELECT INTO query smart completion Changed shortcuts for result set zoom: Ctrl+Aalt+0 and Ctrl+Alt+9 Fixed the order of completion suggestions in the proposals list New completion engine: Fixed a bug with duplicating alias part during column completion Fixed autocomplete for join conditions when multiple joins are present Proposals list now contains only objects from the next hierarchy level Fixed autocompletion for SELECT statements with table hints for SQL Server Fixed the issue where the old result set tab didn’t close when switching between multiple and single tab modes Fixed a stack overflow error that occurred when a user tried to execute a script for an open result set with row coloring When an error occurs, the last executed query is now displayed next to the error message Fixed an exception that appeared while typing AI assistant: Fixed syntax issues in queries generated by Azure Open AI Data Editor: Added hints for geometries with SRID and for timestamps with time zones Added the ability to configure hint visibility for a table or a datasource Hints presentation was enhanced Added backslash escaping when generating scripts Added an option to disable the dictionary view (set “Maximum amount of elements” to 0) Fixed freezing issues when pasting big number of rows or when performing find/replace Added an option to save XML and JSON files in compressed format Fixed data editor filters for commoт table expressions Miscellaneous: Added the ability to create bookmarks from the context menu of object tabs Databases: Cloudberry driver was added CUBRID: Fixed view name generation in DDL (thanks to @longhaseng52) MySQL: USAGE privilege is now hidden if any other privilege has been granted Fixed loading of DBA privileges PostgreSQL: Fixed the display of infinity for date values |
DBeaver 24.3.2 Jan 15, 2025 |
SQL Editor: New autocompletion engine was enabled by default New autocompletion was enhanced with support for USING, INSERT statements, nested queries, and fixes for multiple issues You can now use the @ai command followed by a natural language phrase to instantly execute it as a query (requires AI extension) Icons in SQL Editor toolbar were redesigned Data Editor: Dark theme support was improved, selection background was changed Row hints were redesigned: key information is now displayed, the foreign key editor can be accessed via a right-click on the icon, icon rendering was improved Context menu for Filters was simplified: all items are now on the same menu level Data Transfer: Added an option to replace line break character when exporting to CSV Connectivity: Title for the Test Connection details was corrected Fixed an issue with network profile saving Miscellaneous: Performance of theme switching was improved to enhance the user experience Localization files were converted to UTF-8 to improve the localization process and enhance code readability Numerous minor UI improvements related to editors and dialogs coloring and fonts Databases: MySQL/MariaDB: Removed redundant slashes in data export to SQL format PostgreSQL: Both Asia/Calcutta and Asia/Kolkata time zones are now supported Teradata driver was updated to version 20.00.00.38 |
DBeaver 24.3.1 Jan 1, 2025 |
SQL Editor: Added AS before table alias in FROM clause for all relevant databases New autocompletion: added support for USING and some improvements for JOIN condition Fixed indentation behavior when adding a new line Added support for ${time} variable in data source variables for script templates (thanks to @pajonas) Data Editor: Cell hints were redesigned. You can configure them on the Context menu Added support for the composite types for Grouping panel Items with the too long text in query history were truncated Navigator: Saving filter for database objects was fixed Data Transfer: Added the ability to use comma as a delimiter in the Advanced Copy option (thanks to @GFreitasW) Connectivity: Proxy configuration loading was fixed Miscellaneous: Proper names for catalog/schema are now used for different drivers Added word wrap for hints to controls Search in Preferences was improved Scrolling in the “Tip of the day” window was fixed Metadata configuration files were moved to the .metadata/config folder Localization of basic controls, settings, and menu items was fixed We migrated to Eclipse 2024-12 Development: Building of IDEA project was fixed New Drivers: Databend database was added (thanks to @rad-pat) Databases: CUBRID: Added REUSE_OID, COLLATE, and COMMENT to the table DDL (thanks to @longhaseng52) Google BigQuery driver was updated to version 42_1.5.4.1008 InterSystem IRIS driver was updated (thanks to @bdeboe) MySQL: Now users can change expired password Added a setting to not export routines (thanks to @pajonas) OpenEdge: query generation was fixed OrientDB driver was updated PostgreSQL: Added default privileges grantor to DDL Syntax error in DDL generated for the role settings was fixed Default privileges for new roles were fixed Salesforce Data Cloud driver was updated Snowflake: Added support for table aliases in autocompletion SQLite: creating new constraint from selection was fixed (thanks to @eusebe-cda) SQL Server: Primary Key ordering in DDL gen |
DBeaver 24.3.0 Dec 2, 2024 |
Data Editor: Row coloring mapping now respects the visual order of columns Fixed invalid thread access on editing data in multiple results in one tab mode Boolean icons display was fixed Ability to detach result tabs is now limited to tabs with data SQL Editor: underscore in identifiers are now supported in query validation Navigator: Multiline comment display was fixed Scrolling during drag-n-drop was fixed Data Transfer: Commit/rollback behavior during the data import was improved It’s now possible to not specify quote and escape characters during the import of CSV files New Drivers: GBase 8s is now supported (thanks to @Wintianis) Miscellaneous: Snap build was fixed again Fixed connection creation from the “File” option in the main menu Fixed an issue where reading generic foreign keys Option “Open separate connection setting” on SQL Editor and Metadata pages was disabled for embedded databases Databases: Azure SQL Server: restored the “Show all databases” option in the Connection dialog. And added an error message to guide users on creating a new connection to access other visible databases BigQuery: Procedures handling is now supported in SQL editor, including LOOPS, IFs, BEGIN END, and CASE MySQL: Fixed an issue with table refresh when the “Server-side object filters” option is disabled Oracle: BOOLEAN type is now supported in Data Editor PostgreSQL: Schema permission editing was fixed Default privileges rendering was fixed RisingWave: array handling was improved SQLite: Fixed an issue with duplicate primary key generation in SQL scripts (thanks to @eusebe-cda) Fixed an issue with deleting a column without a data type (thanks to @eusebe-cda) CSV driver was renamed to CSV Basic |
DBeaver 24.2.5 Nov 17, 2024 |
New drivers: New LibSQL/Turso driver was added SQL Editor: Fixed script execution on disconnected state New autocompletion behavior was enhanced Added execution time in statistics result (thanks to @tlm365) Query manager: Time column now orders chronologically Metadata: Indexes have been returned to the unique constraint list, and the proper data type is now set when creating a new column for a new foreign key Data Editor: Fixed an issue with crash caused by too long tooltips Row coloring mapping was fixed Data Transfer: “Minimum column length” was renamed to “Default column length” Connectivity: “Driver properties” tab in the driver editing dialog was renamed to “Default properties” Charts and Dashboards: Fixed charts COUNT for single value Miscellaneous: Windows Server 2016, Windows Server 2012, and Windows 8.1 are supported again Snap build was fixed Eclipse extension installation was fixed Query execution canceling was redesigned Issues with unexpectedly closing connections were resolved Added references to the actual boolean editor in Preferences Databases: Added support for Hive 4 Altibase: Lock manager has been added (thanks to @zennken) CUBRID: Added the ability to create and edit triggers (thanks to @longhaseng52) Added sargs, edge and Query parameters to the Execution plan (thanks to @rathana-pvs) Oracle: Fixed highlighting for public schemas PostgreSQL: Added date picker and fixed data saving in the Role editor Fixed highlighting for public schemas Connection to custom schemas was fixed Fixed data change saving in Value Panel Teradata: Multi-row insert was fixed in data import Fixed incorrect display of PERIOD data type Max rows handling was improved |
DBeaver 24.2.4 Nov 3, 2024 |
SQL Editor: A warning is now shown instead of an error when a DROP TABLE statement contains IF EXISTS and the table does not exist Fixed script execution on disconnected state New autocomplete engine now expands the * symbol in SELECT statements when using “Ctrl + Space” New autocomplete no longer suggests query-start keywords in the middle of queries Metadata requests are no longer sent while typing a query when “Auto-activate on typing” is enabled Data Editor: exception on disconnection was fixed Navigator: Added the ability to refresh the database connection Filters were fixed Data Transfer: Added the ability to export JSON values as embedded JSON Connectivity: Presentation of driver download errors has been improved for better clarity and user experience Finding class in the Driver manager was fixed Miscellaneous: the Export Window now advances properly when pressing the Enter key Databases: Altibase: Module Memory Usage was added to the system information folder in the navigator tree (thanks to @zennken) ClickHouse: Array syntax highlighting has been improved CUBRID: “Use SQL to limit fetch size” was set to true (thanks to @hwany7seo) Fixed an exception that occurred when creating a column without specifying a data type Ingres: driver download was fixed Redshift: access to external databases was fixed Localization: Brazilian Portuguese localization was enhanced (thanks to @brlarini) |
DBeaver 24.2.3 Oct 21, 2024 |
SQL Editor: “Show values setting” in the autocompletion section is disabled by default due to performance issues Added highlighting and validation of synonyms Semantic error style was changed Fixed issues with highlighting that occurred when saving the script Metadata: Fixed and exception that appeared on right click on table properties Connectivity: Fixed an issue where script execution would not stop when disconnected Added an ability to export driver files from the “Edit driver” dialog Fixed user name display in SSH profile Miscellaneous: Added additional Java configuration file independent of the product version update Added the ability to disable Windows Defender at startup, which speeds up application loading Some SWT errors were fixed Darkest Dark theme installation was fixed Added the ability to work with OS usernames containing special characters Git extension installation was fixed Eclipse license text was updated Fixed exception that appeared when loading procedure Databases: BigQuery: Array and JSON display was improved Db2 z/OS: Fixed broken configuration for generic drivers DuckDB: BLOB display was fixed MySQL: Added support for table name in backticks for SQL Editor PostgreSQL: Permission editor was fixed |
DBeaver 24.2.2 Oct 6, 2024 |
Data Transfer: changed icons for collapsed sections to improve the interface readability Connectivity: fixed error handling when a user loads a driver and has an error with certificates SQL Editor: ‘Cmd+Enter’ shortcut was added in addition to ‘Ctrl+Enter’ on macOS due to the conflict with new system hot keys in Sequoia Fixed an error in multiple tab mode execution when the new execution results replaced old ones The amount of problems being displayed per script query was limited Complicated table qualifiers (database.catalog.schema.user) are now supported Fixed incorrect highlighting after the database disconnect Query execution time is now displayed in seconds/minutes Added an ability to select the text between brackets using ‘Ctrl+Shift+]’ hot key Background Tasks view now shows progress of autocompletion engine Data Editor: Presentation and editing of struct and array data types was significantly improved DBeaver can now correctly display negative dates in MySQL databases Navigator: Table filters in Simple view were fixed Disabled the ability to delete the currently active project Miscellaneous: Incorrect sorting in Execution log was fixed Issue with not working boolean setting editor was fixed Databases: Altibase: added display of the list of tables and indexes within a tablespace (thanks to @zennken) CUBRID: Added the ability to create, edit, and drop Server via UI (thanks to @longhaseng52) Added an ability to create, update, and delete users. (thanks to @rathana-pvs) Oracle: Added highlighting and validation of public synonyms Table autocompletion was fixed Virtuoso: replaced static jar file with Maven artifact |
DBeaver 24.2.1 Sep 22, 2024 |
SQL Editor: Smart syntax highlighting was significantly improved Pseudo columns highlighting was improved Table aliases were fixed in smart completion Issue with pinned tabs was resolved Syntax highlighting fixed for single quoted strings (thanks to @tlm365) SQL console save was redesigned (it now asks for confirmation) Data editor: Commit/rollback buttons now enabled only when transactions are applicable Column description rendering was improved for dark theme Database navigator: horizontal scrolling was fixed, now action icons are always visible Object editor: bottom toolbar layout was unified for all tabs Data transfer: CSV parameters documentation was added Database backup/restore dialog layout ws fixed General: Snapcraft image now includes additional fonts Embedded browser support was added for Linux/GTK App command line parameters logging was was disabled because of security concerns Issue with splash screen and error message overlapping was resolved Resource leak detection logging was added by default We migrated to Eclipse 2024-09 platform Databases: Altibase: database replication metadata was supported (thaks to @zennken) Azure SQL: “show all databases” option was removed CUBRID: Index drop command generation wad fixed (thanks to @longhaseng52) Procedure create dialog was added (thanks to @longhaseng52) List of reserved keywords was updated (thanks to @rathana-pvs) DolphinDB driver was added (thanks to @peeyee) MySQL: NULL geometry values handle was fixed (thanks to @EastLord) Salesforce CDP: connection dialog layout was fixed SAP HANA: Connection dialog was improved for HANA Cloud (thanks to @kai-morich) Expired password change feature was added (thanks to @kai-morich) Trino: issue with long cursor reading was fixed (thanks to @schaffino) Localization: Arabic localization was added (thanks to @AliElamir) Brazilian Portuguese localization was updated (thanks to @brlarini) |
DBeaver 24.2.0 Sep 1, 2024 |
SQL Editor: Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled Warning and errors handling and presentation was improved Subquery semantic analysis was enhanced Improved CREATE and DROP queries handling Autocompletion for fully qualified names was fixed Duplication of proposals with new completion engine enabled was fixed Incorrect suggestions with new completion engine enabled were fixed AI Assistant: Added new model ‘gpt-4o-mini’ Removed deprecated model ‘gpt-3.5-turbo-16K’ Fixed query generation when enabled formatting Data Editor: Some datatypes icons were changed Fixed filtering on columns with spaces Added an ability to render geometry shapes in their assigned color if a ‘color’ column is present in the result set Improved handling of fully qualified names in Grouping panel according to SQL dialect Local links opening was restricted Datatransfer: Data transfer windows width was fixed Connectivity: Fixed verification of the 127.0.01 host when connecting via SSH General: Fixed flipping splash screen on macOS Sequoia Foreign Data wrappers configurator was fixed ‘Open auth links in embedded browser’ setting was disabled by default Search in Preferences was improved: added keywords for reopen, open, Hippie, autosave, and others Fixed selection of wrong database when changing connection for database with similar names Folder display in Simple view was fixed Numeric (DWORD) type parameters in Windows Registry are now supported ‘Ctrl+Alt+Left / Right’ hotkeys for ‘Previous Edit Location’ and ‘Next Edit Location’ were fixed Databases: Clickhouse: Filtering by the Date data type was fixed MySQL: Error/output log dump was fixed PostgreSQL: Ordering by interval datatypes in the Data grid was fixed Added regexp functions support in SQL Editor (thanks to @anton-erofeev) Redshift: Connection stability was significantly improved DDL presentation was fixed Role, User, and Group presentation was f |