DBeaver Lite 24.0

March 11, 2024
Changes since 23.3:
  • Metadata Editor:
    • Primary/unique key can be created automatically along with new columns
    • Object creation dialog was redesigned
    • Constraint creation was fixed
    • Editor performance on Linux was enhanced
  • SQL Editor:
    • Syntax highlighting and validation were improved
      • New highlighting and script validation were enabled by default
      • Highlighting in nested queries and query editing was fixed
      • Arrays highlighting was added
      • Case sensitivity on highlighting and validation was fixed
      • SELECT query validation was fixed
      • Color and font settings with enabled semantic analysis were fixed
      • Column aliases highlighting was fixed
      • Identifiers coloring was improved
      • SQL highlighting performance was improved
    • Autocomplete:
      • Autocomplete for aggregate functions was added
      • Autocomplete for INSERT statements was fixed
      • Duplicated table aliases in autocomplete were fixed
      • Autocomplete was fixed for multiline comments
    • Small font in the editor and result set was fixed
    • Creating multiple parsing jobs was fixed
    • Dot character was forbidden in variable names
    • Execution time format was improved
    • Toolbar customization page opening was fixed
    • Connection variables and system environment variables became accessible from SQL Editor
    • Handling of special characters was fixed
  • Outline viewer of SQL queries structure was added
  • AI enhancements:
    • AI was added to Lite Edition
    • GPT-4 model was added, and legacy OpenAI models were removed
    • Ability to send object descriptions to OpenAI was added
    • AI comments representation was added to the Chat mode
    • Disable all comments setting was added
    • Issue with using chat format in completion dialog was fixed
    • Redundant fields were removed from Azure OpenAI settings 
    • Query with LIMIT in AI Chat were fixed 
    • Issue with using chat format in completion dialog was fixed
    • Send button in the chat was improved
    • AI icon was fixed in Eclipse 
    • Work of the “Send unique keys and indexes information” option was fixed
  • Visual query builder:
    • Ability to delete JOINS in the DBeaver interface was removed
    • Redundant buttons were removed from the Context menu
    • Issue with the black screen when switching between tabs on macOS was fixed
    • Shortcuts were fixed
    • Query Builder was added to the Context menu in SQL Editor
  • Data Editor:
    • Fetch next page shortcut was changed to CTRL+ALT+N
    • Value selector panel was improved: you can switch the active panel with ‘Ctrl+Tab’ and change the active value in the context menu
    • Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
    • Ignoring quotes option was added to the Advanced paste
    • Advanced paste of multiple records was enhanced
    • Issue with multiple checks in filters was fixed
    • Column descriptions presentation was fixed
    • Spatial data zoom was improved 
  • ER Diagram:
    • Orthogonal path routing was significantly improved: connection rendering was enhanced, bridges were highlighted according to the selected edge, and a separate presentation of vertical routes was added
    • One-to-one connection rendering for unique/primary key was fixed
    • Сonnection errors handling was added
    • Diagram layout was enhanced
  • Data transfer:
    • Multithreading support when exporting multiple tables was added
    • Delimiter selection when exporting in TXT format was added
    • All columns can be marked as skipped when exporting data
    • The Proceed button at the last step became more visible
    • On conflict expression was added to INSERT statements
    • Crash when importing CSV file was fixed
    • Extra space before the semicolon in export to SQL was removed
    • Target table change on the mapping page was fixed
    • Statistics were excluded from exported data
    • Incorrect links in settings were fixed
    • Generating columns on XLSX import was fixed
  • Accessibility:
    • Notifications can be read with a screen reader (JAWs, NVDA or Narrator)
    • Screen reader in Visual Query Builder was supported
    • General:
      • License is updated before the import
      • License names were changed according to new license types
      • Application launch was improved
      • Idle connections’ behavior has changed, now they are automatically closed by default after some time
      • Close idle connection setting saving was fixed
      • Unexpected transaction ending was fixed
      • Settings are applied to new connections without a restart
      • Broken links in connection dialogs were fixed
      • User credential dialog was fixed
      • Temporary directory creation was fixed
      • Changing the monospace font was fixed
      • Finding local clients on Linux and macOS was improved
      • Incorrect links to help articles were fixed
      • Redundant items were deleted from the Context menu
      • Global network settings preferences page is available again
      • Workspace opening was fixed
      • ‘Statistic’ tab display was fixed
      • GCP CLI executable saving was fixed
      • We switched to Eclipse 2023-12
  • Security:
    • Master password policy was added: master password can be configured or disabled
    • Added warning when trying to open an encrypted project and risk losing all connection credentials
    • Confirmation button was disabled in the Master password dialog if nothing was selected
    • User don’t need to enter the project password to disable the master password
    • Project password recovery button was removed 
    • Flight SQL driver, GCP SDK, and Microsoft Azure SDK were upgraded due to security issues
    • Many third-party drivers were upgraded due to security issues: Dameng, Flight SQL, MariaDB, Oracle, Snowflake, SQLite, and SQL Server.
  • New drivers:
    • Altibase support was added
    • StarRocks database support was added
    • RisingWave driver support was added
    • Cubrid driver support was significantly enhanced
  • Databases:
    • BigQuery: Structs and arrays are supported
    • ClickHouse: Legacy driver configuration was fixed
    • Dameng:
      • Dameng driver was updated
      • Users, roles, and categories are supported
      • Dameng: tablespaces are supported 
    • DB2: Loading schema statistics was fixed
    • EDB: Packages duplicating schemas in the Database Navigator were removed
    • DynamoDB: Adding data to the empty table was fixed
    • Firebird: Function and procedure presentation was enhanced
    • Google Cloud SQL: redundant options were removed from the context menu
    • Greenplum: Rows policies were supported
    • Microsoft Access connection via ODBC-JDBC driver is supported
    • MariaDB: 
      • Driver was updated to version 3.3.2
      • Result fetch size was fixed
    • MySQL and MariaDB: 
      • ‘Grant option’ is checked only if grant permission exists
      • Rendering columns with unique identifiers was fixed
    • MySQL
      • Path to the local client was fixed
      • TLS 1.3 support was added
    • MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
    • MongoDB: ObjectID update was fixed
    • Oracle:
      • Oracle driver version was updated to 23.2.0.0
      • Keywords and schemes highlighting was improved
      • New table partitioning was supported
      • Default subpartition type was added
    • PostgreSQL:
      • Creating a new table from the user interface was fixed
      • Indexes and constraints are displayed in partition DDL
      • Backup of several schemas and several tables was enhanced
      • Duplication of procedures was fixed
      • Option ‘Show all databases’ was moved to the main page in the Connection settings
      • Schema permissions display was fixed
      • Confirmation message for clean option of restore wizard was fixed
    • Redis Sentinel is now supported 
    • Redshift
      • Added extended support for stored procedures for early Redshift versions
      • Roles and group management were added
    • Salesforce: Timeout duration was increased 
    • ScyllaDB: 
      • The connection page was updated
      • The database name was corrected
    • Snowflake
      • Snowflake driver was updated to version 3.14.4
      • Double-dash single-line comments highlighting was fixed
      • Functions words were added to SQL Editor
      • VIEW keyword highlighting and validation was improved
    • SQLite: 
      • The driver was updated to version 3.44.1.0
      • Import with ‘truncate target tables before load’ option was fixed
    • SQL Server: 
      • SQL Server driver was updated
      • Syntax highlighting was fixed
      • Check constraint option was removed from the primary/unique key creation page
      • Displaying source in the index properties was fixed
    • Sybase:
      • Stored procedure creation was added
      • Using create view instead of Alter view was fixed
      • Import with table mapping was fixed
    • TDengine: Unqoted table names presentation was fixed
    • Teradata:
      • Roles and profile management and presentation were improved 
      • Metadata search was significantly enhanced
  • Localization:
    • Ukrainian localization was added
    • French localization was updated 
    • Japanese localization was updated 
    • Italian localization was improved
    • Portuguese localization was fixed
    • All standard UI translations were updated for all languages
    • Language detection for locale containing language and country was fixed
  • Misc:
    • Ability to use waffle-jna in MariaDB, PostgreSQL, and Oracle was added
    • Flipped splash screen on macOS Sonoma was fixed
    • Starting application when the workspace directory is a link was fixed