This software is a powerful database engine that uses SQL to manage, organize and manipulate large amounts of data. It is an efficient and effective tool for managing complex databases.
OpenBase SQL comes with user-friendly GUI administration tools that can be used to manage database schemas, edit table data, control databases over the internet, and manage database user accounts. Most client-server databases have adopted the SQL standard for its ability to reduce network communication requirements between applications and databases.
OpenBase SQL offers a variety of useful features such as bundled OpenBase Forms, Wizard and Designer, and new API's for 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.
In addition to the above-listed features, OpenBase SQL version 10 has several other critical features such as Stored Procedure Languages, which supports OpenScript 3.0, REALbasic, F-Script, Objective-C, and Java. It offers enhanced performance and leaner memory usage when evaluating large sub-queries. Performance gains have been known to run 200 times faster.
Stored procedures can be used in subqueries with OpenBase SQL. This allows queries to incorporate outside services and business logic during evaluation. Furthermore, subqueries, including stored procedure calls, can be used to insert data directly into a database using standard SQL syntax.
OpenBase SQL version 10 also supports new join syntax using INNER JOIN, OUTER JOIN, or LEFT JOIN, which offers compatibility with applications such as Crystal Reports. TABLE.* allows you to return all columns from a single table when performing a multi-table join, whereas the OpenBase 10 views offer dynamically updated virtual tables containing their indexes and derived columns, resulting in better performance and organization.
Server-side variables are thread-safe and allow multiple database clients to coordinate actions, increment primary key values, and store values centrally. OpenBase SQL supports temporary tables that are private to the user who creates them. This allows applications to store connection-specific information in a temporary table which is automatically removed when the user who creates them disconnects.
Finally, OpenBase SQL has undergone a security audit that has led to security improvements. Supported by a range of unique features, OpenBase SQL is an excellent choice for users looking for a reliable and easy-to-use database solution.
Version 11.0.0 Build 184: N/A