Area
Details
Command Line Support (dbviscmd)
The command-line interface should allow connecting to a database not previously setup in the DbVisualizer GUI
Connection Setup
Should be possible to set a default value for a driver property in drivers.xml
DbVisualizer should register its application name ("dbvis") with the database so that any DB server process listing clearly tell what connections belong to DbVisualizer
The missing DB2 license jar file message at connect should be transformed to DbVisualizer instruction how to fix it
Remove Authentication Method dropdown and always include the Authentication Domain field in Options
Combine "Keep-Alive SQL" and "Validation SQL" into a single setting: "Validation SQL"
DB Support: Generic
Auto detect Database Type for Sybase IQ and Sybase SQL Anywhere (the corresponding JDBC driver must be selected)
DB Support: MySQL
Suppress Identical warnings when executing scripts
DB Support: Oracle
Allow resetting password for Oracle connections
Password due for expiration warning should be displayed when connecting to Oracle
DB Support: PostgreSQL
Set the ApplicationName driver property to "dbvis"
Show partition tables for PostgreSQL 10
Database Objects Tree
Allow double-click to expand database objects tree (and connect of database connections)
Add tooltip with explanation what overlay icons in the Databases tree list means
Database Objects Tree
Filtering/Filter Sets
Show number of non filtered objects instead of number of filtered objects
Driver Manager
Upgrade bundled JDBC drivers
Remove the System Classpath tab in the Driver Manager and log when loading JDBC drivers classes from the CLASSPATH instead of the JAR files
Export
Allow outputting large data exports to different files (out1, out2, out3)
Allow adding custom statements first/last in file produced by schema export
Optionally include column names in CSV only for first result or for all
Add option to not convert HTML special characters to HTML codes when exporting to HTML
Optionally include the Table name in HTML export
Make it possible to select all objects for Export Schema with one click
Allow for Date/Time/Timestamp data to be exported with JDBC escape syntax
Make it possible to assign the names for BLOB/CLOB files, e.g. based on the value of other columns on the same row
Possibility to set ExcelSheetName in export wizard
Should be possible to organize the output of schema export so that all DROP, CREATE and INSERTs are grouped
Use a separate File Chooser context for BLOB/CLOB files
Add the following parameters for @export set: HtmlColumnHeaderIsColumnAlias, JSONColumnHeaderIsColumnAlias, XmlColumnHeaderIsColumnAlias
Should be possible to limit number of rows with a new "Max Number of Rows" setting in Export Schema and Export Table
Add possibility to use ${dbvis-column-name}$ in BLOB/CLOB output paths to handle multiple columns of these types
File Chooser
File choosers should suggest last visited path based on context instead of sharing a single folder for all file choosers
Add recently used files/folders list in file selection field and file chooser window
Enable file system auto completion in file selection field
File chooser windows should have a drop-down list of last visited directories which is used to quickly navigate to a directory
File Chooser
SQL Commander
The Log to File button should have a drop down with last used files
General
Replace spinning red icon with a static one. Reason is that the animated GIF stops spinning suddenly and is too pixly and looks bad on HiDPI displays
Adjustments to large counters introduced JDBC 4.2
Grid Component
The "Describe Data" window should allow generating a CREATE TABLE DDL action
Installation/Update Installation
Remove the "-XX:MaxPermSize" Java property as it is deprecated with Java 8
Remove the "-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot" Java property
Key Bindings
Adding a keybinding for Merge Result Sets
Look and Feel
Allow changing look and feel at startup
Look and Feel: Darcula
Add support for the Darcula (dark) look and feel
OS Support: macOS
Change all visual references of 'Mac OS X' to 'macOS'
SQL Commander
Add new ${editorindex} to be used in Result Set tab labels
Add an option to name SQL Commander tabs as index only if there is no loaded file name
Consistency between Elapsed Time and Execution/Fetch time
Make filename in SQL editor status bar clickable with options to Copy Path and Open Parent Folder
Use setSchema() to set schema for execution to the selected schema
"@export set" commands are order dependant
Add a way to be able to use Java VM system properties and OS environment variables in DbVisualizer variables
Move the preprocessing settings (Parameterized SQL, Strip Comments, etc.) as connection properties
Add support to automatically merge generated result sets to text
SQL Commander
SQL Log
Improve the capability for writing the execution log to a file (@spool is now replaced with new "@log <filename> spool / clear"
SQL History
Increase the width of the quick filter field in the SQL History grid
SQL Log
Remove "Log to File" option in the SQL Commander and instead instruct users to save log after execution or using new @log commands
Make the log in the SQL Commander more interactive
SQL Log tab entries for @ commands could show more information for the command
Should be possible to configure the time format for SQL log entries
Table Data Editor
Should be possible to copy (Ctrl+C, Cmd+C) the rows displayed in the XML viewer to clipboard
Tool Properties
Change the "Rest of UI" font setting to "Font Scale for Rest of UI"
Workspace
Make split pane dividers visible and visually resize content while dragged