|Bay Breeze Software Released SQL Edge 1.2 [message #561030]
||Wed, 28 September 2005 01:10
Originally posted by: sales.baybreezesoft.com|
SQL Edge is an Eclipse Rich Client application that allows users to
execute SQL queries, browse schema information, and visualize data
With SQL Edge, users can use only one query to retrieve data in a master
table, and then browse data in all related detail tables. Users can also
insert, edit, and delete table records in the data grids. Please refer to
http://www.baybreezesoft.com for product detail.
SQL Edge has four perspectives. The "Query Perspective" allows users run
any SQL queries, while the "Schema Perspective" displays table schema
There are two relationship perspectives. The "Relationship Table View"
displays data in the master-detail style. The "Relationship Tree View"
displays master table records as top-level tree nodes. The nodes can be
expanded to reveal any level of related detail records. In addition,
clicking any node will display the corresponding data in a detail grid.
The version 1.2 added following features:
(1) Allow users to insert, edit, and delete records in the master and
detail grids of the relationship table view and relationship tree view.
(2) Allow users to define master-detail relationships even between tables
in different databases. This enables the relationship table view and
relationship tree view to display data relationships between tables in
different databases or without pre-defined foreign keys.
The version 1.1 features are:
(1) Support any JDBC compatible databases.
(2) Allow users to specify JDBC drivers at run-time, and provide wizards
to help setup JDBC connections. Easy to install, and easy to setup.
(3) SQL editor with syntax highlighting based on currently connected
(4) SQL edtior allows users to execute SQL queries asynchronously. Users
can cancel the execution by click the "Cancel" button or just close the
(5) Schema perspective displays the table schema information, including
column definitions, primary key, indexes, and foreign keys.
(6) Relationship table view displays the related data in the master-detail
style, with master table data shown in the top grid, and all related
detail table data in a list of bottom grids.
(7) Relationship tree view displays the master table records as top-level
tree nodes, and the related detail records as child nodes. Click any of
these tree nodes will display the corresponding record data in a detail