OpenBase SQL 11.0.0 Build 184

Powerful SQL database engine.
OpenBase SQL is designed to lower the total cost-of-ownership for business customers. It comes with built-in fault-tolerance and ease-of-use, so you can concentrate on your your business tasks, instead of worrying about the databas

OpenBase SQL database engine is a powerful tool that provides high-performance data storage and retrieval for demanding multi-user applications.

Easy-to-use GUI administration tools allow users to design database schemas, edit table data, manage database user accounts and even control databases from across the internet.

OpenBase SQL is a database server application that provides high-speed access to structured data. SQL stands for Structured Query Language and is the mechanism by which client applications are able to communicate requests to a server that manages the data for the client. Most client-server databases have adopted the SQL standard because it lowers the network communication requirements between applications and databases. But while SQL databases may have the SQL language in common, they can differ in important ways.

Main features of OpenBase SQL:

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


Requirements of OpenBase SQL:

RAM Requirements: 512 MB Minimum, 1GB Recommended.

Hard Disk: 150MB.


What's New in This Release:

Added Incremental Backups.

Always-on encryption.

Full implementation of Diffie-Hellman key exchange (http://en.wikipedia.org/wiki/Diffie-Hellman). Diffie-Hellman key exchange (D-H) is a cryptographic protocol that allows two parties that have no prior knowledge of each other to jointly establish a shared secret key over an insecure communications channel. Diffie-Hellman provides the basis for a variety of authenticated protocols (SSL, ssh, etc), and is used to provide perfect forward secrecy in Transport Layer Security's ephemeral modes.

Changed the Diagnostic Mode in the Database Configuration panel to place the SQL logs in a subdirectory of Databases called DiagnosticSQL.

Added "tar_enabled" flag file to be placed inside the DiagnosticSQL directory when you want OpenBase to make a tar copy of databases while starting.

Added ability to disable Bonjour by placing a "disable_bonjour" file in /Library/OpenBase/Config.

Fixes to installation and OpenBaseSetup application.

Expansion of OpenDirectory/LDAP support to authenticate against several LDAP paths.

Fix to OpenBase Syncronization.

Deprecated automatic compressed backups. They can still be enabled manually.

OpenScript: Correctly returns Dictionaries and Arrays, in addition to record sets and strings.

Java Stored Procedures: A new java_path file in /Library/OpenBase/Config now points OpenBase processes to the correct path to the Java executable.

New installation offering a better installation experience.

Server-side deadlock problem fixed.

Problem fixed related to REPLACE INTO and the use of derived columns as keys. This now works correctly.

New OpenBase Manager Data Viewer with enhanced sorting and history.

Updated OpenBase Forms, Wizard and Designer for Leopard.

New Functions:

PDFAttribute(comment, section, attribute) allows you to extract values from a PDF during a select or use values from a PDF blob for a derived column. PDFAttribute can be called either within an SQL statement or separately using a function call.

New Stored Procedures:

PDFExtractValue(blobid, section) procedure extracts data from a PDF document.

New APIs Available Now:

Objective-C frameworks support Diffie-Hellman and new encryption.

NEW REALbasic module (requires module#69+) supports Diffie-Hellman and new encryption.

PHP Module - supports Diffie-Hellman and new encryption.

XML / JSON - supports connectivity to data via HTTP calls.