DBeaver CE x64 Version 25.1.1
25.1.1 Latest$$$$$$ - SQL Editor:$$$ - Added support for column expansion for CTEs$$$ - Added support for TSQL TOP expression$$$ - Added support for CTE names in sub-queries$$$ - Disabled SQL autocomplete inside DBeaver SQL commands$$$ - Fixed an issue where code completion failed in long queries when using column aliases$$$ - Fixed an issue where most of the output was lost after performing a search$$$ - AI assistant: GitHub Copilot authorization dialog was improved$$$ - Metadata Editor:$$$ - Added progress visualization for loading items and a message indicating when the list is empty$$$ - Fixed sorting of objects such as indexes$$$ - Fixed layout issues when resizing stacked multi-line fields$$$ - Data Editor: fixed cursor positioning after filter auto-completion$$$ - Navigator:$$$ - Fixed the Hide and Show Only filter options; added support for filtering by name with arguments$$$ - Fixed an exception that occurred when deleting an open project$$$ - Connectivity:$$$ - Fixed an issue where SSL settings were removed after adding an SSH profile$$$ - Redesigned the DBeaver connection profiles for improved structure and usability$$$ - After changing an expired database password; you can now immediately test the connection with the new password$$$ - General:$$$ - Transaction commit/rollback buttons now have drop-down menu which can show queries within this transaction$$$ - Fixed compact DDL generation for tables$$$ - Set English as the default language in the Microsoft Store distribution$$$ - Improved the appearance of several database logos in dark theme$$$ - Fixed an exception in the Output viewer$$$ - Databases:$$$ - CUBRID:$$$ - Added the ability to delete comments on Serial and Views (thanks to @longhaseng52)$$$ - Fixed an error that occurred when deleting properties and comments on the server (thanks to @longhaseng52)$$$ - Fixed an error when editing null values in the metadata editor (thanks to @longhaseng52)$$$ - Fixed an issue where view DDL was truncating UNION ALL statements (thanks to @Srltas)$$$ - Clickhouse:$$$ - Fixed the display of nested arrays in the data grid and SQL generation$$$ - Fixed an issue with folder display in the Navigator when using driver version 8.0.x or higher$$$ - Fixed data type loading and array editing issues$$$ - Removed Foreign Keys and References tabs from the Metadata Editor$$$ - DuckDB: Improved display of structured data type keys in the Data Editor$$$ - Exasol driver was updated to version to 25.2.3$$$ - Firebird: Removed AS before table alias for legacy Firebird$$$ - Neo4j was deleted from Community version$$$ - Oracle: Added column-level privileges to the Privileges view$$$ - PostgreSQL:$$$ - Fixed syntax highlighting for the INTERVAL keyword$$$ - Fixed an issue where database names containing slashes caused a connection error when accessing schemas$$$ - Salesforce Data Cloud: Now uses the shaded driver version by default (thanks to @jschneidereit)
DBeaver CE x64 Version 25.1.0
25.1.0 Latest$$$$$$ - SQL Editor:$$$ - If referenced table has an alias; its now always prepended before column name for semantic completion$$$ - Added a new setting for semantic completion to control fully-qualified column names$$$ - Fixed bind variables dialog layout for large fonts$$$ - Data Transfer: removed the All but nulls and added All including nulls option for CSV export$$$ - Miscellaneous:$$$ - Fixed misaligned editor window in the Bind Parameters dialog for macOS$$$ - Fixed an issue where the Tip of the Day window could block the application interface from loading$$$ - Fixed inconsistent application of connection colors for test and production connection types$$$ - Fixed application launch in CLI mode$$$ - General: The All file types option has been moved to the top of the file open dialog for easier access$$$ - Databases:$$$ - Clickhouse$$$ - Clickhouse driver was returned to version 0.8.5$$$ - Fixed quoting of nested array values$$$ - CUBRID: Fixed Info panel visibility$$$ - DuckDB:$$$ - Added option to hide system objects$$$ - Fixed geometry display issues in DuckDB version 1.2.2+$$$ - Simple structure compare wizard was fixed$$$ - MySQL: fixed primary key column creation$$$ - PostgreSQL: added support for wildcards in ILIKE filters within the data grid$$$ - SQL Server: fixed the Only connections option in Session Manager to display only active connection sessions as intended$$$ - Teradata: native date/time formatting is now disabled by default and can be enabled in the connection settings
DBeaver CE x64 Version 25.1.0
25.1.0 Latest$$$$$$ - SQL Editor:$$$ - If referenced table has an alias; its now always prepended before column name for semantic completion$$$ - Added a new setting for semantic completion to control fully-qualified column names$$$ - Fixed bind variables dialog layout for large fonts$$$ - Data Transfer: removed the All but nulls and added All including nulls option for CSV export$$$ - Miscellaneous:$$$ - Fixed misaligned editor window in the Bind Parameters dialog for macOS$$$ - Fixed an issue where the Tip of the Day window could block the application interface from loading$$$ - Fixed inconsistent application of connection colors for test and production connection types$$$ - Fixed application launch in CLI mode$$$ - General: The All file types option has been moved to the top of the file open dialog for easier access$$$ - Databases:$$$ - Clickhouse$$$ - Clickhouse driver was returned to version 0.8.5$$$ - Fixed quoting of nested array values$$$ - CUBRID: Fixed Info panel visibility$$$ - DuckDB:$$$ - Added option to hide system objects$$$ - Fixed geometry display issues in DuckDB version 1.2.2+$$$ - Simple structure compare wizard was fixed$$$ - MySQL: fixed primary key column creation$$$ - PostgreSQL: added support for wildcards in ILIKE filters within the data grid$$$ - SQL Server: fixed the Only connections option in Session Manager to display only active connection sessions as intended$$$ - Teradata: native date/time formatting is now disabled by default and can be enabled in the connection settings
DBeaver CE x64 Version 25.0.5
25.0.5 Latest$$$ - SQL Editor:$$$ - CTE completion and navigation support was significantly improved$$$ - SQL columns completion was fixed (issue with overlapping names)$$$ - Added support of STRAIGHT_JOIN and LATERAL JOIN$$$ - Several navigation shortcuts were fixed to avoid conflicts with European keyboard layouts$$$ - Metadata: Added the ability to resize multiline fields$$$ - Navigator:$$$ - Added the number of elements in folders$$$ - Fixed an issue that prevented schemas and databases from opening$$$ - Miscellaneous:$$$ - Added an extra CLI runner: dbeaverc. It respects settings in dbeaver.ini$$$ - When a user selects the driver version manually; it will no longer be updated automatically$$$ - Fixed the ability to use application when certain accessibility tools are enabled$$$ - Databases:$$$ - MySQL: Fixed remove definer option of backup/restore in a special case$$$ - Oracle: Set `Use UNION for table metadata reading` preference to true by default$$$ - PostgreSQL:$$$ - Fixed foreign servers display when no access to `pg_user_mapping` table$$$ - Execution hang on a query with a huge json in dollar-quoted strings with tag were fixed$$$ - Fixed an issue causing hangs when working with large JSON files$$$ - Allowed unquoted identifiers started with underscore$$$ - New drivers: Added support for Kingbase database
DBeaver CE x64 Version 25.0.4
SQL Editor: Added support for Common Table Expressions (CTE) by semantic analysis and autocompletion$$$ - Data Editor: When an inline editor is active and the user starts typing; the grid now automatically scrolls to the cell being edited to avoid unexpected cell editing$$$ - Connectivity:$$$ - Added an option to update a driver to a recommended version$$$ - Fixed an issue with replacing localhost with the IP address when connecting via SSH$$$ - Databases:$$$ - Clickhouse:$$$ - Clickhouse driver was update to version 0.8.5$$$ - Data type display was fixed$$$ - CUBRID: Added the ability to update user (thanks to @rathana-pvs)$$$ - GBase 8s: enhanced support for editing unique constraint and CHECK constraint (thanks to @Wintianis)$$$ - Firebird: Fixed native binary presentation (thanks to @niekschoemaker)$$$ - PostgreSQL:$$$ - Added the ability to backup all database schemas (using the Completed backup option) (thanks to @mikiubo)$$$ - Fixed Foreign data wrappers configurator opening$$$ - The retrieval of Collation was removed for older PostgreSQL versions (versions earlier than 9.1)$$$ - Snowflake driver was updated to version 3.23.0$$$ - SQLite: Added information about a tables Strict mode to the Table Metadata section (thanks to @eusebe-cda)$$$ - TDengine driver was updated to the latest version (thanks to @DuanKuanJun)
DBeaver CE x64 Version 25.0.2
25.0.2 $$$ - Navigator:$$$ - Filter behavior has been improved for a better user experience$$$ - Fixed filters for secondary DBeaver app windows$$$ - SQL Editor:$$$ - Query cancelation after retry was fixed$$$ - When the Blank Line is Statement Delimiter option is set to Smart; blank lines are now correctly recognized as script delimiters while executing queries as Script$$$ - Fixed missing space after the leading keyword in some cases$$$ - Miscellaneous:$$$ - Added an option to display the breadcrumbs in either the status bar or at the top of editors$$$ - Breadcrumbs now occupy less horizontal space in the status bar$$$ - Added the DBeaver icon to aarch64-linux package (thanks to @chirontt)$$$ - New Drivers: Added support for Teiid database (thanks to @edulauer)$$$ - Databases:$$$ - CUBRID:$$$ - Added statistics and trace information to the result tab (thanks to @rathana-pvs)$$$ - Fixed incorrect script generation when creating a trigger via UI (thanks to @longhaseng52)$$$ - Denodo: the connection name was modified to Denodo (thanks to @dlopezc-denodo)$$$ - GBase 8s: fixed creation of a table with a primary key (thanks to @Wintianis)$$$ - MariaDB: after changing an expired database password; you can now immediately test the connection with the new password$$$ - MariaDB/MySQL: fixed creation of auto_increment columns with primary key$$$ - Oracle: fixed view creation via Metadata editor$$$ - Sap Hana: fixed an issue with name editing when creating a table in Metadata Editor$$$ - Snowflake: fixed metadata queries for driver versions 3.13.20 and higher (thanks to @smheaton)$$$ - Teradata: fixed an exception that occurred during code completion
DBeaver CE x64 Version 25.0.1
- SQL Editor:$$$ - Fixed a bug in single-tab mode where script execution displayed results from the previous execution$$$ - Fixed the sql formatting for procedure calls with multiple argument$$$ - Improved buttons layout in result set view on execution error$$$ - Auto-refresh is now stopped if the result is not visible or DBeaver window is collapsed$$$ - SQL autocompetion: Fixed the ability to expand columns for table_alias.*$$$ - Added the ability to use the Short object names code completion option for columns$$$ - Command parameters now always highlighted with black$$$ - AI assistant: Fixed an issue where a query without a semicolon before @ai was skipped without an error message. Query will be executed even if there is no semicolon$$$ - Metadata Edtior:$$$ - Added the ability to view and edit comments in a popup window for improved user convenience$$$ - Fixed an issue where folder content in the Metadata Editor was not displayed immediately after opening an object$$$ - Data Editor: Removed options for copying column names and row numbers from the context menu for data cells$$$ - Diagram:$$$ - Updated the scrollbar color in the Diagram to match the expected design$$$ - Connectivity: Resolved the issue related to font rendering in the connection creation window$$$ - Security: Added the ability to enable TLS/SSL debug logging$$$ - Miscellaneous:$$$ - Breadcrumbs now update immediately when any included object is renamed$$$ - Popups for version update; Tip of the Day; and Sample Database are now displayed later if other modal windows are open; improving the user experience and reducing interruptions$$$ - Fixed the Open File dialog issue on Linux$$$ - Databases:$$$ - Azure SQL Server: The CREATE VIEW statement has been replaced with CREATE OR ALTER VIEW in the view DDL for Azure SQL Server v16 and higher$$$ - ClickHouse: Fixed issue with reading geometry data$$$ - CUBRID:$$$ - New column creation was fixed (thanks to @longhaseng52)$$$ - Added the ability to create and modify synonyms (thanks to @longhaseng52)$$$ - Databend: Fixed an issue with changing catalog names containing special characters (thanks to @rad-pat)$$$ - GBase 8s: Added the ability to edit table and column comments (thanks to @Wintianis)$$$ - Oceanbase: Diagram display was fxied$$$ - Oracle global variables such as SYSDATE and UID are now supported in query validation$$$ - PostgreSQL: Fixed an issue where selecting Exclude auto-generated columns excluded only identity columns but not other auto-generated columns (thanks to @f-m-t-t-m)$$$ - PostgreSQL:$$$ - Fixed an issue where the Show partitions option was hiding permissions in the DDL view (thanks to @f-m-t-t-m)$$$ - Added the ability to cancel queries in the Session manager (thanks to @mikiubo)$$$ - Fixed the display of the back slash symbol in comment blocks after refresh$$$ - SQLite: BLOB display was improved (thanks to @eusebe-cda)$$$ - SQL Server: Fixed table hints parsing$$$ - Yellowbrick: Added support for geospatial data
DBeaver CE x64 Version 25.0.0
25.0.0$$$Changes since 24.3.5:$$$- Data Editor:$$$- Added a suggestion to check spatial column visibility when enabling the spatial view$$$- Data cells search algorithm fixed (find/replace)$$$- SQL Editor:$$$- The schema selector is now hidden when it is not applicable to the current connection$$$- @include command execution was fixed$$$- Transaction mode refresh on script database change was fixed$$$- Improved performance of reading data in the SQL console$$$- Changed default shortcuts for the Result set zoom to Alt+0 and Alt+9 (to avoid conflicts with European layouts)$$$- Proposal sorting in code completion was improved: joins are always on the top$$$- Joins auto-completion was improved$$$- AI Assistant: Fixed excessive AI requests when AI is disabled (in the extension)$$$- Diagrams:$$$- Table comments and fully qualified names visiblity was fixed$$$- ER Diagram tab was renamed to Diagram$$$- Metadata Editor: columns and other objects reordering was fixed$$$- Navigator: schema indexes and triggers are now sorted in ascending order$$$- Connectivity: fixed an issue where the connection name was replaced with localhost$$$- Data transfer:$$$- Connection recovery was fixed for stuck data transfer jobs$$$- CSV export: array formatting was fixed$$$- Miscellaneous:$$$- SQLite database files can be opened directly from OS file explorer (MacOS and Windows) or with CTRL+O shortcut$$$- Splash screens were updated$$$- Monospace font is now used for HEX; JSON; XML; and other content editors$$$- All app settings are reset when the Reset Settings option is selected during installation$$$- Blurry application icon in Windows was improved$$$- Windows Store application configuration was fixed$$$- Fixed issue with saving timezone in Preferences$$$- Databases:$$$- Jennifer driver was updated to version v5.5.3.2$$$- MySQL: Fixed an issue with restricted access for users without SHOW DATABASES permission$$$- MariaDB:$$$- Added the ability to change expired password$$$- MariaDB driver was updated to version 3.5.2$$$- MySQL: issue with duplicated check constraints was fixed$$$- Oracle: Fixed index declaration in Oracle 23.1.0$$$- PostgreSQL:$$$- Added the ability to replace legacy timezone (on connection dialog)$$$- Fixed transaction mode changing after the connection reopen$$$- Fixed an issue with display database size after the connection refresh (thanks to @f-m-t-t-m)$$$- Added the ability to change the storage strategy (PLAIN ; EXTERNAL ; EXTENDED) for a column (thanks to @eusebe-cda)$$$- Redshift: query performance and stability was significantly improved$$$- Snappy driver was updated to version 2.11-1.3.0$$$- Localization: Fixed typo in Russian localization (thanks to @mikiubo)
DBeaver CE x64 Version 24.3.5
SQL Editor:$$$- Client-side commands color highlighted was improved$$$- Added menu options for refresh current schema and all schemas$$$- Code completions options were renamed to Semantic (the default) and Legacy$$$- Semantic autocompletion:$$$ - Added support for the function names$$$ - Fixed incorrect proposals for trees with missing nodes$$$ - Improved support for DESC; ORDER; LIMIT and other keywords$$$- Alphabetic proposals ordering was disabled by default$$$ - Fixed duplicates in Combined autocompletion mode$$$ - Script execute statistics rendering was improved (most valuable fields got first)$$$ - Data Editor:$$$- Fixed the context menu for column names copy$$$ - Saving data in JSON format was fixed$$$ - Find/Replace dialog was fixed$$$ - Data Transfer:$$$ - Added the ability to format arrays during the Data Export (thanks to @dheeru12)$$$ - Using ${scriptFilename} during the export in file was fixed$$$- Miscellaneous:$$$ - Editor breadcrumbs were redesigned and moved to the bottom toolbar$$$ - Database Navigator filters were fixed$$$ - Several icons were updated$$$ - Opening of the Git panel in Git extension was fixed$$$ - Sample database create popup was fixed$$$ - Fixed the search of SQL files thru editors menu$$$- Databases:$$$ - Azure Databricks:$$$ - Driver version was updated 2.7.1.1004 due to the update to Java 21$$$ - Schemas are now displayed in Database Navigator$$$ - Cloudberry: site URL was updated$$$ - CUBRID: Fixed deletion of comments and default values from columns via UI (thanks to @longhaseng52)$$$ - Kognito and Data Virtuality drivers were removed as these databases are no longer available$$$ - PostgreSQL:$$$ - Added an option to hide idle sessions (thanks to @f-m-t-t-m)$$$ - Fixed deleting comment in Metadata editor (thanks to @eusebe-cda)$$$ - Exception appeared when using F5 was fixed$$$- PostgreSQL: fixed keywords formatting$$$ - Snowflake driver was updated to the latest version to address issues related to the migration to Java 21$$$ - SQLite driver was updated to version 3.48.0.0
DBeaver CE x64 Version 24.3.4
SQL Editor:$$$Added the ability to use multi-line variables in SQL scripts$$$New autocompletion engine was improved and enabled by default:$$$Autocomplete performance was significantly improved$$$Fixed an issue with autocomplete failure after the dot$$$Fixed autocomplete for JOIN conditions$$$Fixed an issue with not executed included scripts$$$Fixed alias case sensitivity in autocomplete$$$Changed an icon for derived column in autocompletion proposals$$$ER Diagram: Added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram$$$Query Manager: Query duration formatting was fixed$$$Data Editor:$$$Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data$$$Fixed row coloring when querying multiple tables$$$Data Transfer: Removed the ability to change data type for existing columns in Data Export$$$$$$Database Navigator: Database object filter was improved. Connection filter is enabled by default$$$Miscellaneous:$$$Migrated to Java 21$$$Added the ability to associate different file types with DBeaver on Windows and macOS$$$Bookmark view is now working again$$$Font in error messages was changed to monospace$$$Commit/Rollback monitor was fixed$$$Fixed bold font display for theming on macOS$$$Databases:$$$Azure Databricks: information_schema was added to Database Navigator$$$Databend: Icons were updated$$$CUBRID:$$$Fixed index creation preview$$$Fixed column creation with STRING and similar data types$$$Procedure; function; and view names are now displayed in lowercase$$$Added the ability to change comments for foreign key columns$$$LibSQL: UI for token-based authentication was added$$$Machbase: Driver was updated to version 8.0.2$$$MySQL/MariaDB: Explain plan now works for all types of SQL queries$$$Oracle:$$$Fixed DDL generation for table spaces$$$Fixed user password changing$$$PostgreSQL: Fixed an issue with disappearing ENUM definition after refresh in Metadata Editor$$$Salesforce Data Cloud:$$$Removed the ability to edit database metadata$$$The latest driver version is now downloaded by default$$$SAP HANA: Partition view was added$$$SQLite: STRICT mode support was added$$$SQL Server:$$$Index creation was fixed$$$Fixed an issue where the index type couldnt be changed to unique$$$Teradata:$$$XML column value save was fixed$$$Removed incorrect warning message after executing SHOW and similar queries
DBeaver CE x64 Version 24.3.2
- 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 CE x64 Version 24.3.1
24.3.1 Latest$$$@serge-rider serge-rider released this 2 days ago$$$ $$$ - 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:$$$ - .gitignore for IDEA files was configured (thanks to @anton-erofeev)$$$ - Building 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 generation is now respected
DBeaver CE x64 Version 24.3.0
Changes since 24.2.5:$$$ - 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$$$ - Its 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
DBeaver CE x64 Version 24.2.5
24.2.5 Latest$$$ - 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 CE x64 Version 24.2.4
24.2.4 Latest$$$- 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 CE x64 Version 24.2.3
24.2.3 Latest$$$$$$ - 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 CE x64 Version 24.2.2
24.2.2$$$ - 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$$$ - 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$$$ - 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 CE x64 Version 24.2.1
24.2.1$$$$$$ - 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 CE x64 Version 24.2.0
Changes since 24.1.5:$$$ - 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 fixed$$$ - SQL Server:$$$ - SQL Server driver was updated to version 12.8.0$$$ - Fixed DDL and column display with custom data types$$$ - Localization: French localization was updated (thanks to @KawtharAlakri)$$$
DBeaver CE x64 Version 24.1.4
DBeaver 24.1.4$$$Posted on 2024-08-04 by Serge$$$SQL Editor:$$$Problem markers with semantic error descriptions were added. You can click on the problem description in the tooltip to find out what is wrong with the query.$$$INSERT; DELETE; UPDATE; DROP; CREATE; and ALTER statements execution in read-only mode was prohibited$$$Smart mode for Blank line state delimiter was improved$$$Simultaneous query execution was fixed: if a query is already being executed; you can execute another query in a new tab only$$$Composite type field color became visible in the Dark theme$$$Completion analyzer performance was enhanced$$$Data Editor:$$$Inline editing of geometry fields was fixed$$$New keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings; without opening a popup window$$$Metadata Editor: Generate SQL option in the context menu was fixed$$$Connectivity: Closing idle connections and default timeout were fixed$$$General:$$$Users can import connections from SQL Workbench and DbVizualizer$$$Wayland support on Linux was fixed$$$Several code improvements have been made (thanks to @KonstantinRight)$$$Databases:$$$GaussDB driver was added (thanks to @GaussDB-Fans)$$$Couchbase: Legacy Couchbase driver was removed$$$CUBRID:$$$Execution plan was enhanced (thanks to @rathana-pvs)$$$Issue with Null datatype was fixed (thanks to @longhaseng52)$$$Creating partition option was removed (thanks to @longhaseng52)$$$InterSystems IRIS driver was updated to version 2024.1 (thanks to @isc-rsingh)$$$PostgreSQL: If the database name is empty; it will be set to the same as the username$$$SAP Hana: Additional system table prefix was added (thanks to @kai-morich)$$$SQL Server: Ability to upgrade/install the driver was fixed
DBeaver CE x64 Version 24.1.3
- SQL Editor:$$$ - Added ability to disconnect from the datasourse when all associated editors were closed (configurable)$$$ - New autocompletion engine was significantly enhanced$$$ - Autocompletion for derived columns in sub-queries was improved$$$ - Autocomplete suggestions inside literals in INSERT INTO were disabled$$$ - Execution of the corrected SQL script was fixed$$$ - Recent SQL script was renamed to the Last edited SQL script$$$ - Short/long object names completion configuration was redesigned$$$ - Metadata editor: Composite data types presentation was added for table columns$$$ - Data editor: JSON and XML panels performance was enhanced$$$ - Data transfer:$$$ - Compress option behavior was fixed$$$ - Wizard window auto-size was fixed$$$ - Task management: Broken exported file extension after the task editing was fixed$$$ - Dashboards: Project dashboard UX was improved$$$ - Connectivity:$$$ - Connections invalidation after sleep mode was added$$$ - Idle connections timeout was fixed$$$ - General:$$$ - Establishing connection visualization was added to Database Navigator and Projects$$$ - Tooltip delay on macOS was reduced and became configurable$$$ - Saving script outside the Script folder was fixed$$$ - SVG extension was moved to the PRO version$$$ - Authentication in embedded browser was temporarily disabled on Linux$$$ - Databases:$$$ - Altibase:$$$ - Added the ability to compile procedure; function; or package from the UI as well as truncate table and refresh materialized view (thanks to @zennken)$$$ - Added status of the view; materialized view; procedure; function; or package (thanks to @zennken)$$$ - Execution plan parsing error was fixed (thanks to @zennken)$$$ - Clickhouse:$$$ - DateTime32 formatting was fixed$$$ - IPV6 data presentation was added (thanks to @asifjoardar)$$$ - Complex structure display in the Data grid was fixed$$$ - CUBRID:$$$ - View creation was added to the UI (thanks to @longhaseng52)$$$ - Supported keywords for SQL Editor were reviewed and updated (thanks to @rathana-pvs)$$$ - Ability to edit Serial using UI was added (thanks to @longhaseng52)$$$ - DuckDB: Data edit was fixed$$$ - Microsoft Azure driver was updated to version 12.7.0$$$ - Oracle: DDL generation for Oracle Tablespaces was added (thanks to @pandya09)$$$ - PostgreSQL:$$$ - Specific functions were supported in the SQL Editor (thanks to @EastLord)$$$ - Metadata read was fixed$$$ - Redshift:$$$ - Metadata reading for indexes was disabled$$$ - Problems with broken connection were resolved$$$ - SAP IQ: Duplicated output messages were fixed$$$ - Teradata: Database name became optional for connection$$$ - Vertica: Incorrect query execution with the cursor at the end was fixed$$$ - Localization:$$$ - Italian localization was updated (thanks to @Gnafu)
DBeaver CE x64 Version 24.1.2
24.1.2 Latest$$$ - SQL Editor:$$$ - Performance in Smart mode of Blank line as a statement delimiter was enhanced$$$ - Ability to show all SQL scripts from the main toolbar was added$$$ - Syntax highlighting for functions with multiple arguments was fixed$$$ - SQL datatype color use was corrected$$$ - DROP statement support was added to Outline$$$ - Metadata Editor: Foreign Key creation dialog UIX was improved$$$ - Data Editor:$$$ - Indication of the table read-only/editable mode was added$$$ - Information about active unique key used for data edit was added$$$ - Customise and Save filter buttons were moved to the dropdown$$$ - Issue with too small Result Set Order/Filter Settings window was resolved$$$ - Rollback timer flickering was fixed$$$ - Query Manager: information about database schema and catalog was added to the detailed record view$$$ - Simple Structure Compare: issue with long file names was resolved$$$ - Connectivity:$$$ - Issue with default SSH connection timeout was resolved$$$ - Driver downloading problem reporting was fixed$$$ - General:$$$ - Incorrect button behavior in the confirmation dialog was fixed$$$ - Security credential encryption was enhanced (thanks to @longhaseng52)$$$ - Toolbar and Data Editor background on the Dark theme was improved$$$ - Smart commit mode indication was fixed$$$ - Issue with metadata cache reading was resolved$$$ - Automatic resize of connection dialog and tasks dialogs was fixed$$$ - Databases:$$$ - Clickhouse:$$$ - Complex structures handling was fixed$$$ - Clickhouse driver was updated to version 0.6.1$$$ - CUBRID: db_server information was added to the Database Navigator$$$ - Oracle: Connection error in the application downloaded from the Microsoft Store was fixed$$$ - PostgreSQL: Dollar-quoted string parsing was fixed$$$ - SQL Server:$$$ - Issue with resultset primary key detection was resolved$$$ - Duplicated output when running stored procedures was fixed$$$ - NTLM Authentication was fixed$$$ - Datetime datatype representation was fixed
DBeaver CE x64 Version 24.1.1
- AI: GPT-4o model was supported$$$ - SQL Editor:$$$ - Auto-save editor setting was enabled by default$$$ - ILIKE keyword was supported$$$ - Support for unsigned numbers in GROUP BY clause was added$$$ - Syntax highlighting and outline viewer support parameter changes in SQL Processing settings$$$ - Links to the SQL Editor and Visual Query Builder were added to the Context menu$$$ - Buttons in the right toolbar were renamed$$$ - Print mode in ER Diagrams and Execution plan was fixed$$$ - Saving Diagram outside the workspace was fixed$$$ - Data Editor:$$$ - Information about table unique key is displayed in the grid$$$ - BETWEEN and LIKE keywords were added to filetr autocomplection$$$ - Data transfer:$$$ - Export of data with backticks was fixed (thanks to @diashalabi)$$$ - Export of binary columns in JSON format was fixed$$$ - General:$$$ - Ability to restore default settings was fixed in SQL Editor Formatting settings; SQL Editor settings; SQL Editor Commit type; Error handling settings; and Hex Editor default width$$$ - Creating a view from the UI was fixed$$$ - Buttons display when creating new dashboard was fixed$$$ - New table creation was fixed$$$ - The following drivers were updated:$$$ - Firebird to version 5.0.4$$$ - Redshift to 2.1.0.29$$$ - Informix to 4.50.JC10W1$$$ - Databases$$$ - Altibase: Search for server properties was added (thanks to @zennken)$$$ - BigQuery: Ability to see bytes billed in Statistics panel in the Data Editor was added$$$ - Cubrid:$$$ - Execution plan coloring was enhanced (thanks to @hwany7seo)$$$ - Ability to create a table via UI was added (thanks to @longhaseng52)$$$ - DDL display for a view was added together with the ability to display the list of indexes; synonyms; serials; triggers; and procedures (thanks to @longhaseng52)$$$ - Ping query for keep connection alive was added (thanks to @rathana-pvs)$$$ - Partition display was added (thanks to @rathana-pvs)$$$ - PostgreSQL:$$$ - If database field in connection settings is empty; user name is used as a database name$$$ - Work of Use fully qualified names setting was fixed for views$$$ - Redis: Key settings were fixed$$$ - Redshift: Constraint creation was fixed$$$ - Vertica: Stored procedures handling in SQL Editor was fixed
DBeaver CE x64 Version 24.1.0
24.1.0 Latest$$$Changes since 24.0.5:$$$ - SQL Editor: issue with extra linefeed during autocompletion was fixed$$$ - Data Editor: loading data when fast scrolling using the keyboard was fixed$$$ - Database tasks:$$$ - Maximum execution time option was added$$$ - Tasks running from non-default workspace was fixed$$$ - Connectivity:$$$ - Azure AD was renamed to Microsoft Entra ID$$$ - Links to database support documentation were added for many databases$$$ - Automatical termination of the shell command script Before connect was fixed$$$ - General:$$$ - Crash when closing detached editor tab in another window was fixed$$$ - Restore default for Metadata read; Client identification settings was fixed$$$ - .projects and .settings folders became findable in Projects when the application is used as an Eclipse plugin$$$ - Truncated notifications were fixed$$$ - Projects:$$$ - Disconnecting a database from the Project view was fixed$$$ - Opening a bookmark after changing the application language was fixed (thanks to @SASUKE38)$$$ - ERD: loading diagrams for drivers with broken foreign keys support was fixed$$$ - Database Navigator:$$$ - Color of the table statistics was changed to visible in the dark theme and became configurable$$$ - Deleting connection option in the context menu was renamed to Delete connection$$$ - Databases:$$$ - CrateDB: table DDL was fixed$$$ - Databricks: authentication with personal access token was added$$$ - DB2i: procedure creation was fixed$$$ - DuckDB: aliases autocompletion was fixed$$$ - H2: foreign keys presentation was fixed$$$ - Oracle: JSON data type support was improved$$$ - PostgreSQL: support of fully qualified names in DDL was fixed$$$ - Localization:$$$ - German localization was updated (thanks to @maxbobse)
DBeaver CE x64 Version 24.0.5
24.0.5 Latest$$$$$$- SQL Editor:$$$ - Smart mode for statement delimiter was improved$$$ - Default option for the setting Blank line is statement delimiter was changed to Always$$$ - Cursor behavior during autocompletion was improved$$$ - Code highlighting issue with a quoted identifier in case of no connection was fixed$$$ - High CPU usage for large script was fixed$$$ - Metadata Editor:$$$ - Highlighting for created entities was changed to green$$$ - Virtual foreign keys: reference table container selector was fixed$$$ - Database Navigator: CTRL+C and other shortcuts behavior after the application startup were fixed$$$ - AI (extension): custom scope performance was improved$$$ - General:$$$ - Opening editors for files with special symbols in names was fixed$$$ - Portable distribution of the application was fixed (config files location)$$$ - Licensing for some source files was fixed$$$ - Eclipse plugin: new database objects create was fix$$$ - Databases$$$ - DuckDB: Spatial data visualization support was added$$$ - Oracle:$$$ - Partition type display was added$$$ - Materialized view refresh was fixed$$$ - SQL Server: Default IDENTITY was changed to (1;1) (thanks to @Sgierek106)$$$ - Vertica: LOOP - END LOOP as a block and DECLARE were added to the syntax analyser
DBeaver CE x64 Version 24.0.4
24.0.4 Latest$$$$$$ - SQL Editor:$$$ - Smart mode for Blank line is statement delimiter setting was fixed$$$ - Vertical button alignment was fixed$$$ - ER Diagrams: Keep layout selection was fixed$$$ - Data transfer:$$$ - Import from CSV with duplicated columns names was fixed$$$ - Parallel data transfer monitoring/cancellation were fixed$$$ - Dashboards:$$$ - Ability to drag and drop charts to another dashboard was added$$$ - Number of minor UI improvements were added$$$ - Connectivity:$$$ - SSH parameters validation on the Connection page was added$$$ - Editing of Local host and Remote host fields in the Port Forwarding section was fixed$$$ - Database connection timeout notification was fixed$$$ - Development: Redundant tests were disabled$$$ - Databases$$$ - MariaDB:$$$ - GRANT OPTION privilege persistence was fixed$$$ - Schema privileges representation was fixed$$$ - SQL Server: trigger deletion was fixed$$$ - Teradata: link to the referenced table in the Metadata editor was added$$$ - Localization: French translation was updated (thanks to @Jean-BaptisteC)$$$ - General:$$$ - Language configuration in Windows installer was fixed$$$ - We have migrated to Eclipse 2024/06
DBeaver CE x64 Version 24.0.3
24.0.3 Latest$$$ - General:$$$ - Migration from Toad for Oracle was supported$$$ - Sensitive information in the log files is now masked$$$ - SQL Editor:$$$ - Smart mode for Blank line as statement delimiter option was added (enabled by default)$$$ - Sub-select autocompletion was added$$$ - Highlighting of column references in INSERT queries was fixed$$$ - Outline viewer opening was fixed$$$ - Issue with hidden text on macOS was fixed$$$ - Connectivity:$$$ - Space trimming when saving user credentials was added$$$ - Saving SSH configuration with missing AWS private key was fixed$$$ - Reconnecting via SSH tunnel was fixed$$$ - ER Diagrams: foreign keys presentation was fixed$$$ - AI:$$$ - AI assistant is enabled by default$$$ - Database metadata collection was fixed$$$ - Dashboards: disappearance of custom dashboards after version update was fixed$$$ - Connectivity:$$$ - Space trimming when saving user credentials was added$$$ - Saving SSH configuration with missing AWS private key was fixed$$$ - Reconnecting via SSH tunnel was fixed
DBeaver CE x64 Version 24.0.2
24.0.2 Latest$$$ - Connectivity:$$$ - Using multiple jumps tunnels when connecting via SSH was supported$$$ - Enable tunnel sharing option was added$$$ - Test connection was fixed$$$ - SQL Editor:$$$ - WHERE TRUE and SELECT UNIQUE support was added$$$ - Error with single quoted string was fixed$$$ - Syntax highlighting after active schema change was fixed$$$ - Data Editor:$$$ - Automatic row count option was added (thanks to @utsav1704)$$$ - Metadata editor:$$$ - Deleting table comments was fixed$$$ - Linking with the editor was fixed$$$ - General:$$$ - Ability to collect log files from the interface was added$$$ - Transaction rollback behavior was fixed$$$ - Metadata changes were removed from the commit counter$$$ - Autocommit in production databases was fixed$$$ - Data transfer:$$$ - Ability to specify header case in the target file was added$$$ - Typo in the confirmation dialog was fixed$$$ - Databases:$$$ - Cubrid: Query plan feature was added (thanks to @rathana-pvs)$$$ - Old MySQL drivers were repacked$$$ - PostgreSQL: Jobs; roles; and system information were hidden in the Hide Folders mode$$$ - SQLite: Deleting columns was fixed
DBeaver CE x64 Version 24.0.1
24.0.1 Latest$$$@serge-rider serge-rider released this last week$$$ 24.0.1$$$ e3d108b$$$ - Connectivity:$$$ - Shared SSH sessions support was added$$$ - Connection via native proxy was fixed$$$ - Dark theme support on the Connection page was improved$$$ - SQL Editor:$$$ - Highlighting; validation; and outline for INSERT; UPDATE; and DELETE were supported$$$ - Incorrect cursor position during autocomplete was fixed$$$ - QUALIFY keyword was supported (thanks to @ashu7896)$$$ - Metadata editor: automatic reference column creation for a new foreign key was implemented$$$ - Data Editor:$$$ - Opening of a table with empty data was fixed$$$ - SRID editing was fixed$$$ - General:$$$ - SVG icons support was added$$$ - Error when checking checkboxes in the Formatting page in Preferences was fixed$$$ - Disappearance of renamed project was fixed (thanks to @saikotek)$$$ - Databases$$$ - Dameng: Sequence creation was fixed$$$ - DuckDB:$$$ - Sequences; views; and table definitions were supported$$$ - Ability to add comments via UI was added$$$ - MySQL: link to the driver documentation was fixed$$$ - RisingWave: non-working functions and folders were removed$$$ - PostgreSQL: issues with scheduled jobs was resolved$$$ - SQLite: errors when creating table was fixed$$$ - SQL Server: redundant authentication types were hidden$$$ - Sybase: stored procedures support was improved$$$ - Teradata: procedures and functions DDLs reading was enhanced$$$ - Localization:$$$ - Romanian language support was added (thanks to @v613)$$$ - French translation was updated (thanks to @Jean-BaptisteC)
DBeaver CE x64 Version 24.0.0
DBeaver 24.0.0$$$March 3rd; 2024$$$$$$Changes since 23.3.5:$$$ - SQL Editor:$$$ - Nested CASE statements were supported$$$ - Deleting queries from Outline was fixed$$$ - Type casts support was improved$$$ - Handling of right-click on collapsed query was fixed$$$ - Expanding collapsed group after the code execution was fixed$$$ - Metadata editor: changing the key name when a constraint is changed$$$ - Data Editor: SRID switching in the Spatial data viewer was fixed$$$ - ER Diagram:$$$ - Missing connection lines were fixed$$$ - Mikami-Tabuchi routing type was disabled$$$ - AI:$$$ - Comment presentation was improved$$$ - Sending unique keys and indexes was fixed$$$ - Data Transfer:$$$ - Export statistic was fixed$$$ - Import blocking in case of table creation restriction was fixed$$$ - Stack overflow on Linux was fixed$$$ - Connectivity: closing timeout for an idle connection was increased and disabled for embedded drivers$$$ - Security:$$$ - Vulnerabilities display in Elasticsearch was fixed$$$ - PosgtreSQL driver was upgraded due to CVE-2024-1597$$$ - General:$$$ - Smart commit mode was enhanced: if the manual commit mode was enabled and just after it the query failed; the smart commit mode is enabled again$$$ - Links between preference pages were fixed$$$ - Issue with not found tables was fixed$$$ - Release note display was corrected$$$ - Driver libraries download was fixed$$$ - Previous workspace format was supported$$$ - Usage statistics popup was redesigned$$$ - Databases:$$$ - DuckDB: WSL paths handling was fixed$$$ - Greenplum: STRICT keyword was added to function definition$$$ - Hana: Switch to the Kerberos authentication in the Connection page was fixed$$$ - MariaDB: The exported JSON format was fixed$$$ - MySQL and MariaDB:$$$ - Disable Triggers option was added to the Context menu$$$ - Case-sensitive option was added to the metadata search$$$ - Databases with the same name but different name case are considered as different databases$$$ - Oracle:$$$ - Generating DDL for triggers was fixed$$$ - SQL Server: additional table properties were added for tables and views in the properties editor$$$ - Yellowbricks icons and link to the website were changed
DBeaver CE x64 Version 23.3.3
DBeaver 23.3.3$$$January 21st; 2024$$$$$$Metadata editor:$$$Object creation dialog was redesigned$$$SQL Editor:$$$Autocomplete for INSERT statements was fixed$$$Case sensitivity on highlighting and validation was fixed$$$Duplicated table aliases in autocomplete were fixed$$$Column aliases highlighting was fixed$$$Dot character is not allowed again in variable name$$$Data Editor: Column descriptions are displayed again$$$Database Tasks: Display of task execution time was fixed$$$ER Diagram: One-to-one connection rendering for unique/primary key was fixed$$$Data Transfer:$$$All columns can be marked as skipped when exporting data$$$Statistics was excluded from exported data$$$General:$$$Changing the monospace font was fixed$$$Unique key creation was fixed$$$Finding local clients on Linux and macOS was improved$$$Databases:$$$Altibase support was added (thanks to @zennken)$$$BigQuery: Structs and arrays are supported$$$Dameng:$$$Dameng driver was updated$$$Users; roles; and categories are supported (thanks to @Stkai)$$$MySQL: Path to the local client was fixed$$$MySQL and MariaDB: Rendering columns with unique identifiers was fixed$$$PostgreSQL:$$$Schema permissions display was fixed$$$Confirmation message for clean option of restore wizard was fixed$$$SQLite: Import with ‘truncate target tables before load’ option was fixed$$$SQL Server:$$$Check constraint option was removed from primary/unique key creation page$$$Displaying source in the index properties was fixed (thanks to @HansenChristoffer)$$$SQL Server driver was updated$$$Localization:$$$Japanese localization was updated (thanks to @doew)$$$Misc:$$$Microsoft Store version was fixed$$$Starting application when the workspace directory is a link was fixed
DBeaver CE x64 Version 23.3.2
23.3.2 Latest$$$ - Metadata editor:$$$ - New database objects wizard was redesigned$$$ - Primary/unique key can be created automatically along with new columns$$$ - SQL Editor:$$$ - Outline viewer of SQL queries structure was added$$$ - Execution time format was improved$$$ - Toolbar customization page opening was fixed$$$ - Identifiers coloring was improved$$$ - Autocomplete was fixed for multiline comments$$$ - Accessibility: notifications can be read with a screen reader (JAWs; NVDA or Narrator)$$$ - ER Diagram: connection errors handling was added$$$ - Data Transfer: Iicorrect links in settings were fixed$$$ - AI: legacy OpenAI models were removed$$$ - General:$$$ - Incorrect links to help articles were fixed$$$ - Redundant items were deleted from the Context menu$$$ - Global network settings preferences page is available again$$$ - Databases:$$$ - ClickHouse: leagacy driver configuration was fixed$$$ - Dameng: tablespaces are supported (thanks to @Stkai)$$$ - Google Cloud SQL: redundant options were removed from the context menu$$$ - MySQL: TLS 1.3 support was added$$$ - MySQL and PostgreSQL: local native database clients can be found on macOS and Linux$$$ - Teradata: metadata search was significantly enhanced$$$ - Localization:$$$ - Ukrainian localization was added (thanks to @CrazyTapok-bit)$$$ - Italian translation was improved (thanks to @coluzziandrea)$$$ - Portuguese localization was fixed
DBeaver CE x64 Version 23.3.1
- SQL Editor:$$$ - New highlighting and script validation were enabled by default$$$ - SQL highlighting performance was improved$$$ - Connection variables and system environment variables now accessible from SQ Leditor$$$ - Handling of special characters was fixed$$$ - Data Editor:$$$ - Value selector panel was improved: you can switch the active panel with Ctrl+Tab and change the active value in the context menu$$$ - Advanced paste of multiple records was enhanced$$$ - Spatial data zooming was improved (thanks to @kalkun)$$$ - ER Diagrams:$$$ - Diagram layout was enhanced$$$ - Data Transfer:$$$ - Users can change the data export task output format$$$ - Data export from table to table was fixed$$$ - Security:$$$ - Oracle driver version was updated to 23.2.0.0$$$ - General:$$$ - We switched to Eclipse 2023-12$$$ - Language detection for locale containing language and country was fixed$$$ - Workspace opening was fixed$$$ - ‘Statistic’ tab display was fixed$$$ - Broken links in connection dialogs were fixed$$$ - New foreign key name generation was fixed$$$ - Databases:$$$ - DB2: Loading schema statistics was fixed$$$ - EDB: Packages duplicating schemas in the Database Navigator were removed$$$ - Firebird: Function and procedure presentation was enhanced$$$ - Google Bigtable name was corrected$$$ - Greenplum: Rows policies were supported$$$ - MariaDB: Result fetch size was fixed$$$ - PostgreSQL:$$$ - Indexes and constraints are displayed in partition DDL$$$ - Backup of several schemas and several tables was enhanced
DBeaver CE x64 Version 23.3.0
Changes since 23.2.5:$$$ - Security: database drivers were updated due to security reasons: DB2; Google BigQuery; Athena; and YugabyteDB$$$ - SQL Editor:$$$ - Autocompletion of column names with special characters was fixed$$$ - Output panel display in the statistics tab was fixed$$$ - Selected query execution was fixed$$$ - Queries with CTE execution was fixed$$$ - Data Editor:$$$ - Filter value search was fixed$$$ - Advanced Copy as HTML with spaces in the column names was fixed$$$ - Numeric value infinity representation was fixed$$$ - ER Diagrams:$$$ - Diagram update on metadata changes was fixed$$$ - Automatic re-layout on notation or routing change was fixed$$$ - General:$$$ - Tips of the day were updated$$$ - Constraints rename was fixed$$$ - Idle transaction rollback notification was fixed$$$ - Data Transfer:$$$ - Native clients were renamed into Local clients$$$ - Update on conflict behavior was improved (now it respects indexes too)$$$ - Database restore was fixed$$$ - List of supported variables was updated$$$ - Database tasks: missing line break was added to the task log file$$$ - Connections:$$$ - Driver download error handle was fixed was fixed$$$ - ‘Check for new driver version’ setting save was fixed$$$ - Databases:$$$ - Firebird: default values for procedure parameters are now displayed$$$ - PostgreSQL/Greenplum: foreign key creation was fixed$$$ - MySQL5 driver is available again$$$ - Oracle: comments were added to the newly created columns$$$ - A number of minor UI bugs were fixed
DBeaver CE x64 Version 23.2.5
- SQL editor:$$$ - Syntax coloring and code completion: smart columns abd aliases recognition was added (experimental)$$$ - Numerous improvements in single-tab results visualization$$$ - Quoting of identifiers with special characters was fixed$$$ - Issue with read-only column in queries with comments was resolved$$$ - COMMIT/ROLLBACK statements are now recognized as transaction state change statements$$$ - Data transfer:$$$ - Issue with unquoted column names was resolved (data import)$$$ - File import toolbar was redesigned$$$ - Library for XLSX export/import was updated; many minor issues were resolved$$$ - Accessibility:$$$ - Screen-readers support was improved (JAWS)$$$ - Editor tab names reading was fixed$$$ - ER diagrams: issues with notation switch were resolved$$$ - General:$$$ - Issue with output file name after multiple executions of data export task was resolved$$$ - Error Data transfer IO error was resolved$$$ - Comments in generated DDL now can be disabled (configurable)$$$ - Countdown visualization before auto-close was added for idle transactions$$$ - Extra tips added in connection keep-alive configuration$$$ - Database navigator: click in empty space handle was fixed (thanks to @itsyfx)$$$ - Databases:$$$ - MySQL:$$$ - Driver version was upgraded to 8.2$$$ - Legacy MySQL 5.x driver was deprecated and replaced with MySQL 8 driver$$$ - Oracle:$$$ - Materialized views indexes management was supported$$$ - Materialized views permissions and dependencies view was added$$$ - Column alter DDL was fixed (NULL clause)$$$ - PostgreSQL:$$$ - Issue with VARCHAR limit change was fixed$$$ - Function comment delete support was added$$$ - SQL Server: extra dialect keyword were added (thanks to @brunodmartins)
DBeaver CE x64 Version 23.2.0
- Changes since 23.1.5:$$$ - Data Editor:$$$ - Spatial values rendering was fixed$$$ - Spatial images capture was fixed$$$ - Special characters rendering was improved$$$ - Grouping panel icons were improved$$$ - ER Diagrams: saved diagrams now can be opened on another computers$$$ - Data transfer: import settings handling was improved$$$ - Accessibility:$$$ - Connection dialog now supports screen readers$$$ - Cell value reading was improved$$$ - Ctrl+Shift/Alt+PageDn: vertical tabs switch$$$ - Ctrl+ALT+6: SQL editor and results tab switch$$$ - Ctrl+Shift+Enter now opens ER diagram entities$$$ - Ctrl+Shift+N: new connection dialog open$$$ - Database drivers:$$$ - Bigquery: DDL for tables; views and stored procedures was added$$$ - Clickhouse: arrays and structures visualization was fixed$$$ - Greenplum: external tables reading was fixed$$$ - Teradata: issue with the missing templates was fixed$$$ - Many minor UI and database issues were resolved
DBeaver CE x64 Version 23.1.5
- 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 CE x64 Version 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)
DBeaver CE x64 Version 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:$$$ tt- German localization was improved (thanks to @hype11)$$$ tt- Italian localization was improved (thanks to @Gnafu)
DBeaver CE x64 Version 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$$$ 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
DBeaver CE x64 Version 23.0.2
DBeaver CE x64 Version 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
DBeaver CE x64 Version 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 set and 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)
DBeaver CE x64 Version 22.3.5
- ChatGPT smart completion:$$$ - Completion popup UI was improved$$$ - Metadata scope configuration was added$$$ - Redundant config options wer removed$$$ - Data editor:$$$ - Accessibility support was significantly improved (context menu; additional keyboard shortcuts)$$$ - Filtering and ordering icons visibility configuration was added again$$$ - Dictionary viewer was fixed (issue with missing dictionary values)$$$ - Save filters button was removed from custom SQL queries results$$$ - App crash on geometry viewer opening was resolved in the latest version of MacOS$$$ - SQL editor: query text extraction was fixed (issue with trailing comment after query text)$$$ - Database backup/restore: issue with external tools running was resolved (Linux)$$$ - Application fonts were unified. Now we have only Main and Monospace fonts configuration$$$ - Data transfer: data type mapping now respects type name case (for databases with different default case)$$$ - Variables support in database tasks was fixed$$$ - Database tools wizard: redundant task configuration page was removed$$$ - SQL generator dialog now show progress to avoid UI freeze on big schemas$$$ - Issue with opening ERD files from disk ws resolved$$$ - Clickhouse: DDL for array columns was fixed$$$ - Databricks: additional metadata was added$$$ - Exasol: default connection parameters were updated (thanks to @allipatev)$$$ - IRIS (ex Cache): driver version was updated$$$ - Oracle: stored procedures invocation syntax was improved$$$ - Snowflake: driver now uses single database connection for all editors (configurable)$$$ - SQL Server:$$$ - Driver version was updated to 11.2.3. Trust server certificate option was moved to the main connection page$$$ - Server messages (printed on raiserror) reading was fixed$$$ - Multiple resultsets reading was fixed (extra error handling was added)$$$ - VARCHAR(MAX) data type support was added$$$ - SQLite: converting binary columns into string representation was fixed
DBeaver CE x64 Version 22.3.4
- ChatGPT integration for smart completion and code generation (as optional extension)$$$ - Accessibility:$$$ - Text reader for entity editor was improved$$$ - Text reader for data grid was improved$$$ - SQL editor:$$$ - Query generation from human language text was added$$$ - Server output log levels configuration was improved$$$ - Global metadata search was fixed$$$ - Variables resolution is fixed in strings and comments$$$ - Issue with queries with invalid line feeds was resolved$$$ - Data editor:$$$ - Grouping panel messages were improved$$$ - Datetime calendar editor was fixed (in panel and inline editor)$$$ - Database navigator: issue with rename/refresh was resolved$$$ - Dashboards were fixed for inherited databases$$$ - Project import now sets DBeaver nature (thanks to @froque$$$ - ERD: custom diagram editor was fixed (issue wth missing notes and connections was resolved)$$$ - Databricks: table DDL reading was fixed; extra SQL keywords were added (thanks to @mixam24)$$$ - DB2 BigSQL: table with RID_BIT columns data reading was fixed (thanks to @bkyle)$$$ - MySQL: numeric identifiers quoting was fixed$$$ - Netezza: tables/views search query was improved$$$ - PostgreSQL:$$$ - Procedures invocation was improved (thanks to @plotn)$$$ - Filter by enum was fixed (thanks to @plotn)$$$ - Redshift: triggers DDL reading was fixed$$$ - Snowflake: table constraints reading was fixed$$$ - We switched to Java 17 so now DBeaver supports all newest JDBC drivers
DBeaver CE x64 Version 22.3.3
- SQL editor:$$$ - Output logs viewer now respects log levels and supports log search$$$ - Auto-completion for mixed case schema name was fixed$$$ - Result tabs count message was fixed$$$ - Auto-completion of cell values is now configurable$$$ - Query execute time is now populated in statistics (thanks to @bob27aggiustatutto)$$$ - Mixed-case variables resolution was fixed$$$ - Execute statistics UI was fixed (redundant info was removed)$$$ - NPEs during auto-completion were fixed$$$ - Data editor:$$$ - Column name ordering in record mode was fixed$$$ - Chart type configuration added to the context menu$$$ - Issue with column focus in context menus was fixed$$$ - General UI:$$$ - Database navigator now respects font size customization$$$ - Dashboard graphs now support dark themes$$$ - DB2: client application name population was fixed$$$ - Exasol: privileges reading was fixed for SaaS (thanks to @allipatev)$$$ - MySQ:/MariaDB: schema privileges save was fixed (issue with UI refresh)$$$ - Oracle: complex data types resolution was fixed for resultsets$$$ - PostgreSQL:$$$ - Full backup with roles and groups is now supported$$$ - View triggers DDL was added$$$ - Procedure debugger was fixed$$$ - Issue with URL-baes connections backup was resolved$$$ - Vector data types support was fixed$$$ - Aggregate functions DDL was fixed$$$ - Redshift: incorrect schemas info read in different databases was fixed$$$ - Snowflake:$$$ - Java 17 support has been added$$$ - Complex DDL statements parser was improved$$$ - SQL Server: procedures and functions rename was fixed$$$ - Vertica: comments read can e disabled for all metadata (for performance)
DBeaver CE x64 Version 22.3.2
DBeaver CE x64 Version 22.3.1
- Data editor:$$$ - Columns filtering/ordering menu was redesigned$$$ - Virtual key definition behavior was redesigned$$$ - SQL editor:$$$ - Script statistics visualization was fixed$$$ - NullPointer error during new script opening was fixed$$$ - Data transfer: variables resolve in saved tasks was fixed$$$ - Folders drag-n-drop was improved. Drop into root is now possible$$$ - Drag-n-drop from navigator window was fixed for GTK$$$ - Native SQL script execute wizard UI was improved$$$ - Debug log file rotation was added; solves problem with huge log files$$$ - Errors during driver files download are now handled properly$$$ - SSL certificates configuration on Windows was fixed$$$ - Proxy settings are saved between app installations (Windows installer)$$$ - Confirmation dialogs were redesigned$$$ - Reset UI settings and Reset workspace behavior was redesigned.$$$ - Tasks view now shows tooltips$$$ - Data export in SQL INSERT format now supports custom target table name configuration$$$ - Issue with columns visibility in metadata editor was resolved$$$ - Chinese localization was extended (thanks to @bianyun1981)$$$ - Eclipse plugin now supports the latest Eclipse IDE version$$$ - DBeaver base platform was changed to Eclipse 2022-12$$$ - AWS Athena driver version was upgraded$$$ - PostgreSQL:$$$ - SSL keys automatic conversion was added$$$ - Template databases duplication was fixed$$$ - Object dependencies read query was fixed$$$ - Azure SQL Server driver configuration was fixed (multi-factor authentication support)$$$ - MySQL NDB driver configuration was fixed$$$ - MySQL: user name quoting was fixed$$$ - Multiple minor UI bugs were fixed
DBeaver CE x64 Version 22.3.0
- Data editor:$$$ - Data export button UI was enhanced$$$ - Fetch all data and fetch size controls were returned to status bar$$$ - Lasso tool was added to spatial viewer$$$ - Bug in spatial viewer initialization was fixed$$$ - BLOB contents opening in external editor was fixed for MacOS and Linux$$$ - Browser-based image viewer control was fixed (null or invalid images handle)$$$ - SQL editor:$$$ - Big SQL files support was improved (automatic disablement of syntax validation)$$$ - Table auto-completion tooltips UI was redesigned$$$ - Error on unassociated script opening was fixed$$$ - General:$$$ - Default SSL truststore selection was fixed (it is now configurable)$$$ - Connection edit/create dialog performance was improved$$$ - Database server version is now shown in connections tooltip$$$ - Object delete dialog was redesigned$$$ - Database create button was removed from the connection dialog for databases which dont support it$$$ - Security patch for packaged drivers (additional validation of zip archives was added)$$$ - SSH: tunnel invalidation was fixed for SSHJ$$$ - Tasks: problem with tasks operating with missing (deleted) tables was fixed$$$ - Clickhouse: identifiers quoting was fixed (for non ASCII characters)$$$ - Intersystem Cache: community driver was added again$$$ - MySQL:$$$ - Hyperlinks navigation was fixed for procedures$$$ - Complex identifiers quoting was fixed$$$ - Netezza: columns metadataread ws improved$$$ - PostgreSQL:$$$ - Role create/edit command was fixed$$$ - PostgreSQL 15 support was improved (new data type category)
DBeaver CE x64 Version 22.2.5
- Data editor:$$$ - Top and bottom action toolbars were redesigned$$$ - Action buttons now show hints$$$ - Data export toolbar button is now configurable$$$ - Image viewer was switched to embedded web-browser mode (configurable)$$$ - The issue with spatial data viewer was fixed (no more handles error)$$$ - Errors in virtual column definition now handled properly$$$ - Count nulls function was added to the Calc panel$$$ - SQL editor:$$$ - Auto-completion with TAB key was implemented (!)$$$ - Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces$$$ - The issue with keyword case auto-conversion was solved$$$ - Editor tabs now shows connection state icon (connected/failed)$$$ - Client-side commands prefix configuration was fixed$$$ - The issue with cursor position change on mouse right-click was resolved$$$ - Data transfer: tables/column mapping dialog was improved; problems with target column name were fixed$$$ - Database drivers:$$$ - License information was added to the most drivers$$$ - It is no longer need to restart DBeaver after driver settings change (bug in recent versions)$$$ - Connections:$$$ - SSH jump servers support was added for SSHJ implementation$$$ - Network profile edit UI was fixed$$$ - Connection error messages$$$ - General UI:$$$ - Dark theme support was added to XML editor$$$ - Dialog font settings is now applied to most popup dialogs$$$ - Database navigator quick filter now supports composite identifiers (thanks to @plotn)$$$ - Clickhouse: driver version was updated; this resolves many issues with different data types support$$$ - Oracle: DATE data type rendering is now configurable$$$ - PostgreSQL: auth role editor was moved to the database level$$$ - SQL server: it is now possible to disable TOP clause in select queries
DBeaver CE x64 Version 22.2.4
- SQL editor:$$$ - SQL script active database/schema restore was fixed$$$ - Parameters prefix configuration was fixed$$$ - Issue with cursor change on context menu invocation was fixed$$$ - Option to disable all code completions/foldings was added$$$ - Auto completion inside SQL package was fixed$$$ - Table aliases auto-completion was fixed$$$ - SQL blocks auto-completion was fixed$$$ - SQL variables/parameters disable configuration was fixed$$$ - Data editor:$$$ - Table columns resolution was improved for custom SQL queries$$$ - Hidden columns restore was fixed$$$ - Data transfer:$$$ - Columns mapping dialog was redesigned and improved$$$ - Columns scale/precision mapping was fixed$$$ - Import from XML format was fixed$$$ - Multiple MFA attempts were resolved (in drivers with MFA authentication)$$$ - Tasks: variable value prompt was added (configurable)$$$ - SSH tunnels: issue with private key password prompt was fixed$$$ - RPM package: issue with remaining symlinks after uninstall was fixed$$$ - UI perspective customization was fixed$$$ - Clickhouse: driver version was updated (solves many data type conversion problems)$$$ - PostgreSQL: inherited roles support was added$$$ - Snowflake:$$$ - Java 17 support was added$$$ - Stored procedure and functions management was added$$$ - SQLite: table column delete was fixed
DBeaver CE x64 Version 22.2.3
- Data editor:$$$ - Value display format option was added to grid data view$$$ - Dictionary view panel now saves its ordering state$$$ - Row number in the record mode was fixed$$$ - Ability to open external editors for BLOB values was added$$$ - Database backup: variable ${schema} was added$$$ - SSH:$$$ - Problem with redundant password prompt was fixed$$$ - Tunnel config tab is now hidden for databases which dont support SSH$$$ - Drivers:$$$ - Driver version auto-update feature added$$$ - Issue with driver download dialog was fixed (non-clickable dialog)$$$ - Driver license info button was added to the connection edit page$$$ - Data transfer:$$$ - Export to XLSX now support different modes for spreadsheet rows append$$$ - Description column was added to XLSX format (configurable)$$$ - An additional confirmation is shown if output file will be overwritten$$$ - Fallback directory was added for data export tasks$$$ - Tasks:$$$ - Tasks viewer now shows tasks only for the active project$$$ - New task create command enablement was fixed$$$ - Running tasks are now checked and confirmation is shown on DBeaver app shutdown$$$ - Additional logging was added for tasks execution$$$ - Clickhouse: SSL support was fixed$$$ - Greenplum: table list read was fixed for recent GP server versions 6+.$$$ - MariaDB: UUID data type support was fixed$$$ - MySQL/MariaDB: problem with grave accent quoting was fixed$$$ - Oracle: DATE data type rendering was fixed (time part was removed)$$$ - PostgreSQL:$$$ - Problem with result sets fetch was fixed (OutOfMemory on big results)$$$ - Driver version was updated to 42.5.0 (security update)$$$ - Issue with numeric fields formatting in struct types was fixed$$$ - OpenSearch driver configuration was added$$$ - General:$$$ - Multi-connections behavior configuration was improved. Possibility to forcibly$$$ disable or enable additional metadata or SQL editor connections was added.$$$ - Additional localization was done in many places of application$$$ - We switched to a new Eclipse platform version (2022-09)
DBeaver CE x64 Version 22.2.2
- Data editor:$$$ - Hide all empty columns action was added$$$ - References panel now has a button to open target table$$$ - Ordering by multiple columns was fixed$$$ - Filtering by spatial columns was fixed$$$ - URL transformer was fixed (original value edit is now supported)$$$ - LOB editor opening performance was significantly improved$$$ - SQL terminal now shows server output log$$$ - Column comments are now visible in record mode$$$ - Complex data types visualization was fixed for record mode$$$ - Data transfer: bug in CSV export with custom header format was fixed$$$ - SQL editor:$$$ - Problem with NULL column names in custom queries was fixed$$$ - Database drivers:$$$ - Problem with driver jars re-download was fixed$$$ - It is now possible to disable Windows certificate storage usage$$$ - Athena: driver version updated to 2.0.30$$$ - Clickhouse: datetime64 data type support was added$$$ - DB2: driver version was updated to 11.5.7$$$ - Exasol: user list read read was fixed (thanks to @allipatev)$$$ - Greenplum: prepared statements usage was disabled$$$ - MySQL:$$$ - Default database client was changed onto version 8+$$$ - JSON columns now can be used in filters and as keys$$$ - Oracle: schema full DDL was added$$$ - PostgreSQL:$$$ - Problem with missing primary key in new tables was fixed$$$ - Table DDL for partitioned tables was fixed$$$ - Role comments are now visible/editable$$$ - German localization was improved (thanks to @dan-schneider)
DBeaver CE x64 Version 22.2.0
Data editor:$$$Embedded browser (Edge vs IE) configuration was added$$$Custom data types rendering in record mode was improved$$$Console viewer toggle was fixed on Linux/MAcOS$$$Arrays view/edit UI was improved$$$Multidimensional arrays support was fixed$$$$$$Data transfer:$$$Column auto-mapping was fixed for databases with different identifiers case$$$Problem with old configuration load was fixed$$$Statistics calculation was fixed$$$$$$SQL editor:$$$Query parser was fixed (issue with single line comments in select items)$$$Screen coloring by connection type was fixed$$$$$$SSH:$$$SSHJ now is the default tunnel implementation$$$SSHJ version was upgraded; ASN1 decoder was added$$$$$$Connection:$$$Issue with double authentication in web browser was resolved (all drivers with MFA auth)$$$$$$Clickhouse:$$$Boolean data type support was added$$$Issue with timestamp data edit was resolved$$$$$$Firebird: overloaded procedures loading issue was resolved$$$MS Access: diagram loading was fixed$$$$$$Oracle: password expiration warning was added$$$$$$PostgreSQL:$$$Extra options were added to explain plan dialog$$$Data type constraints loading was improved$$$Data type DDL generation was fixed
