Version 23.1
Release Notes 23.1
You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 24.3.1 version.
23.1 - Released 2023-03-16
New Features
Area
Details
DB Support: ClickHouse
Add support for the ClickHouse database
Improvements
Area
Details
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
DB Support: MariaDB
DB Support: MySQL Detect expired passwords and suggest password reset
Connection Setup
SSH Add support for SSH jump servers
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: 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: 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
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
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
Add support for drag and drop in file chooser dialogs
File Chooser
OS Support: Windows
Performance/Stability Add an option to ignore disconnected drives that may affect application performance
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
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
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
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
Area
Details
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
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'
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
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
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
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
Can't change type of variable to literal after use