Bay Breeze Software Released SQL Edge 3.1

SQL Edge is a universal SQL query tool that allows users to execute SQL queries, browse schema information in ER diagrams, and visualize data relationships. 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 details.

SQL Edge has six perspectives. The "Query Perspective" allows users to run any SQL queries and scripts. It supports Oracle PL/SQL, PostgreSQL PL/pgSQL, DB2, MySQL, SQL Anywhere Watcom SQL and Transact-SQL scripts. The "Schema Perspective" displays database schema information.

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 "Model Perspective" displays tables and their relationships in ER diagrams. It supports auto-layout, outline view, rulers, grid, and multi-page print preview.

The "Execution Plan Perspective" displays the execution plan of a query. It supports Oracle and PostgreSQL execution plans.


The version 3.1 added following features:

1) Support multiple schemas for Oracle databases, and added schema nodes in the database explorer for databases supporting multiple schemas.

2) Allow users to define filters in the database explorer to control what schema objects should be displayed.

3) Implemented "Add Related Tables to Diagram" menu option to allow users to add a table and all its related tables to a ER diagram.

4) Support exporting ER diagrams to GIF, SVG and PNG files besides JPEG files.


The following are the version 3.0 features:

1) Support Oracle, DB2, Microsoft SQL Server, MySQL, PostgreSQL, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise, and any JDBC compatible databases.

2) Support Windows, Linux and Mac OS X operating systems.

3) Provide wizards to help setup JDBC connections. Easy to install, and easy to setup.

4) SQL editor executes SQL queries asynchronously. Users can cancel the execution by click the "Cancel" button or simply close the editor.

5) Supports Oracle PL/SQL, PostgreSQL PL/pgSQL, DB2, Sybase, MySQL and Transact-SQL scripts.

6) Supports editable query result window. The data grid of the query result window is editable if all selected columns are from one table and also include the primary key of the table.

7) Schema perspective displays the table schema information, including column definitions, primary key, indexes, and foreign keys. It also displays the script information of views, sequences, stored procedures, triggers and packages for Oracle, DB2, Microsoft SQL Server, PostgreSQL, Sybase and MySQL databases based on whether the database supports these objects.

8) Relationship table view displays the related data in the master-detail style.

9) 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.

10) Allow users to insert, edit, and delete records in the data grids of the relationship views.

11) Allow users to define master-detail relationships even between tables in different databases. This enables the relationship views to display data relationships between tables in different databases or without pre-defined foreign keys.

12) Model perspective displays tables and their relationships in ER diagrams. It supports auto-layout, outline view, rulers, grid, and multi-page print preview. It also allows users to customize fonts and colors of diagram objects. The diagram can be saved in an XML file and shared between different users, or exported to JPEG files.

13) Execution plan perspective displays the execution plan of a query. It supports Oracle and PostgreSQL execution plans.