Latest News

 

1:st of September 2012 new version of Sui available (0.67E)

Important note: The new version is currently only available in the Jar-file format. Not in the pre-packaged exe or MSI file format. If you want to install Sui using the exe file, download setup.exe and perform the installation. After the installation download Sui.jar from http://www.sui.nu/Sui.jar and replace the jar file on your installation directory with the downloaded file.  If you have an existing Sui version download the Sui.jar and replace the downloaded file with your existing Sui.jar file,

In Sui 0.67 a number of new features are introduced. This includes SQL-Meta data Code completion, Copy data from one result-set in one database connection to a table in another database connection, Save data (including creation of a new table) from one database connection to a private Apache Derby database,

 

New Features

 

-      Four different type of code completion is available

o   Introduced possibility for Shorthand completion (F1)  (Including SQL Keywords)

o   Introduced possibility for Schema completion(F2)

o   Introduced possibility for table completion(F3)

o   Introduced possibility for column completion(F4)               

 

-      Added profiles for connection parameters (right click in Connection pane).      

-      Save data to Apache Derby (Makes it possible to a save A result-set direct to an Apache Derby database) (Requires Derby to be installed).

-      Append Query result-set to an existing tables

-      Create standard DDL for creating a table based on a result set

 

Minor changes and bug-fixes

 

-      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 in report window 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 spreadsheet

-      Added Auto-size for Excel spreadsheet

-      Added direct jump to Query-box-viewer by right-clicking the Query-box

-      Cleaned up some of the start-up messages.

-      Changed the way pass-words 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 query-box 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-errors now have a fuller error description

4: the of November 2011 minor version of Sui available (0.65F)

Important note: The new version is currently only available in the Jar-file format. Not in the pre-packaged exe or MSI file format. If you want to install Sui using the exe file, download setup.exe and perform the installation. After the installation download Sui.jar from http://www.sui.nu/Sui.jar and replace the jar file on your installation directory with the downloaded file.  If you have an existing Sui version download the Sui.jar and replace the downloaded file with your existing Sui.jar file,

A number of changes to the Querybox viewer

-      Font and font size in Querybox viewer inherited from query window

-      Text on buttons in query box viewer changed

-      Cursor in SQL Text always on top in Querybox viewer

-      Added search-next and search previous buttons in the Querybox viewer

-      Added the possibility to copy query text from the Querybox viewer to query window

 

Some changes to the MS-Access Plugin

-      Fixed a bug relating to export of decimals in the Access export function (jackcess plugin)

-      Compiled the MS-access interface with jackcess v1.2.3 (MS-Access is a plugin)

-      MS-Access export now uses the maxrows

 

Some other changes

-      Initial blank in the csv export file removed

-      Position in the combo boxes when moving up and down in JDBC-Preference panel added

 

11: th of July 2011 new version of Sui available (0.65E)

 

JDBC preferences changes

   - New icons added

   - Possibility to added jar files to classpath available direct on JDBC preferences

   - Possibility to check if the driver is available in classpath added.

   - The user is prompted for values when adding a new URL from the sample URL's  

   - If no URL's available at start-up the users are prompted to start JDBC preferences

 

Some other changes

- New icons added in query window and report window

- Added possibility to change number of query sheets (Sui preferences require restart)

- Build insert statements function from result set added to Query report, this make it possible

  to hide rows and columns, filter rows and move columns and then build insert statement based

  on what you see in the result-set table.

- Some minor changes to the connection panel

- Added the possibility to close all query windows from query window and query monitor

- Fixed a bug relating to how null is handled when building insert stmts

- Fixed a small bug relating to how Drivers and Url are populated

 

15:th of October 2010 New version of Sui available (0.65D)

Sheets introduced to the query window. To make it easier to manage multiple set of queries sheets has been introduced to the query window. Each sheet can contain a separate set of queries that can be executed and managed individually

Other enhancements:

-      Adding URL’s from “Manage JDBC resources” now prompts the user for connection properties.

-      Changed so that MaxRows is ignored when Maxrows is set to 0

-      Possibility to disable / Enable syntax highlighting added,

-      Substitution variables are now kept between sessions

-      Size of the preference panel increased.

-      Content in preference panel re-structured

-      Possibility to re-execute a query from the Show SQL panel in the report panel added.

-      The show-SQL and query log now shows the SQL after symbolic resolution.

-      The maximum number of entries in the query monitor increased from 20 to 100

-      Function to import a specific Excel sheet for Excel Import added

-      User-id / Password is not supplied at login (connection to database) if user-id and password are empty strings

-      Variable substitution not active when BATCH=YES specified (Exec->Insert Stmts)

-      Removed initial blank line when exporting to CSV

-      Syntax Highlight automatically disabled when query text > 2000 bytes.

 

Bugs fixed:

-      Fixed a bug relating to copy and paste from the query context menu

-      Fixed a couple of minor bugs related to connection management

-      Fixed a bug in the application concept

-      Fixed a data type mapping to handle SMALLINT data type correctly for stored procedures

-      Fixed a bug so that the Query-box now is consistently populated

21:st of October 2008 New version of Sui available (0.64H)

Important note: The new version is currently only available in the Jar-file. Not in the pre-packaged exe file. If you want to install Sui using the exe file, download setup.exe and perform the installation. After the installation download Sui.jar from http://www.sui.nu/Sui.jar and replace the jar file on your installation directory with the downloaded file.

Improved installation and startup processes  

-      Storage of .pro files can now be customized to be stored under the users home directory

(Sui will store the .pro files under user.home /AppData/Sui if this folder exists)

 

-      If the user-id is set to ? (in the preferences), the user-id will be retrieved

from the java system property user.name. If the user-id is set to ?L (in the preferences),

the user-id will be retrieved from the java system property user.name and the user-id field

will be protected.

 

-      Connection properties are now stored in a separate property file (SuiConnProp.pro). This change make it easier to create a customized installation package, containing a pre-defined set of database connections. Sui automatically converts this from the old property SuiSys.pro to the new property.

 

-      Class-path definitions are now stored in a separate property fils (SuiCP.pro). This changes makes it easier to create a customized installation package, containing a pre-defined set of class path definitions. Sui automatically converts this from the old property SuiSys.pro to the new property.

 

New functions

-      Initial support for SQL-Syntax highlighting introduced

 

-      Two new functions to compare two rows or more rows in a result set from the report window introduced:

o   Select for transpose and Transpose selected, lets you select a number of rows to compare and then lets you transpose these rows (The transpose function change the orientation of a row, each column of the row is displayed as a row in a new query report)

o   Transpose on value, by right clicking a cell in a result-set and selecting transpose on value, all rows with the same value in the selected column will be transposed in a new report-window

 

Extended Export functionality

-      Generation of Insert statements now prompts you for target table schema and Target table name.

-      Possibility to distinguish between "save query" and "Export data folder" added

 

Import functionality

-      Native Excel import support introduced

 

 A number of user interface improvements

-      Added possibility to wrap or not wrap query text (Preference under File->preferences->Query)

-      Changed the query report so that odd and even row-numbers have different back ground colors

-      Length of the field Row number in query report increase, now caters for up to 999999 rows

-      Function to remove initial line number added (this is ideal if you copy a query from a tool where each

-      row starts with a line-number)   

-      Possible to set default size at startup as a preference

-      Content of Query window is saved and restored between sessions 

-      Export to XLS from report-window now Exports directly to Excel

-      Added possibility to list java system properties (Options->Java properties)

-      Added some new fields to the connection details (Options->Connection details)

                                  

Improvement to stored procedure support

-      Added support for additional data types (for example DECIMAL, CLOB an BLOB)

-      Draw Stored procedures better supports Sp's with a mix of in, out and INOUT parameters

 

Bugs-fixed

-      Fixed a bug in the column information, this function now returns correct max and min values

-      Fixed a bug relating to non numeric MaxRows (exception at startup)

10:th of December 2006 minor-version of Sui available (0.64D)

- Row-Filter improved to support more data types

- A couple of icons changed in the query pop-up

3:rd of December 2006 New version of Sui available (0.64C)

Draw query builder improvements

-      Group by functionality added 

-      Possibility to reset/set all selected columns                

 

Extended Export functionality

-      Generation of Insert statements based on a query introduced

-      Export to Microsoft Access introduced as a plugin

 

A number of user interface improvements

-      Font size changed for static text in query-window

-      A number of icons changed

-      Icons added to favorite query pop-up

-      Toolbars re-structured.

-      Exec to Excel added to toolbar

-      Icons added to query window pop-up

-      Icons added to favorite toolbar pop-up

-      Changed initial size of Sui at startup

 

Other changes          

-      FormatSQL Improved

-      Export to CSV and Export to Excel (from query window) writes the files to the specified data-directory rather then the installation directory

-      Confirmation dialogue added when attempting to save a query to an existing File

-      Additional data-types added to the filter function.

-      OK buttons added to JDBC preferences and Sui properties

 

Bugs-fixed

-      Parameter values (substitution) are now kept within the session

-      Cursor position in query kept after execution

-      A couple of bugs related to Find and replace fixed

-      Error messages if connection fails more consistent

-      Fixed so that Sui finds resources in the jar file, even if the Jar file

-      dont exists in the current direcotory (as long as the jar file exists in

-      the classpath).

 

6:th of March 2005

New version of Sui available (0.63B)

 

-      Continued Improvements of Excel interface

-      A specific sheet with meta data is automatically created for the exported result set (continuing SQL-statement, Connection information etc)

-      Export to Excel from the Query window and from the report window is now functionally aligned.

-      First version of Query builder introduced

-      The query builder lets you build simple SQL-queries by adding selection and order by criteria.

-       

29:th of February 2004 New version of Sui available (0.61B)

Version 0.61 is very much focused on an improved interface to Microsoft Excel (and other tools that can access files in XLS format).  It also includes a number of other usability improvements.

 

·         Query and Excel improvements

-      Support for exporting data to an XLS format file from the report window added.

-      Context menu added on the query window (right click on the query window)

-      Support for “batch” execution of queries added. This type of queries are writing the result of the query directly to a file rather then presenting the result in the query window. The file type can be CSV or XLS. These types of queries are invoked from the query context menu.

-      Automatic launch of Excel (or another program that understands XLS files) when the batch execution to a XLS file is completed (controlled by the new preferences under the export preferences tab).

 

·         Misc changes

-      Query window user interface improved. The message area removed from the query window (all messages displayed as pop-ups).

-      Support for “scrolling” on detailed level added (List Row and F7 / F8 to scroll down and up in the result-set on a detailed level).

-      Preferences redesigned to a tabbed panel.

-      Support for adding class paths dynamically added (Sui preferences-> Class path)

-      Sui’s launcher program improved. You are now able to change the ini file using a GUI.

15:th of December 2003, New version of Sui available (0.60B)

 

Application concept re-introduced. (The application concept will be further used and documented in later versions).

3:rd of October 2003

 

New version of Sui available (0.59C)

Version 0.59 became a more extensive version then planned. The major new functionality feature is the introduction of support for stored procedures (callable statements). It also contains enhancements to the filter function improved printing support and a number of minor usability changes.

 

Sui 0.59C change list:

·          

·         SP Support

-      Draw-Sp function (Enter SP and build a call statement using the escape syntax)

-      Support for execution of a SP from the procedure list

-      The user is prompted for SP Input-variables (IN and IN/OUT) using symbolic variable resolution (automatically drawn)

-      Output-variables  (OUT/IN-OUT) presented as a report window with two columns; variable name + value

-      Results-sets from SP’s are presented in a report-window (one for each result set)

-      Note: There are still a number of limitations to the SP support. It only supports SP’s with Character, Varchar, Integer, Smallint, Bigint, Tinyint, date, time and timestamp parameters.

 

Filter support

-      IN and NOT IN operator added (values separated by comma)

-      IS NULL and IS NOT NULL operator added

-      Character or Varchar fields with a length up to 500 bytes can be filtered

 

Misc. changes

-      Default CSV delimiter character changed from semi colon to comma (“;” -> “,”)

-      The maximum number of favorite queries extended from 10 to 35.

-      Null value are changed from “?” to null string (“?”->””) in the exported CSV file

-      Error message is now displayed in pop-ups rather then in query window

-      Confirmations dialogues added when replacing and deleting existing favorites

-      Setting of java path explained in documentation and described in error messages

-      The content of the Query list-box is changed. When a subset of a query is executed the executed SQL rather then the entire content of the query-window is added.

 

Solved bugs

-      The parsing of SQL statements is rewritten. This solves the problem with statement delimiters (normally semi colon) enclosed by quotation marks

-      The Look and feel property is kept between sessions

-      The draw function now fully supports table names with catalogue, schema and table name.

-      Naming conventions for SuiSys.pro changed to conform with Linux and Unix

-      Bug in save query resolved

-      Favorite queries saved to disk when changed rather when exiting Sui.

21:st of November 2002

New version of Sui available (0.58B)

Sui 0.58 is a major version. We have added one new major feature, favorite query toolbar. We have also made significant improvements to the list table function and to the query report filter function. We have also made a number of changes to make the user interface and the documentation more consistent.

 

Sui 0.58B change list:

 

Favorite query toolbar added

·         A new concept to manage queries added. This function lets you add your favorite queries to a toolbar (as a toolbar icon). From the toolbar the user can execute the query and also add a description to the query.

 

Significant improvements to the filter function

·         Filter function supported for more data-types

·         More operators added for filtering (=, <>, < ,>, Not Like, Between)

 

Improvements to list table and list procedure

·         Possible to filter tables based on table type

·         List table now works for the ODBC/JDBC drivers

·         Bug solved related to list table and lower case

·         Bug solved to make sure list table works for DBMS with a catalog as part of the table name

·         Catalog is not included in the filter panel for DBMS without a catalog as part the table name

·         New option to enable that all available schemas are displayed in a combo-box on the table / Procedure panel

·         List of Access to tables and list of referential integrity added to table listing panel

 

Changes to user documentation

·         The user guide is re-structured and we have changed it from html to pdf.

 

Misc. changes

·         Re-design of a number of icons.

·         The show-SQL panel (from the query window) changed to a scrollable panel

·         New option to make the column width more intelligent

·         The size of the report list are initially set wider

 

6:th of November 2002

New minor version of Sui available (0.57C)

Sui 0.57C change list:

·          

A number of bugs fixed

·         Filter function corrected to work correctly for filters without a % sign.

·         It's now possible to filter the second column of the connection details

·         Connection properties is now written to file when the apply button is pressed (rather then when application is closed)

 

Minor changes

·         URL added to report window title

·         URL added to query monitor

·         Max row field is validated for numeric content.

·         User-id and password is remembered during a session. If a user tries to connect to the same URL as before (during the same session) the user-id and password from the previous connect is automatically entered in the user-id and password field (happens when focus is moved from the URL-Box).

30:th of October 2002

New version of Sui available (0.57)


Sui 0.57 change list:

 

Filter functionality added to the query report

·         Filtering a query makes it possible to reduce the number of rows in the report. The report is filtered by using wild-card characters. This version supports filtering for character fields (limited to fields with a length less then 250 bytes).

 

FormatSQL Improved 

·         The format SQL function is continued be improved. In this version support for Insert, Update and Delete SQL is added. Support for more complex SQL SELECT syntax is also added (Common table expressions for example). You can also format a subset of the SQL statement (select the SQL you want to format and press the formatSQL button)

·          

Support for changing Java " look and feel"

·         Select edit->preferences->Look and Feel to change the look and feel of the user interface.

 

Minor corrections

·         Pop-up menu placement bug solved

·         Possible to deselect variable substitution (Edit->Preferences)

·         Keep connection removed from the preference menu

·         The web-site now includes specific information for Oracle

 

28:th of August 2002

New version of Sui available (0.56)

 

Sui 0.56 includes new functionality for:

·         Change and replace of data in the query window added

·         A number of minor bugs fixed.

·         The web site now includes specific information for DB2,

11:th of November 2001

Changes to packaging and documentation

·         Sui changed from shareware to FREEWARE

·         Sui Windows installation improved. Under Windows Sui installation is done thru an installer software, supporting install and un-install of Sui

·         Sui documentation and web-site improved and extended

 

7:th of November 2001

New version of Sui available (0.55)

Sui 0.55 includes new functionality in the following areas:

·          

·         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.

15:th of September 2001

Initial Version available (0.54)

·         The first generally available version of Sui is announced.  www.sui.nu