Change Log: 1.6.3

General

Sort Columns panel now has Up and Down buttons as an alternative to using drag and drop. See Figure 1.

Removal of most elements no longer shows a Delete Confirmation message box since the removal of these elements is undo-able.

Renaming a schema by double clicking on it's tree node resulted in it's schema objects being lost. This is now fixed.

If the database design does not use sequences or procedures the folder nodes of these items can be hidden. Select this option in the Database Explorer section of Preferences.

Figure 1. Column Sort Buttons.

General GUI

Database Explorer tracks which nodes were expanded prior to exiting and re-expands them the next time DbWrench is started.

DbWrench tracks which editors and diagrams were open when it was closed and only re-opens those editors and diagrams the next time it is started.

Undo/Redo toolbar is no longer embedded within the File toolbar. It is now it's own distinct toolbar.

Undo/Redo can be performed using Ctrl+Z and Ctrl-Y respectively.

Editor tabs can be closed using Ctrl-W.

The DbWrench Log window shows up in front of the Forward Engineer Log window by default.

Database Properties panel now has an Update button which can be used to make sure that edits are applied. See Figure 2.

Trigger Edit panel incorrectly displayed in a pop-up dialog, now it displays properly as a tabbed editor.

New mnemonic keys to navigate Table Details panel's tabs. See the View menu.

Figure 2. Database Properties Update Button.

Diagrams

DbWrench now supports Notes in diagrams. See Figure 3.

DbWrench now supports Zones in diagrams allowing for more visual grouping of tables. See Figure 4.

The Delete key can be used to remove foreign keys directly from diagrams.

Diagram glyphs have gradient backgrounds now.

The highlight border for selected table glyphs and foreign key links is thicker and brighter making it easier to see which diagram items are selected.

When diagram glyphs are being dragged to a new location the mouse cursor displays a proper Move cursor.

Auto-layout of tables on a diagram has been improved to make the layout more balanced with fewer large empty areas.

Link corners drawn on Key to Key link strategy diagrams are now rounded making it easier to see the direction of link when several links overlap or cross over. See Figure 5.

Ctrl++ and Ctrl-- can now be used to zoom in and zoom out diagrams, respectively.

Figure 3. Diagram Notes.	Figure 4. Diagram Zones.	Figure 5. Rounded Link Corners.

Reverse Engineering

Errors were generated if PostgreSQL table names contained 'pg_' somewhere other then the start. This is now fixed.

Cosmetic and layout improvements to Reverse Engineer panel.

Forward Engineering

Enclosing mixed case entity names in double quotes for PostgreSQL are now supported. Ensure this option is selected in Preference's PostgreSQL options. See Figure 6.

Script Explorer tracks which nodes were expanded prior to script recalculation and re-expands them after the calculation.

Figure 6

Table Data Viewer

SQL Editors

Layout improvements to SQL Results panel.

Database Documentation

'DbWrench' is removed from the header in HTML docs. Now it's displayed in the 'Documentations Created...' line.

Cosmetic and layout improvements to Database Documentation panel.