intro
Introducing DbVisualizer 24.1. This new release comes with an all-new Code Editor, that has been completely overhauled and improved. It comes with improvements such as a better Find and Replace tool and a smarter Auto-complete function. We're also introducing Workspaces, a handy feature that makes switching between contexts and tasks simpler. You’ll also see updates to how you create new connections, how the master password behaves, performance improvements, better database support, and more.
Version 24.1 is our first release of 2024, and we are excited for what’s yet to come. Our plan is to accelerate development even more this year, build on our progress from 2023, and invest even further in additional capabilities and reliability in 2024.
CODE EDITOR
SQL Editor rebuilt from the ground up
We've completely overhauled the SQL editor in our latest update to be more user-friendly and efficient. This new version includes many improvements, both big and small, all aimed at giving you a great environment to work in.
Find and Replace
We've redesigned the Find and Replace functions for efficiency and ease of use. Now, you can seamlessly switch between searching and replacing text, choose to match by case or whole words, utilize regular expressions for complex searches, and easily navigate between matches. All of this is accessible through a straightforward, inline panel.
Auto-complete
The new SQL editor features a newly developed auto-completion engine designed to be smarter and more accurate than before. Among other things, it handles complex queries better and understands the difference in context between the inner and the outer parts of the query.
The default shortcut to trigger the auto-complete feature in the editor is CTRL + SPACE.
WORKSPACES
Switch between multiple contexts using workspaces
The new release includes support for workspaces, a feature that allows you to switch effortlessly between different work contexts. Each workspace operates independently, complete with its own connections, drivers, scripts, and settings. This functionality makes it easy to manage distinct environments, projects, or client engagements. You have the flexibility to tailor each workspace to suit your specific requirements.
Workspaces can be created and opened through the File -> Workspaces menu.
DATABASE CONNECTIONS
Create a connection from a database URL
We've introduced an additional method to create database connections, to simplify the setup process. Now, you can begin by entering your database URL, and DbVisualizer will automatically choose the matching drivers for you.
MASTER PASSWORD UPDATE
Streamlined handling of the master password
If security is a priority for you, you're likely already familiar with our master password feature. In this new release, we've refined the master password experience to make it more intuitive and less obtrusive. This enhancement allows you to maintain robust security without compromising on ease of use.
PERFORMANCE
Performance and stability fixes
Improved database read performance
We've reduced the need for roundtrips and are handling paging in a smarter way for BigQuery, SingleStore, Vertica, and Oracle databases. This results in better response times and less load on the database.
Additional syntaxes for multi-row inserts
We’ve added support for additional syntaxes for multi-row inserts that can be generated when exporting table data. Using multi-row inserts is essential to the performance when importing large data sets. This release extends the support for the default SQL-92 syntax to also include syntaxes specific to Oracle and Cassandra, as well as the generic union-based syntax.
Smarter memory management
Memory used by scripts and result sets is released faster, making DbVisualizer more efficient when processing large result sets and working with complex scripts.
Database specific improvements
Improved database support
Oracle
The Grant Privilege action has been added for materialized views, functions, and procedures in Oracle databases. With this addition, you can give privileges to database users to perform operations on the corresponding database object. To give privileges to several objects at once, select them in the database objects tree first.
Microsoft SQL Server
SingleStore
Now, DbVisualizer includes the capability to display the DDL for pipelines in SingleStore. This allows users to view the underlying SQL statements that define the structure and configuration of pipelines in their database.
Vertica
Support for procedures in Vertica has been improved. Now it is possible to create stored procedures as well as external procedures in the GUI, and more information about existing procedures is shown both in the Procedures view and in the database objects tree.
AND MORE
Additional improvements across the board
Navigation in the row form editor
We've added navigation buttons to the row form editor in DbVisualizer. This update makes it easier to move between rows within a full result set, while staying within the familiar interface of the row form editor. This enhancement streamlines the process of reviewing and editing data, providing a more seamless and efficient user experience.
Adjust window sizes to the selected application font
As you adjust the font size within the application, the windows will automatically resize to match, ensuring a consistent and optimal viewing experience. This feature not only improves readability but also provides a more comfortable and adaptable user interface, catering to various screen sizes and user preferences.
Security updates
We keep strengthening our security infrastructure by upgrading to the latest version of the Java platform and updating third-party dependencies. This approach to maintaining up-to-date software components is a key part of our commitment to providing a secure environment for our users. DbVisualizer now comes bundled with Java 17.0.9.
Please see the Release Notes for a full list of updates in DbVisualizer 24.1.
OTHER releases