Cell Viewer/Editor
Add options to format/unformat JSON in the cell editor
Chart
Resizing Charts on export distorts geometry
Add more color schemes for charts
Command Line Support (dbviscmd)
dbviscmd should prompt for variables in connection details and variables used in scripts
The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)
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: DB2 LUW
Add user and role information for DB2 LUW
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
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
Data tab
Add capability to set a key binding for the generic "Stop" action
Option to prevent any filter from being used when loading a table during its first display
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
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
Database Objects Tree
Database Profile: Commands
For DB2 LUW and using the Generic profile, there is a (null) catalog node in the Databases tab
Driver Manager
Update bundled JDBC drivers
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", "bottom"
The Open as Spreadsheet action should put the SQL in a separate sheet
Rename "XLS" output format to "Excel" and accept "XLS" or "XLSX" (default) in the "ExcelFileFormat" parameter in @export
Add "Auto Resize Columns" for Excel 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
Favorites
Opening a favorite object for a database connection that fail to establish give no visible feedback that there is a problem
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 a filtering/search capability to locate an existing key binding and filtering
See the
discussion here
References
Selected table nodes in the references graph should not change background color
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 new "Set Modified State when Scripting" setting in Tools->Tool Properties under General / 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 (as a result of for example filtering) does not refresh the Catalog/Schema drop-down lists
SQL Editor
Offer GUI help for regular Expression replacement text (similar to the helper for the Find text)
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
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
SQL Log
Allow configuring what columns and order should be displayed in the SQL Log tab for SQL Commanders
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
Tool Properties
Allow user to edit the sample text when choosing fonts
Auto Completion
Having Fully Qualify Objects for Auto Completion and then AC a table name, database.null.table is inserted
Chart
When exporting graph the width and height does not always honor the selected orientation
Connection Setup
Copying driver property name copies the wrong name if entries are filtered
DB Support: DB2 LUW
SQL Commander
Stopped query leaves locks on SYSIBM tables
DB Support: H2
DDL Tab for Table with Identity columns are not generated correctly when H2 1.4.199 is used
DB Support: PostgreSQL
For some PostgreSQL installations the pg_catalog.pg_database is empty resulting in no databases being displayed in the databases tab
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"
Database Profile: Actions
Main windows locks when shutting down action dialogs in the wrong order
Explain Plan
Performance/Stability
Show confirm dialog when executing explain plan with multiple statements
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
OS Support: Linux
Application icons on Linux are blurry when placed on desktop, and present in the application (task) switcher
Procedure Editor
SQL Editor
The line break style (CRLF or LF) should be retained when editing an existing file or database code object
Query Builder
Conditions tab tree row heights are too small when loading a query in the query builder
References
Remove link "handles" in the references graph that are visible on self referencing tables
SQL Commander
Find and Replace with regular expression does not work
Some ${dbvis-xxx}$ variables are not case sensitive
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
When applying the SQL formatter the schema name in some situations may be preceded by blanks
UNLOGGED keyword with create table statement breaks formatting
Script Table as INSERT adds the schema in uppercase when SQL formatted
Having comments in a WITH clause breaks the SQL formatting
Format with string literals longer than max Line Width results in invalid SQL
Scripts
If focus not in the Scripts tab, renaming a file using right-click immediately cancels the editing