DBeaver Lite 23.3

December 11, 2023
Changes since 23.2:
  • New drivers:
    • ScyllaDB
    • AlloyDB 
    • Azure Cosmos (Cassandra)
    • Dameng
    • JDBCX driver
  • General:
    • We switched to Eclipse 2023-09 as a base platform
    • Integration with the different cloud file systems was added
    • Restore defaults` on preference pages now resets to actual default preferences
    • Reset UI settings was fixed on macOS
    • A refresh button was added to the “Generate DDL” dialog
    • Comments in generated DDL now can be disabled (configurable)
    • Countdown visualization before auto-close was added for idle transactions
    • Extra tips were added in connection to the keep-alive configuration
    • The default file encoding was changed to UTF-8. This affects all external tools integration.
    • Web-based authentication is now can be opened in the embedded browser
    • Tips of the day were updated
    • Constraints rename was fixed
    • Idle transaction rollback notification was fixed
    • App crash when running on Wayland was fixed
    • java.compiler and java.scripting modules were included in bundled Java
    • Eclipse 2023-09 plugin API is now supported
  • General UI:
    • Scroll bars were added on the connection page, and other wizards
    • When exporting a project, a warning about replacing an existing project was added
    • The issue with broken quotes in localization files was resolved
    • Rollback countdown flashing was fixed
  • Database Navigator
    • Filtered object visualization was added
    • Script names are sorted alphabetically
    • Script folder opening was fixed
    • Click in empty space handle was fixed
  • SQL Editor:
    • SQL console can be saved as a script
    • Aliases proposals for tables with joins were improved
    • Auto-completion for complex SQL queries was improved
    • Enhanced smart completion is enabled (configurable)
    • Code completion for update statements was added
    • Smart completion and replacements of quoted expressions were fixed
    • Syntax coloring and code completion: smart columns and alias recognition were added (experimental)
    • 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 were fixed
    • COMMIT/ROLLBACK statements are now recognized as transaction state change statements
    • The issue with big string contents editing (JSON, XML) was resolved
    • JSON formatting in the separate editor was fixed
    • JSON functions keywords were added to the SQL Assist
    • Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
    • Quoting of identifiers with special characters was fixed
    • Representation of errors on query execution was fixed
    • Reconnecting of open editors when switching between Simple and Advanced view was fixed
    • Script statistics configuration was extended
    • Tabs closing in the horizontal mode were fixed
    • Script to connection association save was fixed
    • Redundant errors on opening SQL Editor for the first time were removed from the logs
    • Numerous improvements in single-tab results visualization were made
  • Data Editor:
    • Multiple query results can now be displayed vertically
    • `Go to column` (Ctrl+Shift+G) action was added
    • Column search was added to the Metadata panel
    • Users can add a shortcut for setting row color
    • Grouping panel now shows the actual executed SQL
    • Big content representation end editing was limited to 1MB (configurable)
    • Message about content representation size limit was fixed
    • The issue with the empty table after opening the Calc panel was resolved
    • Setting row color for the result set was fixed
    • The background color reset was fixed
    • App freeze in binary editor was fixed (MacOS)
    • Copy from row bellow/above command was fixed
    • The issue with hiding the wrong column from the context menu was resolved
    • Numeric formatting was fixed for floating point numbers
    • The decimal rounding error was fixed
    • Filter value search was fixed
    • Advanced Copy as HTML with spaces in the column names was fixed
    • The numeric value “infinity” representation was fixed
  • ER Diagrams:
    • Crow’s foot and Bachman notations were added
    • The diagram presentation was significantly improved
    • The issue with duplicate relations on the diagram was fixed
    • A diagram notations switcher was added
    • Connections rendering was improved
    • Issues with the notation switch were resolved
    • One-to-one connection rendering was fixed
    • Diagram update on metadata changes was fixed
    • Automatic re-layout on notation or routing change was fixed
  • Execution plan: 
    • The white background in the dark theme was fixed
    • Disappearing icons were removed
  • Data transfer: 
    • Columns automating mapping is now configurable
    • Excel (XLSX) export now supports columns auto-fit
    • The file import toolbar was redesigned
    • Attributes names for quoted attributes are handled correctly
    • “Copy as HTML” result presentation is improved
    • The issue with unquoted column names was resolved (in Data Import)
    • The library for XLSX export/import was updated, and many minor issues were resolved
    • Columns value transform expressions evaluation was fixed
    • All data transfers were migrated to a new IO API
    • Error “Data transfer IO error” was resolved
    • “Native clients” were renamed into “Local clients”
    • An update on conflict behavior was improved (now it respects indexes, too)
    • Database restore was fixed
    • The list of supported variables was updated
  • Connectivity:
    • Azure AD authentication was added for PostgreSQL, MySQL, and SQL Server
    • Driver download UI was improved: already downloaded driver files are colored in grey
    • JDBC drivers maven artifacts resolve was fixed
    • The “Propagate driver properties” option was added to the driver settings
    • SSH connection page validation is enhanced for jump servers
    • Complex JDBC driver support was improved (context classloader + driver cache)
    • Driver download error handle was fixed 
    • ‘Check for new driver version’ setting save was fixed
    • Security:
    • Many drivers were upgraded to avoid vulnerabilities: Neptune, Redis, Cassandra, Couchbase, BigQuery, Athena, Kafka, and YugabyteDB
    • The master password dialog was redesigned, and users can select what to use: master password or integrated security
    • Security pages in Preferences were improved
    • The Export functionality and Version Update can now be completely disabled.
  • Accessibility
    • Screen-reader support was improved (JAWS)
    • Editor tab names reading was fixed
  • Amazon Neptune driver: vulnerable dependencies were updated
  • Athena driver was updated to version 42-2.1.1.1000 
  • Apache Arrow: the promt to download the already downloaded driver was removed
  • AWS Neptune driver was upgraded
  • Clickhouse: 
    • Array map representation was fixed
    • IPv4 data representation was fixed
  • Google Spanner: table DDL generation was fixed
  • DB2 LUW: trigger editor was fixed
  • DB2 driver was upgraded to version 11.5.9.0
  • Databricks: The issue with national encodings was resolved
  • Greenplum:
    • The issue with case-sensitive table names was resolved
    • FFL for function parameters was fixed
    • External tables representation was fixed
    • Foreign key creation was fixed
    • Exasol: customer group creation was fixed
  • Firebird:
    • Several keywords were added
    • Default values for procedure parameters are now displayed
  • The Infux icon was changed
  • Materialized: system schemas loading was fixed
  • MongoDB: 
    • UUID representation was fixed
    • AI Smart Assistance was fixed
  • MySQL:
    • The driver version was upgraded to 8.2
    • MySQL5 driver is available 
    • Session manager now shows info from performance_schema
    • Unsupported engine types are replaced with the default one
  • OceanBase:
    • The views editor was supported
    • Routines and procedure parameters read were fixed
  • OpenEdge: root catalog is now hidden; data export was fixed
  • Oracle: 
    • Partitions support was added: the ability to manage partitions via UI
    • Materialized views indexes management was supported
    • Materialized views permissions and dependencies view were added
    • Comment for the created column was added
    • Column alter DDL was fixed (NULL clause)
    • Search package bodies as packages were supported
    • Comments were added to the newly created columns
  • PostgreSQL:
    • Default privileges presentation and editing were supported
    • The foreign tables folder was added
    • Backup/restore native tools execution was fixed
    • Procedure parameters validation was added to the debugger 
    • `Europe/Kyiv` timezone support was fixed
    • The issue with the VARCHAR limit change was fixed
    • Function comment delete support was added
    • Sequence permissions reading for quoted roles were fixed
    • Foreign key DDL was fixed (MATCH FULL)
    • Enum data type reading performance was enhanced
    • Incorrect restore was fixed
    • Foreign key creation was fixed
  • Redshift: 
    • Backup/Restore tools were deprecated and removed from the UI
    • Spectrum tables loading was fixed (for custom driver configurations)
  • SQLite: required columns creating was fixed
  • SQL Server: extra dialect keywords were added 
  • Snowflake:
    • Driver was updated to 3.13.25
    • Materialized views are now supported
    • Schema create UI was enhanced
    • The numeric data display was fixed
  • Teradata: Secure Zones presentation was improved
  • Trino: Views DDL support was added
  • Localization:
    • Brazilian Portuguese translation was fixed
    • Chinese Simplified translation was updated