The naming of DbVisualizer releases has been updated to use a new format in 2023. In an effort to increase transparency and clarity of our product release cycle, we're adopting the format of [YEAR].[RELEASE-NUMBER].
What's new
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.
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.
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.
Cassandra object types ->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.
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.
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.
To see all changes in DbVisualizer 23.1, please see the Release Notes.