intro
The latest version of DbVisualizer, version 23.2, is now available and comes with a range of important updates.
These include improvements in connections and driver management, extended SQL permissions, improved database support, as well as performance and compatibility fixes. While we continue to work on larger features for future releases, we are excited to offer these important updates to our users.
Please see the release notes for a detailed list of changes.
connections and drivers
Connections and driver management.
A number of improvements have been made to how DbVisualizer handles database connections and drivers.
Driver artifacts are now shared between driver definitions to allow reuse, save disk space and improve maintainability.
Improved import
Exporting database connections now exports the corresponding user drivers. A user driver will be created automatically when importing a connection previously exported without the driver.
Maven repositories
In Tool Properties, a server availability indicator is now available in the list of Maven repositories.
DATABASE-SPECIFIC IMPROVEMENTS
Improved database support.
PostgreSQL and Greenplum
Foreign servers are now displayed per database in the objects tree with the corresponding foreign tables as sub-nodes. DbVisualizer also generates DDL for foreign tables.
Snowflake
New data views for database, warehouse, server info and user parameters.
AND MORE
Other improvements
Detection of missing WHERE clause
DbVisualizer now detects DELETE and UPDATE statements with a missing WHERE clause and warns the user. This behaviour is controlled in Tool Properties > Permissions.
Support for multiple displays
Adjust windows to visible screen area when screen setup changes.
Performance
The performance of the database objects tree has been improved by optimising the auto-detection of database type.