DBeaver Lite 23.2

September 12, 2023
Changes since 23.1:
  • New drivers:
    • Azure Cosmos DB
    • AWS Timestream
    • Amazon Neptune
    • Influx 3
    • Crate DB for Postgres 
    • Materialize 
    • Salesforce 
    • TDengine 
  • General:
    • We switched to Eclipse 2023-06 and Java-17 as a base platform
    • The internal app controller server now uses HTTP instead of RMI
    • We have improved the security of storing user settings and Preferences
    • SQL script opening was fixed
    • The issue with not stopped generating DDL queries was fixed
    • DDL generation for the sequence was fixed
    • Redundant bytes were removed from dbeaver-debug.log
    • Redundant logs of SSH tunnel closing were removed 
    • The issue with the program launch with the wrong Java version was fixed
    • CLI parameter for app version print was added
    • CLI processing was fixed in a multi-workspace environment
    • The command line connection opening was fixed
    • The Maven snapshot repository was added to the default configuration
  • General UI:
    • Network handlers (SSH, SSL, etc) UI was redesigned
    • The preference page was reorganized (AI moved to the General section, Enterprise Security moved to the Security section)
    • Objects sorting in tables can now be reset to the original ordering
    • Users can use drag-n-drop to copy scripts, open database objects, and insert Navigator node names into the editor
    • Settings reset UI and behavior was redesigned
    • The editor tab tooltip now contains information about the resource’s project
    • Driver search UI was fixed on MacOS
    • The creation of objects with mixed-case identifiers was fixed
    • External file opening was fixed on MacOS and Linux
    • The issue with preference pages in the Eclipse plugin was resolved
    • Auto-commit mode switch behavior was fixed
    • Logical database structure settings can be disabled or reset in the connection editor dialog
    • Logical project deletion was fixed
  • Notifications:
    • Notification management was improved: now you can choose in Preferences when you need a notification and if you need a sound for it
    • Notifications in Dark theme became topic “Notices in the dark” became readable
    • “Tip of the day” was updated, and now shows OS-specific shortcuts properly
  • SQL Editor:
    • Users can configure the options on the toolbar by pressing the gear button in the editor
    • Spelling errors and other annotations now work in console mode
    • Spelling now works with URLs and non-letters at word boundaries
    • Trailing DDL query delimiter processing was fixed
    • Table alias generation was fixed (issue with duplicated aliases)
    • Auto-proposals now respect the option “empty line is a query delimiter”
    • Auto-proposals calculation performance was significantly improved in some cases
    • Aliases completion was fixed (issue with redundant spaces)
    • Table name completion was fixed for invalid SQL queries
    • Autocompletion in single-line comments 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)
    • Variable value editor was fixed
    • Issue with text search/replace in hidden files was fixed
    • Issue with the missing “Copy file path” option was fixed
    • Mouse hovering over editor annotations was fixed
  • Data Editor:
    • The statistics view can now be disabled
    • The dictionary viewer panel UI was redesigned
    • The references panel refresh was fixed
    • Folding in the XML presentation was fixed
    • XML presentation was fixed (NULL value handler)
    • Users can see chart presentations for non-numeric values, for example, for salary or grades
    • Charts rendering errors visualization was improved
    • Filters/orderings/colors reset UI was significantly improved
    • Grouping panel icons were improved
    • Drag-n-drop in the Grouping panel was fixed on Linux
    • Find/Replace dialog and shortcut in the Value view panel were fixed
    • Column description was added to the Metadata panel
    • Displaying of images in the Value view panel was fixed on Linux
    • Column tooltips were fixed
    • Confirmation dialog for the result set filtering was improved
    • An issue with closing the Result when saving data was resolved
    • Render of non-displayable characters was improved
  • Spatial data viewer:
    • Geometry object labels were added to the map (configurable)
    • Curves rendering was implemented
    • Copying of spatial viewport/selection bounds was fixed
    • EWKT format support was added
    • Toolbars and lasso visibility toggle were fixed
    • Spatial data types: curved geometries linearizing was fixed
    • Spatial viewer now hides empty labels
    • Spatial tiles configuration was fixed 
    • Non-display of PostGIS geometry due to missing SRID prefix was fixed
    • Saving picture in Spatial view was fixed
    • Spatial values rendering was fixed
    • Spatial image capture was fixed
    • Special character rendering was improved
  • ER Diagrams:
    • The issue with element removal after using the View Style option was fixed
    • The grid foreground color was fixed
    • Saved diagrams can now be opened on other computers
    • CTRL+SHIFT+ENTER opens the selected table diagram
  • Execution plan: The white background in the dark theme was fixed
  • Data transfer: 
    • Import of multiple sheets from an XLSX was implemented
    • The issue with exporting a table without data when using bulk loading was fixed
    • Lazy initialization of configuration pages was implemented
    • The issue with the duplicated file selector dialog was fixed
    • Export in XML format was fixed (the doctype section is now not optional)
    • The issue with long filenames on Windows was fixed
    • Previous export settings loading was fixed
    • Import settings handling was improved
  • Connectivity:
    • Now you can connect to a database using Kubernetes proxy. To configure it, click the “Network configuration” button in the connection dialog.
    • ODBC driver was enhanced: driver properties can be read and saved, date conversion works as expected and some other minor bugs were fixed
    • The “Automatically end long idle transactions” option was redesigned
    • Authentication failure when connecting via SSH was fixed
    • Now users can connect with the jump server using SSHJ
    • The issue with connecting to Azure SQL Server using Active Directory was fixed
    • The issue when adding driver properties was fixed
    • AWS SDK version was upgraded which fixed the issue with connecting via AWS SSO from CLI fixed
    • AWS STS client failing was fixed
    • AWS SSO authentication doesn’t ask for a user password
    • Google Cloud authentication profiles now have different names
    • Kerberos support in legacy JDBC drivers (Hive) was fixed
    • The user name/password prompt dialog was fixed for SSH tunnels
    • Duplicates on driver creation were removed
    • The issue with Maven artifacts editing was fixed
    • Opening the Trust store was fixed on macOS
  • Security:
    • Certificate management was added: You can find CA certificates used for SSL access in the Trust store section in Preferences or import your own certificate.
    • Project and user password security was improved.
    • We have improved the security of storing user settings.
    • SQLite driver version was updated due to the vulnerability CVE-2023-3269.
    • Bug with connection and project password conflict was fixed
    • Security issue with two project passwords asked on startup was fixed
    • User passwords now cannot be seen by using a variable
  • 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
    • JAWS and Narrator support was improved for the Data editor and vertical tabs
    • High contrast theme support was significantly improved. You can choose a high contrast theme in your OS, and the DBeaver high contrast theme is enabled.
  • Databases
  • Azure MS SQL: The execution plan is working now
  • Athena:
    • Multi-catalog support was added
    • IAM roles can be used for authentication
  • BigQuery: 
    • Driver version was upgraded to 1.3.3 
    • DDL for tables, views, and stored procedures was added
  • Cassandra: The SSL connection page was redesigned
  • Clickhouse: arrays and structures visualization was fixed
  •  DB2: Users can see Column Mask Objects
  • DB2z and Denodo: “Show duplicates” button in the Grouping panel was fixed
  • Derby: Grouping query generation is fixed
  • DuckDB: 
    • LIST data type support was added
    • TIME/TIMESTAMP data types support was added
  • DynamoDB: Inability to access with 3d party account was fixed
  • Firebird: Filters and sorting in the Grouping panel were fixed
  • Greenplum 7.0:
    • Function DDL was fixed (default parameter values)
    • Partition metadata reading was enhanced
    • Tables DDL was fixed — the USING part was added (for version 7)
    • External tables reading was fixed
  • IBM i: driver download was fixed
  • MongoDB: Create index options are now handled
  • MySQL: The issue with the missing table partitions folder was resolved
  • OpenGauss DB: JSON data types support was added
  • Oracle:
    • XML presentation was added 
    • Dates of creation and modification appeared in the information about the packages
    • Table partitions and subpartitions reading were fixed
    • Partitions cache refresh was fixed
    • Missing tablespace statistics after object update was added
    • Stored procedures edit/save were fixed
    • Table DDL now shows permission grants in “full” mode
  • PostgreSQL:
    • Enum columns ALTER was fixed
    • An issue with duplicated tables was resolved
    • The default native clients (pgsql, pg_dump) version was changed to 15
  • Redshift: SQL dialect was enhanced with extra keywords
  • Teradata:
    • Database reading, search, and auto-completion in hierarchy mode were improved
    • The issue with the missing templates was fixed
  • The Salesforce CDP driver version was downgraded to version 1.16.0 due to the exception
  • SingleStore: Triggers are now supported
  • Snowflake:
    • Quotation rules for object identifiers were added
    • Bulk load support in data transfer was added 
  • TimescaleDB branding was updated
  • Vertica: stored procedures are supported, you can view and execute them. The execution plan is available, including JSON queries. 
  • Yellowbrick: 
    • Execution plan visualization was fixed
    • The stored procedures drop query was fixed
  • Localization:
    • Chinese Simplified localization was improved 
    • Chinese localization was updated 
    • German localization was improved 
    • Users can now select Portuguese as the default language during installation or in Preferences
    • Portuguese localization was improved