DBeaver Lite 24.1

June 10, 2024
Changes since 24.0:
  • Connectivity:
    • Shared SSH session support was added.
    • Using multiple jumps tunnels when connecting via SSH was supported.
    • Native SSH tunnels over AWS SSM were supported.
    • SSH parameters validation on the Connection page was added.
    • Ability to disable saving credentials was added.
    • Connection via native proxy was fixed.
    • Dark theme support on the Connection page was improved.
    • Space trimming when saving user credentials was added.
    • Editing of “Local host” and “Remote host” fields in the Port Forwarding section was fixed.
    • Database connection timeout notification was fixed.
    • “Azure AD” was renamed to “Microsoft Entra ID”.
    • Links to database support documentation were added for many databases.
    • Automatic termination of the shell command script ‘Before connect’ was fixed.
  • SQL Editor:
    • Smart mode for statement delimiter in SQL scripts was added.
    • Highlighting, validation, and outline for INSERT, UPDATE, and DELETE statements were supported.
    • Auto-completion for sub-selects was supported.
    • WHERE TRUE,  SELECT UNIQUE, and QUALIFY keyword support was added.
    • Outline viewer can be opened only if semantic analysis was enabled.
    • Cursor behavior during autocompletion was improved.
    • Error with single quoted string was fixed.
    • Syntax highlighting after active schema change was fixed.
    • Highlighting of column references in INSERT queries was fixed.
    • Code highlighting issue with a quoted identifier in case of no connection was fixed.
    • Rendering issue with text hidden behind a white area on macOS Sonoma was fixed.
    • Vertical button alignment was fixed.
    • Issue with the extra line feed during autocompletion was fixed.
  • AI:
    • Button that opens AI smart assistance and “AI Chat” tab in the SQL Editors were enabled by default. 
    • Integration with custom llama-based models was added.
    • Join request generation with Google Gemini assistance was improved.
    • Database metadata collection was fixed. Prompts sent to AI were truncated to fit the limits of the selected model.
    • Custom scope performance was improved.
    • Dark theme in AI chat was fixed.
    • When an AI response appears in the chat, the chat automatically scrolls to it.
    • Adding markdown notation in the chat with Gemini was fixed.
  • Metadata editor: 
    • Automatic reference column creation for a new foreign key was implemented.
    • Linking with the editor was fixed.
    • Highlighting for created entities was changed to green.
    • Virtual foreign keys: reference table container selector was fixed.
  • Data Editor:
    • Automatic row count option was added. Users don’t need to press a button, the number of rows are automatically counted when the table is opened. 
    • Loading data when fast scrolling using the keyboard was fixed.
  • ER Diagrams: 
    • Orthogonal layout was reorganized and significantly improved.
    • Foreign keys presentation was fixed.
    • Error when unchecking the ‘Keep layout’ option was fixed.
    • Loading diagrams for drivers with broken foreign keys support was fixed.
  • VQB:
    • Creating BETWEEN conditions was supported.
    • Ability to change table aliases in joined tables was added.
  • Data transfer:
    • Ability to specify header case in the target file was added.
    • Import from CSV with duplicated column names was fixed.
    • Parallel data transfer monitoring/cancellation was fixed.
  • Database Navigator: 
    • Fixed working of shortcuts after application launch: CTRL+C, CTRL+V, and similar ones.
    • 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’.
  • Projects: 
    • Disconnecting a database from the Project view was fixed.
    • Opening a bookmark after changing the application language was fixed.
  • General:
    • Ability to import configured connections from Toad for Oracle was added.
    • User can get log files by pressing one button in the application.
    • In metadata and data search only connected databases can be filtered.
    • Setting to disable the automatic updates checkbox in Preferences was added.
    • Error when checking checkboxes in the Formatting page in Preferences was fixed.
    • Disappearance of the renamed project was fixed.
    • Transaction rollback behavior was fixed.
    • Metadata changes were removed from the commit counter.
    • Autocommit in production databases was fixed.
    • Language configuration in Windows installer was fixed.
    • Sensitive information in the log files is now masked.
    • Opening editors for files with special symbols in names was fixed.
    • Portable distribution of the application was fixed (config files location).
    • Crash when closing the detached editor tab in another window was fixed.
    • “Restore default” for Metadata read and Client identification settings were fixed.
    • Truncated notifications were fixed.
    • New database object creation was fixed in the Eclipse plugin.
    • .projects and .settings folders became findable in Projects when the application is used as an Eclipse plugin.
    • Development: redundant tests were disabled.
    • We migrated to Eclipse 2024/06.
  • Security:
    • Secure project opening was fixed.
    • Project password behavior was improved.
  • Databases
    • Neo4j driver support was significantly enhanced. The structured data can be presented in JSON or text format. Users can execute queries using Cypher query language.
    • BigQuery support was enhanced:
      • Clustered tables presentation was added.
      • Bytes processed and other statistics are presented in Data Editor.
      • Metadata editor was supported: users can add or delete columns and create or delete Primary Keys and Foreign Keys via the user interface.
    • Informix: 
      • TimeSeries data type was supported.
      • Sharing of the procedure list was fixed.
    • CrateDB: Table DDL was fixed.
    • Cubrid: Query plan feature was added.
    • Dameng: Sequence creation was fixed.
    • Databricks: Authentication with personal access token was added.
    • DB2i: Procedure creation was fixed.
    • DuckDB:
      • Spatial data visualization was added.
      • Sequences, views, and table definitions were supported.
      • Ability to add comments via UI was added.
      • Aliases autocompletion was fixed.
    • H2: Foreign keys presentation was fixed.
    • Microsoft Azure
      • Default credentials can be used without specifying the Client ID.
    • MongoDB: 
      • Saving special characters was fixed.
      • length() function for SELECT statement was supported.
      • getDBNames() and getDB methods were supported.
      • JavaScript command support was fixed.
      • IN expression parsing was fixed.
    • MariaDB:
      • GRANT OPTION privilege persistence was fixed.
      • Schema privileges representation was fixed.
    • MySQL: 
      • Link to the driver documentation was fixed.
      • Fixed a bug when, instead of deleting a comment, an empty comment was added.
      • Ability to pick and edit location on map when working with spatial data in Data editor was fixed.
    • Oracle:
      • Reading AWS properties was fixed.
      • Oracle legacy driver was added, allowing connection to Oracle 8, 9, and 10.
      • Partition type display was added.
      • Materialized view refresh was fixed.
      • JSON data type support was improved.
    • RisingWave: Non-working functions and folders were removed.
    • PostgreSQL:
      • Issues with scheduled jobs were resolved.
      • GENERATED ALWAYS conversion to DEFAULT was fixed. 
      • Jobs, roles, and system information were hidden in the Hide Folders mode.
      • Support of fully qualified names in DDL was fixed.
    • SQLite: errors when creating tables were fixed.
    • SAP ABAP: handling of timestamp data in JDBC/ODBC SAP bridge driver was fixed.
    • SAP IQ via ODBC: Procedure formatting was fixed.
    • SQL Server:
      • Redundant authentication types were hidden.
      • Trigger deletion was fixed.
      • Default IDENTITY was changed to (1,1).
    • Sybase: Stored procedures support was improved.
    • Teradata: 
      • Procedures and functions of DDLs reading were enhanced.
      • Link to the referenced table in the Metadata editor was added.
    • SQLite: Deleting columns was fixed.
    • Vertica: LOOP/END LOOP as a block and DECLARE were added to the syntax analyzer.
  • Localization:
    • Romanian language support was added.
    • French localization was updated.
    • German localization was updated.