intro
The newest feature version of DbVisualizer, version 23.1, is now available. Keep reading for an overview of what has been included in the new release.
Please see the release notes for a detailed list of changes.
NEW DATABASE SUPPORT
Extended support for ClickHouse.
We're delighted to add ClickHouse to our list of data sources with extended support. ClickHouse is an open-source column-oriented database that can be used to generate analytical data reports in real-time using SQL queries. Among other things.
This means that the DbVisualizer now recognises and manages objects specific to ClickHouse. It also means that users now can enjoy the full suite of DbVisualizer features when working with ClickHouse.
DATABASE-SPECIFIC IMPROVEMENTS
Improved database support.
The new release comes with a number of notable database-specific improvements.
Expired password management in MySQL and MariaDB
In MySQL and MariaDB, expired passwords are now detected by DbVisualizer and can be reset.
Added support for stored procedures in Vertica
Stored procedures introduced in Vertica 11 are defined and can be executed inside your database. This lets them communicate and interact with your database directly to perform maintenance, execute queries and update tables.
Support for multifile databanks in Mimer SQL
In Mimer SQL, tables and indexes reside in a databank. In the past a databank has been equivalent to a file in the file system. Now, a databank may consist of one or several files on one or multiple disks. In the new release, DbVisualizer supports both single file and multifile databanks.
Generate DDL for materialized views in Cassandra
A materialized view is a table built from data from another table with a new primary key and new properties. DbVisualizer can now generate DDL for Cassandra's materialized views.
Improved performance in Snowflake queries
Metadata queries were optimized for Snowflake resulting in significantly improved performance.
Basic support for CockroachDB
Verified JDBC support for CockroachDB. Users will now find an entry for CockroachDB in the driver manager, making it easy to get started.
SSH IMPROVEMENTS
5x faster SSH connections.
Secure Socket Shell, commonly referred to as SSH, is a crucial technology allowing to gain secure access to servers over unsecured networks. In DbVisualizer 14 there were some notable changes to how SSH server is configured. This release adds further useful improvements.
Choose SSH implementation
The default SSH client toolkit has been updated and is now up to 5x faster than before. For compatibility, it is possible to choose which client package to use for each SSH configuration.
Increase security with SSH jump servers
You can now configure DbVisualizer to use a jump server (also known as jump host, jump box, SSH bastion host, gateway server or SSH proxy server) with your SSH connection to make it even more secure.
WINDOWS ARM64 SUPPORT
Installer for Windows ARM64.
We have added an installer optimized for Windows running on the ARM64 architecture, which will give a significant boost in performance when using DbVisualizer on Windows ARM64.
AND MORE
And more improvements across the board.
IMPROVEMENT
DESCRIPTION
AFFECTED DATABASES
Export and import of SQL tabs and recent files.
SQL Commander tabs and recently accessed files can now be included when exporting DbVisualizer settings, making upgrades and migration between environments smoother.
All
Drag and drop files.
Users can now drag and drop files into path fields and file chooser dialogs in the application.
All
Compare formatted values.
When comparing result sets in the comparison tool, users will now be able to choose whether to compare formatted or unformatted data.
All
Handling of inaccessible drives on Windows.
Improved the experience for users running DbVisualizer on Windows with inaccessible network drives.
All
Look and feel updates.
Look and feel has been updated with new application and editor fonts, embedded menu bar in Linux, extended file chooser in Windows and more.
All
Upgraded driver definitions.
JDBC drivers have been updated to the corresponding latest versions and verified to work with the application.
All