OpenBase SQL Features
OpenBase SQL 12 builds on a more than a decade of database innovation and uniquely advanced capabilities that businesses of all kinds rely on, including:
Now OpenBase SQL comes with powerful, easy-to-configure incremental backup services for all of the databases running on your database server. Like Apple's Time Machine, OpenBase SQL Incremental Backup services make it easy for you to rewind your database to any point in time. [more]
Now OpenBase SQL delivers always-on encryption for secure database access, from anywhere, anytime. OpenBase uses the Diffie-Hellman (D-H) key exchange cryptographic protocol, which allows communications to be established securely over an insecure public network. D-H key exchange provides the basis for a variety of authentication protocols, including SSL and SSH. OpenBase uses this same trusted protocol to provide secure access to data without having to configure a VPN.
OpenBase SQL 12 supports 64-bit Mac OS X 10.5+ systems for customers who manage large data sets and require greater resources than what 32-bit applications can access. 32-bit versions of OpenBase SQL 12 are also provided for Mac OS X 10.4 compatibility.
JSON & REST XML Server
The new JSON/XML Server provides access your OpenBase SQL databases via JSON and XML. Now it's easy to use a wide variety of reporting tools, Java clients, dashboard widgets, and other applications with OpenBase SQL--and to create new Objective-J, flex and iPhone applications on top of the OpenBase SQL database. [more]
A new diagnostic capability automatically collects timing statistics on queries so you can easily identify any performance bottlenecks--and address them.
OpenBase SQL 12 supports new and updated APIs, including PHP v5, AppleScript API, Automator actions, WebObjects plugin, Java 1.5 JDBC Driver, REALbasic Connectivity Module, Ruby on Rails adaptor, Universal Binary Omnis DAM, Universal Binary Cocoa Frameworks and Universal Binary C & C++ Libraries. All APIs support always-on encryption and other security features.
Optimized performance & memory usage
OpenBase SQL 12 delivers both: faster performance and leaner memory usage--with query performance and connection times as much as 3x faster than version 10!
Subqueries: INSERT INTO and REPLACE INTO
Now you can use subqueries, including stored procedure calls, to insert data directly into an OpenBase SQL database, using either INSERT INTO or REPLACE INTO syntax. This capability provides greater flexibility and convenience when moving data between data sources.
Enhanced Data Viewer Window
An all-new and improved OpenBase Manager Data Viewer provides better history navigation, selection, custom queries and sorting, so you can interact with your database data easier than ever before. [more]
Dynamic network configuration
OpenBase SQL 12 comes with automatic IP discovery, so OpenBase SQL database clients and servers automatically reconfigure themselves whenever networks and IP addresses change.
Enhanced stored procedures
OpenScript, the OpenBase stored procedure language used to write business logic, has been updated to support arrays, dictionaries and a variety of other powerful features.