Introducing DbVisualizer 24.3 - Now with Databricks support and more

Introducing DbVisualizer 24.3 - Now with Databricks support and more

Introducing DbVisualizer 24.3, packed with powerful new features and enhancements designed to elevate your database management experience. This version brings significant performance improvements and updates that will streamline your workflow.

You can try the new version below, or keep reading to see what's new.

Extended support for Databricks

We've expanded our support for Databricks, with more capabilities and deeper integration. You can now view and manage Views, Materialized Views, Functions, Locations, Storages and much more - all with a simplified connection flow and readily available drivers. 

 

Improved auto-complete

We've enhanced 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. The cache is persistent between sessions, so you can get back to work faster after reconnecting or restarting.

Case sensitivity
Auto-completion now better handles letter case when completing tables and columns. Whether your database is case-sensitive or not, auto-completion respects your settings, reducing errors and ensuring consistency in your code.

Inline configuration
The auto-completion popup has been redesigned to provide direct access to relevant application and connection settings, allowing you to easily configure auto-completion to suit your preferred way of working.

Preview code before expanding editor templates

With editor templates, it's easy to reuse code snippets that you often include in your scripts. The new release simplifies this workflow by including a preview of the corresponding code snippet when you start typing the template abbreviation and press TAB.

Switching between recent editor tabs

Switching between editor tabs is now more convenient than ever. Use the Quick-File Open 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. 

Improved database support

Support for MySQL 9
Our MySQL-specific support now includes MySQL 9, featuring the new VECTOR data type.

Support for LOAD DATA in MySQL, MariaDB, and SingleStore
We've added native support for the LOAD DATA command, providing a more efficient alternative to existing table data import functionality—especially useful when dealing with large amounts of data.

User-defined data types in Create/Alter Table
You can now use user-defined data types when creating and altering tables, giving you more flexibility over your database schema.

Handling of YEAR values in MySQL and MariaDB
A new setting controls the handling of YEAR values, now built into the application for easier access.

Improved efficiency of Max Rows setting in PostgreSQL
We've optimized performance when working with large tables, making data retrieval faster. 

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.

In-App updates

Updating DbVisualizer will be easier than ever. With our new in-app updates, you will be able to upgrade to future versions without leaving the application. Any upcoming release will be downloaded automatically, and upgrading is as simple as confirming when it's time to apply the update.

 

That's not all...

Text wrapping in data grids
Work with tables that contain long strings without scrolling or opening the cell editor, making data analysis more comfortable and efficient.

Discover matching items quicker with show object at cursor
Intermediate search results are now presented during searches, so you don't have to wait for the entire database to be processed.

Quicker Find and Replace in large documents
Optimizations in Find and Replace save you time during extensive edits.

Improved performance with slow drives
Handling of recent files has been optimized for better performance, particularly when using slow network drives.

Improved detection of new database driver versions
DbVisualizer can now detect new 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.

There are a total of 51 improvements and fixes that you can read about in the release notes.