DbVisualizer 23.1

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.

 

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 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

 

To see all changes in DbVisualizer 23.1, please see the Release Notes.

 

New Features

DB Support: ClickHouse

Add support for the ClickHouse database

Improvements

Compare

Add support for comparing formatted values in Tools -> Compare

Connection Setup

Allow using tilde ("~") to represent user's home folder in the "Database File Name" field

Connection Setup

DB Support: MariaDB

DB Support: MySQL

Detect expired passwords and suggest password reset

Connection Setup

SSH

Add support for SSH jump servers

DB Support: Cassandra

Generate DDL for materialized views in Cassandra

DB Support: CockroachDB

Add a template driver for CockroachDB

DB Support: Greenplum

DB Support: PostgreSQL

DB Support: Redshift

Simplify CREATE VIEW with complex FROM clauses by avoiding unnecessary parentheses

DB Support: Greenplum

DB Support: PostgreSQL

DB Support: Redshift

DB Support: Yellowbrick

Generate IF EXISTS in DROP statements

DB Support: Mimer SQL

Update database profile for Mimer SQL with support for multifile data banks

DB Support: Vertica

Add support for stored procedures introduced in Vertica 11.0

Driver Manager

Upgrade template drivers and bundled drivers to the corresponding latest version

Export

Allow using the tilde character ("~") as prefix in file system paths

Export/Import User Settings

Add support for export/import of SQL Commander tabs

Export/Import User Settings

Favorites

When importing favorites, place the imported items in a new folder

Export/Import User Settings

Installation/Update Installation

Add support for export/import of the recent files list. Also, recent files are preserved when upgrading to a new version

File Chooser

Add support for drag and drop in file path fields

Add support for drag and drop in file chooser dialogs

See the discussion here

File Chooser

OS Support: Windows

Performance/Stability

Add an option to ignore disconnected drives that may affect application performance

Grid Component

Tool Properties

Adjust the "Grids" font setting in Tool Properties to affect result sets rather than all grid types

Import

Make the option to stop on error in the import table dialog persistent

Installation/Update Installation

OS Support: Windows

Web

Offer a Windows installer with bundled JRE for ARM

Performance/Stability

SSH

Add option to choose SSH client package, improved performance of the default setting

SQL Commander

Display an arrow in drop-down cell editors to indicate there are options to choose from

Theme: FlatLaf

Look and feel updates with new application and editor fonts, embedded menu bar in Linux, extended file chooser in Windows and more

Workspace

Wrap around when switching between tabs using menu commands

Bugs Fixed

Connection Setup

Long database URL overlaps with connection timer in the Connection tab

Improve filtering in the new connection popup

"Connect All" may fail when there are broken connections and master password is enabled

Create/Alter Table

Alter Table displays wrong referenced table for foreign key constraints when the referenced table is in a different schema

DB Support: PostgreSQL

Alter table shows SQL in the SQL Preview even if nothing has been changed

DB Support: Snowflake

Slow query execution due to incorrect implementation of metadata queries in the database driver

DB Support: Snowflake

SQL Commander

Schema drop-down doesn't reflect the last executed 'use schema xxx'

Database Profile: Actions

Action dialog is placed in top left screen corner rather than center of the parent window

Driver Manager

Connections may lose driver reference when migrating

Export

Export of tables with multiple computed columns fails

Export

SQL Commander

@export may generate wrong SQL when executing select from a qualified table

Export/Import User Settings

Improve feedback when importing user settings from an newer version of DbVisualizer

Export/Import Settings dialog is truncated on smaller screens

Favorites

Exception when dragging a database connections folder into the Favorites tab

Installation/Update Installation

OS Support: macOS

Shell scripts for starting DbVisualizer are not executable in 14.0.3

Monitor

If the monitor is running in auto-load mode and the connection is lost, the monitor is never reloaded despite clicking connect in the error message

OS Support: Windows

Executing resolveJRE.bat twice in the same command prompt fails

Object View

Selecting a folder in the connection tree may cause an exception when autoscroll to object view is enabled

Performance/Stability

Handle "memory pool not found" exception gracefully when running out of memory

SQL Commander

Extra tab key press needed to focus desired button in the connect dialog

SQL Editor

Remove duplicate items from the context menu in SQL Commander

Can't change type of variable to literal after use