intro
DbVisualizer 24.3 includes significant performance improvements and brings many updates that will streamline your workflow. See a video summary of the changes in under two minutes below.
NEW DATABASE SUPPORT
Introducing extended support for Databricks
DbVisualizer now offers extended support for Databricks, extending the basic features available earlier. You can now view and manage Views
, Materialized Views
, Functions
, Locations
, Storages
and much more directly from DbVisualizer to enhance productivity, streamline your data analysis, and leverage advanced features. With a simplified connection flow and readily available drivers, integrating Databricks into your workflow has never been easier.
AUTO-COMPLETE
Improved auto-complete
We've improved the auto-completion feature to make your coding experience smoother and more efficient.
Speed and responsiveness
Thanks to an improved metadata cache, auto-completion is now faster and more responsive than ever. In addition, the cache is now persistent between sessions so you can get back to work faster after reconnecting or restarting.
Case sensitivity
We have also improved the way auto-completion handles letter case when completing tables and columns. Whether your database is case-sensitive or not, auto-completion now respects your settings, reducing errors and ensuring consistency in your code.
Inline configuration
The auto-completion popup has been re-designed to provide direct access to relevant application and connection settings, allowing you to easily configure auto-completion to best suit your preferred way of working.
Editor templates
Preview the code before expanding an editor template
With editor templates, it is easy to reuse code snippets that you often include in your scripts. Start typing the template abbreviation and press TAB
to expand. If several replacements are available, they will be presented in a popup. The new release further simplifies this workflow by including a preview of the corresponding code snippet in the popup containing the matching templates.
Code editor
Switching between recent editor tabs
Switching between recent editor tabs is now more convenient than ever. Use the quick-files button ( ) or the keyboard shortcut CTRL + ALT + O
(Windows) or CMD + OPTION + O
(Mac) to effortlessly jump back to your recent work without sifting through all open tabs. The most recent tabs are displayed first, making it easy to continue where you left off.
DATABASE-SPECIFIC IMPROVEMENTS
Improved database support
Support for MySQL 9
MySQL-specific support in DbVisualizer has been extended to include MySQL 9, which is the most current version of the MySQL database engine at the moment of writing. Among other things, this includes support for the new VECTOR
data type.
Support for LOAD DATA
in MySQL, MariaDB, and SingleStore
We have added native support for the LOAD DATA
command in MySQL, MariaDB, and SingleStore. This provides a more efficient alternative to the existing table data import functionality, and is particularly useful when dealing with large amounts of data.
User-defined data types in Create/Alter Table
It is now possible to use user-defined data types when creating and altering tables in DbVisualizer, in addition to built-in types supported previously.
Handling of YEAR values in MySQL and MariaDB
A new setting has been introduced to control the handling of YEAR
values in MySQL and MariaDB. Previously, this was achievable using a low-level driver property, but it's now built into the application for easier access and use.
Improved efficiency of the Max Rows setting in PostgreSQL
We have optimised the Max Rows setting in the Data tab for PostgreSQL. This improvement results in faster performance when working with large tables.
SETTINGS AND CONFIGURATION
Search in Tool Properties
Navigating through application, database and connection settings is now a breeze with our new search feature. Quickly find what you're looking for within Tool Properties and Connection Properties. Matching tabs and sections are highlighted, guiding you to the relevant configuration options.
APPLICATION UPGRADES
In-app updates
Say goodbye to tedious update processes. With our new in-app updates, you can upgrade to the latest version of DbVisualizer without ever leaving the application. The latest release will be downloaded automatically and upgrading is as simple as confirming it’s time to apply the new changes.
AND MORE
And more improvements across the board
Text wrapping in data grids
The new release introduces support for text wrapping in data grids. Now you can work with tables that contain long strings without scrolling or opening the cell editor, which makes data analysis more comfortable and efficient.
Discover matching items quicker when using Show Object at Cursor
Searching for database objects may be time consuming, depending on the database engine and the data. Intermediate search results are now presented during the search. This means you can find what you're looking for without waiting for the entire database to be processed, saving you valuable time.
Quicker Find and Replace in large documents
The new release includes optimisations in Find and Replace. This will be noticeable when working with larger scripts, saving you time during extensive edits.
Improved performance when using slow drives
Handling of recent files has been optimised to achieve better performance, particularly when using slow network drives, making the application more responsive.
Improved detection of new database driver versions
DbVisualizer can now detect new database driver versions even when artifact coordinates change, ensuring continuous compatibility.
Security and platform updates
This release ships with Java 21 and includes the latest security upgrades for third-party dependencies and template drivers.
And that’s not all…
There are a total of 51 improvements and fixes that you can read about in the release notes.
OTHER RELEASES