When you are dealing with slow connections, the biggest bottleneck is transferring a large volume of data all at once. There are some techniques that can be used to increase the performance involving server-side cursors.
Objective-C and C API Tutorial
OpenBase offers a C and Objective-C API for communicating with databases and retrieving results. This section describes the API calls that are common to both versions of the communications APIs.
PHP Module for OpenBase (documentation)
he OpenBase PHP interface was designed to mimic the OpenBase C API closely. However, because of the way PHP is often used we have changed some of the return values and have created new methods to accommodate PHP programmers.
OpenBase SQL APIs
APIs Include: Espresso C++ and Objective-C APIs, JDBC Driver, 4D Plugin, ActualODBC Driver, REALbasic Plugin, PHP5 Plugin, Ruby on Rails, Perl, Omnis Studio, WebObjects, Cold Fusion
Objective-C Stored Procedures
This section focuses on building OpenBase stored procedures in Objective-C using the OpenBase Espresso API. Example project code can be found in the OpenBase Developer download which will help you get started in building your own stored procedures in Objective-C or C.
Objective-C API Reference
This section focuses on the low-level OpenBase Objective-C interface through the OpenBase object. The OpenBase object provides the basis for all communication to OpenBase databases and is complementary to the Espresso interface which is built on top of it.
OpenISQL allows you to execute SQL from a terminal window. Clicking the Interactive SQL Terminal icon or selecting SQL Terminal from the Action menu or Action icon will launch the OpenISQL program and automatically connect it to the selected database.
Objective-C Espresso API
The Espresso API offers a superset of objects which can be combined with the OpenBase API to offer a higher level of access which insulates program logic from SQL. The Espresso API layer takes care of all the SQL, record locking, data encoding and all database access. It is an abstraction layer. At the same time, the Espresso API does not prevent you from writing your own SQL.