Interested in an awesome DbVisualizer shirt?

Report a bug in a beta version and qualify for a our great looking and soft long sleeve DbVisualizer shirt.

Release Notes

Improvements

  • Command Line Support (dbviscmd) The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)
  • DB Support: Exasol Always pass SQLs to the Exasol database with LF instead of CRLF line separators
  • Enable the Procedure Editor for UDFs and Functions in Exasol
  • Data tab Data tab should have a "Reload with Sorting as ORDER BY" action used to reload from database using a ORDER BY clause defined by the current sorting in the grid
  • Export For Excel exports, the "Include original SQL" setting in Export Grid and for @export ExcelIncludeSQLCommand parameter should allow: "sheet" parameter in addition to "none", "top", "botton"
  • The Open as Spreadsheet action should put the SQL in a separate sheet
  • SQL Commander Add new "Set Modified State when Scripting" setting in Tools->Tool Properties under General / SQL Commander
  • The "Generate Command for dbviscmd" should automatically connect if not already
  • Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
  • SQL Formatter Add "Line Break Before Semicolon" setting
  • Table Data Editor Add a link to tool properties when the "Number of rows limited by <link>Max Rows at First Display</link> setting" balloon in the data tab is displayed

Bugs Fixed

  • Cell Viewer/Editor Format/Unformat JSON in Cell Editor in DbVis Beta 110.3052
  • Database Objects Tree Error when deleting empty folder in Databases tab
  • Scripts If focus not in the Scripts list, renaming a file using right-click immediately cancels the editing

New Features

  • DB Support: Snowflake Add extended support for Snowflake

Improvements

  • Data tab Option to prevent any filter from being used when loading a table during its first display
  • Driver Manager Update bundled JDBC drivers
  • References Selected table nodes in the references graph should not change background color
  • SQL Editor Offer GUI help for regular Expression replacement text (similar to the helper for the Find text)

Bugs Fixed

  • DB Support: PostgreSQL For some PostgreSQL installations the pg_catalog.pg_database is empty resulting in no databases being displayed in the databases tab
  • General Getting error: "For input string: "202-ea"" at startup of beta...
  • Look and Feel: Windows
    OS Support: Windows
    Error during startup of 110.3042 on Windows
  • OS Support: Windows dbvisgui.bat script fail on Windows
  • References Strange link "handles" in the references graph
  • Highlighting edges for the selected node should do a toFront() so all of the edge is colored
  • SQL Commander Disconnecting an active SQL Commander leads to an error

New Features

  • Cell Viewer/Editor Add options to format/unformat JSON in the cell editor
  • Command Line Support (dbviscmd) dbviscmd should prompt for variables in connection details and variables used in scripts
  • DB Support: MariaDB Add support for MariaDB
  • Database Objects Tree Show all contained database connections when selecting a database connections folder
  • Need capability to make it easier to scope what database connections that should be updated in multi connections edits
  • Export Add new "Export Visible" and "Open Visible as Spreadsheet" actions for grids that considers any current filters, sorting, and visible columns in the grid
  • Mail Support
    SQL Commander
    Add @mail client side command used to email the result set from a query or file
    See the discussion here
  • SQL Commander Add a "Morph to Delimited List" function in the SQL Commander
  • Add new @open <file | URL> command used to open file in associated program or URL in web browser
    See the discussion here

Improvements

  • Create/Alter Table
    DB Support: MySQL
    Add support for check constraints in the Create/Alter table dialog for MySQL
  • Create/Alter Table
    DB Support: Oracle
    Make it possible to change the visibility of a column through the Create and Alter table dialog
  • DB Support: MySQL
    DDL Generator
    Improve support of the ON UPDATE clause for temporal types for MySQL
  • DB Support: MySQL
    Procedure Editor
    Automatically set SQL Mode when editing Procedures and Functions
  • DB Support: PostgreSQL
    Query Builder
    Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQL
  • Export Add "Auto Resize Columns" for Excel export
  • Grid Component Add a new Copy Selection As->Copy Selection as AND/OR clause
  • Key Bindings Possible to assign a modifier with TAB as key binding
  • Should be possible to easily browse all available keyboard shortcuts
    See the discussion here
  • Key bindings editor need an option to locate an existing key binding and filtering
    See the discussion here
  • Allow filtering key bindings in Tool Properties->Key Bindings
    See the discussion here
  • References When Highlight Links is checked, do also color code the associated column names in the source and target nodes
  • Table references to self (same table) should attach to the corresponding column names when using Hierarchic layout and not in random positions
  • Certain controls in the References graph requires Hierarchic layout. Highlight this condition for controls when not using hierarchic layout mode
  • SQL Commander Add "Change Default Values..." in the SQL Commander Options menu and SQL Commander toolbar drop-down
  • Show the full path for the current database connection when hovering the Database Connection drop-down
  • Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
  • Refresh of the object tree does not refresh the Catalog/Schema drop-down lists
  • SQL Editor Show visible margin at user specified column
  • Add support for adding linefeed, tab etc. in the replacement text in the Replace dialog
  • SQL Formatter Allow setting indent for joins INNER, LEFT OUTER, RIGHT OUTER
  • SQL Formatting suggestion
  • Allow for having multiple SQL Formatting profiles
  • SQL Formatter should use the keyword lists defined for each supported database (use when for example upper/lower case keywords)
  • Make it possible to add custom keywords that are upper/lowercased along with standard
  • Introduce a new SQL Formatter
  • Add multiple indentation levels and other improvements
    See the discussion here
  • The Format SQL->Copy/Paste Formatted should allow setting that formatting should not be applied

Bugs Fixed

  • Auto Completion Having Fully Qualify Objects for Auto Completion and then AC a table name, database.null.table is inserted
  • DB Support: PostgreSQL Space is inserted in middle of Operator when formatting
  • Data tab Generate Filter for quoted string fails
  • Data tab
    Grid Component
    NULL and duplicated values not handled properly in "Copy Selection as IN Clause" and "Generate Filter & Sort"
  • Export Exporting Binary/BLOB to File with JSON format outputs the binary data as is rather than the special ${data8-1||blob/8.png||BinaryData||noshow vl=file}$
  • Export
    Import
    Malformed XML generated when export DbVis style XML
  • Key Bindings
    OS Support: macOS
    Bundle Java 13 on macOS to solve that ALT key bindings suddenly fail to work
  • OS Support: macOS The GUI doesn't accept any mouse or key input unless minimise/maximise or switch virtual desktop, fixed with Java 13
  • Procedure Editor
    SQL Editor
    The line break style (CRLF or LF) should be retained when editing an existing file or database code object
  • SQL Editor Using Ctrl+A/Cmd+A keybinding to Select All will not enable some right-click actions unless opening the menu again
  • SQL Formatter Schema name may be preceded by blanks
  • UNLOGGED keyword with create table statement breaks formatting
  • Script table insert adds the schema in uppercase
  • SQL Formatting On Oracle With Comments In With Clauses
  • Format with string literals longer than max Line Width results in invalid SQL

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings.

Close