Apache Cassandra is an open source NoSQL distributed database trusted by thousands of companies for scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data.
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service (PaaS) that supports querying using ANSI SQL. It also has built-in machine learning capabilities.
Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.
SSH tunnel setup has been redesigned from being defined per individual database connections to a separate feature allowing shared SSH configurations by multiple database connections.
Administration is now a lot easier and the new testing feature eases the burden of understanding why a connection cannot be established.
The connection setup now only shows two settings for SSH, one to select whether to use SSH or not, and another to pick the SSH configuration:
Show database connections associated with an SSH configuration:
It is now easy to test an SSH configuration and browse the log indicating any problems:
Export fixed column result sets.
Exporting in fixed column width format has been around in the Export Grid functionality for some time. Now we're happy to announce the TXT format is available also for Export Table, Export Schema, and the @export client-side command.
The TXT export output:
Images in binary data types can now be rendered in grids.
Viewing images in binary data fields has until now only been possible by individually opening the cell. With the new support, images can be displayed as thumbnails in the grid. The size can be controlled in Tool Properties.
COPY DATA-VIEW AS SELECT STATEMENT
Copy your filtered and sorted Table Data view as a SELECT statement.
A new button to Extract Filter & Sort as SELECT action has been added to the Data tab.
After having filtered and/or sorted the table data in the Data tab, you can use the new button to copy the view as a SELECT statement.
Clicking the button in the above example (a filtered and sorted data tab) generates the following code.
Auto reconnect in the SQL Commander.
Now the SQL Commander automatically re-establish the connection with the database in case it is dropped closed while executing a script.
And more improvements across the board.
Runs on Java 17
Java 17 comes bundled with DbVisualizer on all platforms.
Support for Windows 32-bit removed in 14.0. Use an older DbVisualizer version for Windows 32-bit support.
SQL Server User Management
Support to create, modify, and drop of users and logins.
MS SQL Server
Support added for H2 version 2.
New @command ignore/resume client side command used to ignore/resume the execution of any client side command.
New @stop now client side command used to stop the execution of the script.
Batch import as default
Batch importing multiple rows from a database per database request.
Full script search as default
Make Search Full Script default in SQL History.
To see all changes in DbVisualizer 14.0, please see the Release Notes.