Release notes

You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 23.2.5 version.

23.1 - Released 2023-03-16

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
Change version
View all versions ->