intro
DbVisualizer 25.1 brings support for DynamoDB, the new Files tab for more convenient handling of SQL scripts, significant security improvements, a major performance boost to references graphs, and more. Continue reading for more details.
NEW DATABASE SUPPORT
Support for Amazon DynamoDB
This release introduces support for DynamoDB, a serverless NoSQL database from Amazon. You will be able to explore tables, partition and sort keys, local and global indexes, view and edit table data including maps, sets and attributes with mixed content, and execute PartiQL scripts using SQL Commander.
You will be able to explore tables, partition and sort keys, local and global indexes, view and edit table data including maps, sets and attributes with mixed content, and execute PartiQL scripts using SQL Commander.
script management
Introducing the Files tab
Organising SQL scripts has become more convenient than ever before. In addition to Bookmarks, it is now possible to add any external script directory for easy access in the application. Add a custom path to better suit your preferred way of working, or mount a shared script directory or network location for easier sharing with the rest of your team. Any external changes in the mounted directories will be picked up by DbVisualizer, and asynchronous I/O will make sure your work doesn’t get blocked by a slow file system.
Add any external directory to Files
With the new Files tab, any external script directory is close at hand. To mount a directory of your choice for quick access, just drag and drop it onto the empty area in the Files tab. Bookmarks and Monitors familiar to veteran users, as well as the user’s home directory are pre-mounted for convenience.
Remember the latest used database connection for all scripts
When you work with a SQL script, key metadata such as the used database connection, catalog and schema will be recalled the next time you open the same script. You will be able to continue exactly where you left off, getting up to speed quicker.
Performance
10x faster references graphs
Building on the groundwork done in the previous feature release, we have used the improved database metadata cache to speed up various functionality throughout the application including Query Builder, Navigator, References, Data tabs, and more.
The exact performance impact will depend on your schema, database type and network configuration, but you shouldn’t be surprised if your references graphs are displayed at least 10x times faster.
DATABASE-SPECIFIC IMPROVEMENTS
Improved database support
Support for DuckDB and QuestDB
This release adds basic database support for DuckDB and QuestDB. You will find pre-defined entries for both databases in the driver manager, making it easy to get started.
New object types in Snowflake
In addition to the many already supported object types, stream, tasks and alerts are now available in the database objects tree when working with Snowflake.
Security
Improved encryption and sensitive data management
We are working continuously to make sure your database connections and other settings are stored securely. In this release, we have re-architected the way sensitive data is managed in DbVisualizer and improved encryption to further strengthen the protection of your passwords in storage. This affects both local and exported application settings, independent of whether you are using the master password feature or not.
AND MORE
And more improvements across the board
Zoom editor text
It is now possible to quickly change the font size by zooming in and out using the mouse wheel, trackpad or similar. Unlike the font settings in Tool Properties, zooming applies to the current editor only.
Further refinements in auto-complete
Improved handling of some advanced cases including WITH, CASE, UNION and subquery JOINs.
Security updates
As is customary with our larger updates, this release includes the latest security upgrades for third-party dependencies and template drivers.
And that’s not all…
There are a total of 28 improvements and fixes that you can read about in the release notes.
OTHER RELEASES