DBeaver Lite 24.2

September 9, 2024
Changes since 24.1:
  • General:
    • Added the ability to disable all metadata queries. This can be useful for improving performance or reducing the number of queries to expensive databases.
    • Wayland support on Linux was fixed.
    • ‘Show scripts’ option was added to the SQL dropdown in the main toolbar.
    • 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.
    • Authentication in embedded browser was temporarily disabled on Linux.
    • Incorrect button behavior in the confirmation dialog was fixed.
    • Security credential encryption was enhanced.
    • Smart commit mode indication was fixed.
    • Issue with metadata cache reading was resolved.
    • Automatic resize of connection dialog and tasks dialogs was fixed.
    • 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.
    • Buttons display when creating new dashboard was fixed.
    • Improved error handling when trying to use not allowed characters in project name.
    • Fixed flipping splash screen on macOS Sequoia.
    • ‘Open auth links in embedded browser’ setting was disabled by default.
    • Search in Preferences was improved: added keywords for reopen, open, autosave, and others.
    • Fixed an issue with connection to the incorrect database for the case when databases in different schemas had identical 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.
    • Added import of configured connections from MySQL Workbench and other third-party database management tools.
  • 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.
    • Performance and behavior of the Smart mode for Blank line state delimiter were improved.
    • Added ability to disconnect from the datasourse when all associated editors were closed (configurable).
    • Auto-save editor setting was enabled by default.
    • Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only.
    • Fixed an issue when the pinned tab was replaced by the new query result.
    • Autocompletion:
      • New autocompletion engine was significantly enhanced.
      • Autocompletion for derived columns in sub-queries was improved.
      • Autocomplete suggestions inside literals in INSERT INTO were disabled.
      • Completion analyzer performance was enhanced.
      • Short/long object names completion configuration was redesigned.
      • Autocompletion for fully qualified names was fixed.
      • New completion engine was improved: fixed proposal duplication and incorrect suggestions.
    • UI improvements:
      • ‘Recent SQL script’ was renamed to the ‘Last edited SQL script’.
      • Buttons on the toolbar at the right part of SQL Editor were renamed to Builder and Editor.
      • Data type icons were redesigned.
      • SQL error presentation was redesigned to fit the window size.
    • Semantic analysis:
      • Syntax highlighting for functions with multiple arguments was fixed.
      • SQL datatype color use was corrected.
      • Composite type field color became visible in the Dark theme.
      • ILIKE keyword was supported.
      • Support for unsigned numbers in GROUP BY clause was added.
      • Added semantic analysis for DROP, CREATE, and ALTER TABLE queries.
      • Column validation for UPDATE SET clause was fixed.
      • Subquery semantic analysis was fixed.
      • Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled.
    • Outline viewer:
      • DROP, CREATE, and ALTER TABLE support was added to Outline
      • Syntax highlighting and outline viewer support parameter changes in SQL Processing settings.
    • Execution of the corrected SQL script was fixed.
    • ‘Execute SQL Script’ option behavior was fixed.
    • SQL Output for SQL scripts was fixed.
    • Output panel opening was fixed.
  • AI Assistant:
    • AI Assistance: GPT-4o, GPT-4-turbo, and GPT-4o-mini models are supported.
    • Removed deprecated model ‘gpt-3.5-turbo-16K’.
    • Fixed query generation when enabled formatting.
  • Properties: 
    • Added presentation of structural data types in table Properties.
    • Generate SQL option in the context menu was fixed.
    • Foreign Key creation UI 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.
    • Information about table unique key is displayed in the grid.
    • Keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window.
    • Column aliases can now be copied with Advanced Copy option.
    • Paste into the table with no foreign key was fixed.
    • Inline editing of geometry fields was fixed.
    • JSON and XML panels performance was enhanced.
    • Issue with switching to the top row in JSON and XML viewers was fixed.
    • Text glitches in XML presentation on macOS were fixed.
    • ‘Customise’ and ‘Save filter’ buttons were moved to the dropdown.
    • Issue with too small Result Set Order/Filter Settings window was resolved.
    • BETWEEN and LIKE keywords were added to filter autocompletion.
    • Rollback timer flickering was fixed.
    • 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 presented in the result set.
    • Improved handling of fully qualified names in the Grouping panel according to SQL dialect.
    • Local links opening was restricted.
    • Background color on the Dark theme was improved.
  • ER Diagram: 
    • Positioning of tables without connections in Orthogonal path routing was improved.
    • Entity selection was fixed.
    • Bridge on crossing lines rendering was improved.
    • Print mode in ER Diagrams and Execution plan was fixed.
    • Saving Diagram outside the workspace was fixed.
  • Query Manager: Information about database schema and catalog was added to the detailed record view.
  • Database Navigator icons were redesigned.
  • Simple Structure Compare: Issue with long file names was resolved.
  • Dashboards: Project dashboard UX was improved.
  • Data transfer:
    • Users can email large task result files by splitting them into multiple parts in zip format.
    • Compress option behavior was fixed.
    • Wizard window auto-size was fixed.
    • Export of data with backticks was fixed.
    • Export of binary columns in JSON format was fixed.
  • Connectivity: 
    • It is now possible to use custom SSM Documents to connect to AWS databases.
    • Closing idle connections and default timeout were fixed.
    • Added ‘Session token’ field to AWS temporary credentials.
    • Connections invalidation after sleep mode was added.
    • Issue with default SSH connection timeout was resolved.
    • Fixed verification of the 127.0.01 host when connecting via SSH.
    • Connection page for custom drivers with the URL template was fixed.
  • Databases:
    • Altibase:
      • Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view.
      • Added status of the view, materialized view, procedure, function, or package.
      • Execution plan parsing error was fixed. 
      • Search for server properties was added.
      • Non-schema objects like Job, Database Link, Directory, and Library are now supported.
    • BigQuery:
      •  Ability to see bytes billed in the Statistics panel in the Data Editor was added.
      • BigQuery: Database monitoring dashboards were added only in applications for Windows.
      • BigQuery: Legacy SQL dialect was supported.
    • GaussDB driver was added.
    • Cassandra: VECTOR data type is supported.
    • ClickHouse:
      • DateTime32 formatting was fixed.
      • IPV6 data presentation was added.
      • Complex structures handling was fixed.
      • Filtering by the Date data type was fixed.
    • CloudSQL – PostgreSQL:  Connection via Cloud Explorer was fixed.
    • Couchbase: Legacy Couchbase driver was removed.
    • CUBRID:
      • Execution plan was enhanced.
      • View creation was added to the UI. 
      • Supported keywords for SQL Editor were reviewed and updated. 
      • Ability to edit Serial using UI was added.
      • ‘db_server’ information was added to the Database Navigator.
      • DDL display for a view was added together with the ability to display the list of indexes, synonyms, serials, triggers, and procedures.
      • Ping query to keep connection alive was added.
      • Partition display was added, creating partition option was removed.
    • DocumentDB: Table creation via SQL Editor was fixed.
    • DuckDB: Data edit was fixed.
    • DynamoDB: Fixed comments handling when generating queries with AI Assistant.
    • MariaDB: Geometry data type is now supported.
    • MySQL: Error/output log dump was fixed.
    • Neo4j: Filters and ordering were fixed.
    • Ocient: Tables and views DDL generation was enhanced.
    • PostgreSQL:
      • Ordering by interval datatypes in the Data grid was fixed.
      • Added regexp functions support in SQL Editor.
      • Foreign Data wrappers configurator was fixed.
    • Redis: Keys settings were fixed.
    • Redshift:
      • Metadata reading for indexes was disabled.
      • Problems with broken connection with the Custom Trust Store were resolved.
      • Datashare visibility was fixed.
      • Constraint creation was fixed.
      • Users and permissions display was fixed.
      • Connection stability was significantly improved.
      • DDL presentation was fixed.
      • Role, User, and Group presentation was fixed.
    • Salesforce: 
      • Reference panel opening was fixed.
      • Exception on diagram opening was fixed.
    • SAP IQ: Duplicated output messages were fixed.
    • SAP Hana: Additional system table prefix was added.
    • SQLite: Full-text search was improved.
    • SQL Server: 
      • Saving changes in procedures was fixed.
      • 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.
      • Fixed DDL and column display with custom data types.
    • Teradata: Database name became optional for connection.
    • Vertica: 
      • Incorrect query execution with the cursor at the end was fixed.
      • Stored procedures handling in SQL Editor was fixed.
    • The following drivers were updated:
      • Apache Drill to version 1.21.2
      • Clickhouse to 0.6.1
      • Cassandra to 4.18
      • Firebird to 5.0.4
      • Informix to 4.50.10.1
      • InterSystems IRIS to 2024.1
      • SAP Hana to 2.20.17
      • SQL Server to 12.8.0
      • Redshift to 2.1.0.29
      • Yugabyte to v4.15
    • Localization: 
      • Italian localization was updated.
      • French localization was updated.