OpenBase SQL 10 enhancements:

Bundled OpenBase Forms, Wizard and Designer

OpenBase Forms offers instant gratification for users who want to build fully functional database interfaces quickly. The OpenBase Forms source is provided so you can extend any Cocoa application with powerful input forms that connect to OpenBase SQL databases. Form Designer is included with all commercial versions of OpenBase SQL.

New Interfaces

OpenBase SQL 10 offers a variety of new and updated APIs, including PHP v5, AppleScript API, Automator actions, WebObjects plugin, Java 1.5 JDBC Driver, REALBasic Connectivity Module, Universal Binary Omnis DAM, Universal Binary Cocoa Frameworks and Universal Binary C & C++ Libraries.

Stored Procedure Languages

OpenBase SQL 10 supports OpenScript 3.0, REALbasic, F-Script, Objective-C and Java.

Enhanced Performance & Memory Usage

OpenBase 10 offers huge performance gains and leaner memory usage when evaluating large sub-queries. Subqueries in OpenBase 10 have been known to run 200 times faster.

Stored Procedures as Subqueries

With OpenBase SQL, stored procedures can be used in subqueries. This allows queries to incorporate outside services and business logic during evaluation. (available in.1)

Insert Subquery

Subqueries, including stored procedure calls, can be used to insert data directly into a database using standard SQL syntax. This provides flexibility and convenience when moving data between data sources.

New Join Syntax

Standard SQL join syntax using INNER JOIN, OUTER JOIN or LEFT JOIN are now supported. This offers compatibility with applications such as Crystal Reports.

TABLE.* syntax supported

TABLE.* allows you to return all columns from a single table when performing a multi-table join.

VIEWs re-implemented

OpenBase 10 views offer dynamically updated virtual tables containing their own indexes and derived columns, offering enhanced performance and better organization.

Server-side variables

Server-side variables are thread-safe and allow multiple database clients to coordinate actions, increment primary key values and store values centrally.

Temporary Tables

OpenBase supports temporary tables that are private to the user who creates them. This allows applications to store connection specific information in a temporary table. Temporary tables are automatically removed when the user who creates them disconnects.

Enhanced Security

OpenBase SQL has undergone a security audit that has lead to security improvements in OpenBase.

Built on these advanced OpenBase SQL features:

Bonjour Support

Automatic server discovery provides seamless and immediate access to network OpenBase servers with minimal configuration.

Zero-Configuration for NAT/firewall Access

Just open the ports on your firewall, there is nothing else you need to do to get access to your OpenBase servers when using Network Address Translation. New auto-configuration capabilities built into the networking layer provides automatic and transparent access.

OpenBase Manager Forms Integration

OpenBase Manager provides an OpenBase Forms menu for convenient access to your personalized database input forms.

Subquery JDBC Databases: Oracle, Sybase, etc.

JDBC-compliant databases can now be used as a data source while evaluating OpenBase SQL queries. This allows OpenBase based systems to integrate easily with legacy systems.

Application Alarms

These SQL commands make it easy for application designers to define conditions that trigger the OpenBase Manager alarm system to alert administrators of error conditions. Events can also be logged and displayed to system administrators.

Powerful Management

This complete rewrite of OpenBase Manager tools delivers a slick iTunes look-and-feel and significant new database management capabilities, including: in-line database status progress bars; drag-n-drop database groups; detachable database monitoring windows; color-coded databases; expanded views of database descriptions and sizes; log files showing error severity and alarms; and new action buttons and contextual menus, for easy access to all database functions.

Stored Procedure Scheduling

Perform routine functions and processes automatically, using the built-in OpenBase stored procedure scheduling system and more flexible options for triggering stored procedures. The new stored procedure scheduling system uses a simple graphical interface to speed configuration. Now its easy to schedule backups, cleanups, or your own stored business logic to run on daily or weekly basis, or whenever a specific database event occurs, such as at startup or shutdown.

EOModel Schema Synchronization

WebObjects projects rely on the EOModeler application for modeling data, but synchronizing these changes with the database schema can often be problematic. With OpenBase, developers can synchronize their EOModel changes directly with the database using the OpenBase Manager.

Schema Modification Recorder

OpenBase SQL also makes it easy to keep track of all schema changes made to your development database, so you can quickly upgrade your production system. Unlike methods that compare schemas and try to reconcile differences, this approach is even able to track the renaming of tables and columns in the exact order they were performed. The result is that your production data is preserved with fewer problems when deploying updates to your schema and software.

SQL GUI Application

OpenBase SQL comes with a SQL GUI application, providing a simpler, more productive interface to openisql. The SQL GUI offers named queries, templates, and quick access to stored procedures.

Relocatable Databases

OpenBase SQL databases are now relocatable and the default location has been changed to /Users/Shared, a common place that is backed up when computers are serviced. Furthermore, databases can now be easily relocated to an external RAID or hard drive. The result is more flexibility and safety.