A new
version of Sui is planned for late August 2012. This version is currently being
beta-tested. The new version, 0.67, contains a couple of new functions:
1.
Code
completion (SQL Syntax, Schema names, Table names and Column names)
2.
New
function to copy data between databases (append a result-set from a query to an
existing table in another connection)
3.
A
new function to save data (Create table and copy data) from a result-set of a query
to a “private” database table in Apache Derby.
4.
A
new function to build “Create table DDL” from an SQL query result-set.
The new version also contains improvements in
the following areas:
·
Excel
import now allows for import of insert statement to file (or as before to clip
board)
·
removed
limit of 200 columns for Transpose on value
·
Limited
field length to avoid overflow for very large columns
·
Moved
sui data path and look and feel settings to Misc
settings
·
Added
a file chooser with an icon to the data path selection
·
Changed
font to COURIER for Excel spreadshet
·
Added
Autosize for Excel spreadsheet
·
Added
direct jump to Queryboxviewe by righclicking
the querybox
·
Cleaned
up some of the start up messages.
·
Changed
the way password are remembered within a session.
·
Added
a property to make it possible to load all drivers at startup
·
Fixed
some issues with decimal values with large number of decimals
·
Fixed
a bug in querybox viewer search, The search function
didn't handle the first character correctly
·
For
users connecting to DB2 using the IBM's universal JDBC driver, SQL erorrs now have a fuller error description
No firm
decision has been taken about functions in future Sui versions. A number of new
functions are being evaluated. This includes:
·
A
Smarter way of searching for previously executed SQL statements. This could for
example be achieved by parsing the SQL statement and build a meta-data
structure containing information like connections, Table Names, SQL verbs,
String literals and numeric values. One option would be to 7build a meta-data
table structure stored in Apache-Derby. Based on this structure intelligent searches
could be performed.
·
One
of the things that still are not good in Sui is the way Connections (URL,
Drivers etc.) are added.
·
Create
a number of database specific extensions (separately packaged). This could for
example be functions for save data in a specific database (for example Save
data in DB2 or Oracle) in a similar way as the Exec->Derby.
·
Improve
the Excel Interface to allow Import and Export for XLSX files (in addition to
the support for XLS).
Sui 0.59C change list:
·
Change and replace of data in the query window added
·
A number of minor bugs fixed.
·
Query formatting: Sui now includes support for formatting SQL Select
queries. This is ideal for people working with SQL generated from tools and
from other users. The formatted SQL is very easy to read.
·
Confirm update. Before committing changes to the database Sui asks
the user to confirm the changes
·
Prompted queries. Sui now supports prompted queries. Sui asks the user
to fill in the values for all variables in the SQL starting with a &. Before the query is executed the variable is
replaced with the value entered by the user
·
Improved connection management. The logic
for managing connection is improved. From a user perspective full support for
executing parallel queries is implemented. Sui also reduces database lock
contention to a minimum.
·
Query window behaviour changed (Changed to grid-bag layout)
·
Resize of report-window font added
·
Print preview of report window added
·
Page setup added to report window
·
Print of report improved
·
Sample URL’s and JDBC
drivers to select from in Connection properties
· GIF files included
in Jar file
· Font size can
be changed from Sui preferences
· Connection
property panel added
· Icon added
for preferences and properties added
· A
number of bugs resolved
· Search
functionality added
· Column
functions added (sort, Hide, Column information)
· Icons on
toolbar for List Table, List IX, List PK, List Columns, Show SQL, Export to CSV
and List Row
· The
following buttons added to the toolbar List Column (properties), List Row, Copy
Row, Print, Export,
· Info in title
if report only contain a sub-set
· Row-Number as
first column
· Monitor list
populated in a consistent way (solved BUGG !!)
· Table grid
changed to Java Swing table (Sui is at last a pure Java Application J)
· Copy table
row to clip board added
· Toolbar added
to Report window
· The
following buttons added to the toolbar List Column (properties), List Row, Copy
Row, Print, Export,
· Resize not
allowed on list table and list procedure panels
· Monitor list
sorted
· Monitor list
populated in a consistent way (solved BUGG !!)
· Locking
behaviour changed to reduce lock contention
· Main Query
window changed to be able to be proportionally resized (including maximized)
· F3 and ESC
added as short paths to close report window
· F5 added as
shortcut to execute query
· Text removed
from toolbar selection
· Tip text
added to toolbar selections
· About
info panel added
· Icons for
Draw Query, List table and Query Monitor added to toolbar. Other icons resized.
Thanks to Rasmus Bengtsson
for helping me making the icons look better
· Draw query
available directly from query window
· Query report
status added from query report panel (Open or Closed)
· Query Start
time added to title on Query panel
· Query Monitor
option added to Query monitor panel (Options)
· Query Monitor
option added to Query panel (Options)
· Report panel
Indentation added from 10 to 20
· SQL Error
message added to the monitor display
· Catalogue added
as a list table criteria
· All available
catalogues added to a selectable non-editable combo-box (for DBMS not using Catalogs the field is set to null and not used in the
selection criteria).
· Logic for
execution of SQL changed. SUI now supports execution of all types of SQL
(Updating queries, Queries returning resultset and
DDL-type queries)
· Support for
SQL returning multiple result-set added (In some DBMS execution of Stored
procedures (returning multiple rs) can be done directly
from a query interface (in addition to through a prepared statement that is the
normal way (standard) of executing stored procedures). ((An example of such
DBMS is MS SQL Server where many of the system supplied stored procedures
returns multiple result-sets, sp_help [table] is a
typical example of such a SP)).
· Numeric
Suffix added to report header to distinguish between multiple result set
· Possibility
to execute only marked (highlighted) text as SQL added.
SUI.EXECUTEMARKEDSQLONLY keyword added to property file. The logic is : If EXECUTEMARKEDSQLONLY is set to Y and any text
is marked execute only the marked text as SQL. If no text is marked or
EXECUTEMARKEDSQLONLY is not set to Y execute all text as SQL.
· Comments can
now be included in the SQL statements. (SUI.COMMENTSTRING added). Default
comment string is --. If a comment string is found all text until the end of
line will be ignored.
· Support for
multiple SQL statements added. (SUI.ENDSQLSTM added). SUI will split the SQL
statement in multiple parts and execute them serially. The default end
delimiter for a SQL statement is ;
· List
procedure now has the same logic as list table (if TBFILTER = Y display a
filter panel before listing procedures).
· Print Query
added from main query panel
· More
consistent approach for displaying column types from report panel implemented
· Queries
executed as threads, enables queries to run as
background tasks (Multiple concurrent queries)
· Management of
messages changed to be able to manage threads
· Query monitor
added, Query monitor lists elapse time for executed queries and status for
executing queries. Selectable from option menu
· Audio alert
if query fails
· Message
issued on message-area when query submitted for execution
· Select all,
option added to edit menu
· Reset query,
added to edit menu
· Execution of
a blank query (Empty query window) will not be added to query list
· Maximum
number of concurrent queries limited to 10, a message will be issued if
attempting to run more then 10
· Query Report
panels indented to improve visibility of multiple report panels
· Labels
changed to JLABEL to enforce pull-down menus to overlay labels
· Bug in
SUI.TBFILTER fixed, If SUI.TBFILTER=N no panel will be displayed
· Reduced
storage usage for reports (QueryRep)
· Menues
and panel (not grid) on Query Report panel, converted to Java-Swing
· Fast-Paths
for menu choices on Report-Panel added
· SQL Converted
to uppercase only if SQLTOUCASE=Y
· Entries on
filter panel converted to upper case if SQLTOUCASE=Y
· Pop-up menues forced to be heavy-weight (Overlaying lightweight
objects).
· Connection
status added to title-bar
· “New Query
Window” added (re-added) from Query report
· Profile
variable SUI.CDELCHAR added (see also next bullet)
· String
delimiter character added for exported files (Default character is ‘ (single quoute))
· Special
variable &PRE added, &PRE variable is specific for each JDBC connection
· Row details
option removed from query report
· SQL converted
to Uppercase before execution (User still sees SQL in
the way it’s entered)
· List Table
Data added for selected table (Executes Select * from selected table) (From
Table Listing)
· List Table
Indexes for selected table added (From Table listing)
· Draw Query to
Clipboard for selected table added (Formata an SQL
Query with all columns for selected table and copies it to the clip board)
· List Primary
keys for selected table added (from table listing)
· List
procedures added from main panel
· List
Procedure columns added from Procedure list
· Filter panel
added for List table
· New variable
SUI.TBFILTER added, if set to N no filter panel will be displayed (default is
Yes)
· Additional
options menu added from Connection Details panel
· List Schemas
added from Connection Details > Additional Details panel
· Data Types
added from Connection Details > Additional Details panel
· Table Types
added from Connection Details > Additional Details panel
· A
large number of new fields have been added to the connection detail panel
· Fast path
keys added (ctrl-c for copy, ctrl-v paste, ctrl-x cut, ctrl-r run query, Alt-x
for exit)
· The last x executed queries stored and it is possible to
select them from a pull-down menu. Last Executed query is on top and duplicate
queries removed from list
· The
last 25 executed queries loaded from a property file when SUI is started
· The
last 25 executed queries saved on a property file when exiting
· Font size
changed from 10 to 12
· Width of list
Column and List Row reports increased
· It
is now possible to store multiple URL’s in the property file (System property
file syntax changed for keyword JDBCURL)
· Multiple
database URL’s can be selected from a drop-down box. Data taken from system
property file.
· SUI now fully
supports changing/Adding Database drivers after start-up
· It
is now possible to store multiple JDBC-Drivers in the property file (System
property file syntax changed for keyword JDBCDRIVER)
· Multiple ODBC
Drivers can be added from a drop-down box. Data taken from system property
file.
· Open file
dialog changed from JAVA-AWT layout to JAVA-SWING
· Default file
prefix QRY added on the open file dialog
· Save
file dialog changed from JAVA-AWT layout to JAVA-SWING
· Default file
prefix QRY added on the save file dialog
· File Suffix
.QRY added if no prefix given from Save query dialog
· More
informative Error messages from save and open files added
· Export to CSV
dialog changed from JAVA AWT to JAVA Swing
· Default
prefix .CSV added on Export to CSV dialog
· File suffix
.CSV added on export to CSV panel if no suffix given
· Bug solved to
avoid Null pointer assignment when starting withut
property file
· Format of
printed report improved
· Default
directory added to Property file and used for Save/Load Query and Export to CSV
· Add default
delimiter character, used for export to CSV (delimited files)
· Format of
Exported file improved
· SUI packaged
in a JAR file
· Simple
installation script added
· Right-justified
numeric values on print report
· Fixed layout
on print report if label longer then actual data
· Complete
re-design of query window
· JDBC-Driver,
URL, Userid, Pw and
Max-rows moved to query window
· Cut, Copy,
Paste added to menu under option Edit (also added)
· Connect to DB
button added
· Print and
export to CSV added
· Application
concept removed. (It will however re-appear in version 0.60 (and that’s a
promise))
· Row details
removed
· Database
driver added to connection details
· Application
concept added
The first
version contained the following functionality
· Edit of SQL
Query
· Execution of
query
· Open Query
(from file)
· Save Query
(from file)
· List Tables
· Change
connection option (Set URL + Max-rows)
· JDBC-Driver, Userid + PW passed to Sui as parameters
· List
connection details
· List Column
(from report)
· List row
(from report)
· Row Details
(from report)