Choosing an UltraLite programming interface

UltraLite APIs offer different data access models, including a simple table-based data access interface and dynamic SQL for more complex queries. By combining these benefits, UltraLite gives application developers a flexible architecture for the creation of applications for your varied deployment environments.

 To choose your programming interface
  1. Choose your target platform(s).

    For each platform you need to support, determine if the API supports that platform. Different APIs support different platforms. If you are doing cross-platform development, choose an API that supports all of your intended targets.

    The support matrix found here: [external link] http://www.sybase.com/detail?id=1061806, can be used to identify your development options.

  2. Consider the effects of the following requirements, and then finalize your selection:

    SQL Anywhere compatibility   If database compatibility with SQL Anywhere is a concern, consider the following:

    • SQL Anywhere embedded SQL support provides a common programming interface for UltraLite and SQL Anywhere databases.

    • ADO.NET provides common programming models that are shared between UltraLite components and SQL Anywhere.

    Maintaining a common interface may be particularly useful on platforms such as Windows Mobile, where both SQL ANywhere and UltraLite databases are supported. If you need to move from UltraLite to a SQL Anywhere database, you should use embedded SQL or ADO.NET to make application migration easier.

    Simplified deployments   If simplifying your UltraLite deployment is an issue, consider programming with the M-Business Anywhere API. Your end-users can download both the UltraLite application and the database concurrently.

    Application size   If creating the smallest application footprint is a priority, you should program your application with the C/C++ API. These applications typically yield the best performance and still maintain a small application file size.

    Application performance   Each API yields a different performance result. While UltraLite provides high performance in a variety of environments and use cases, embedded SQL and the C++ API are the lowest level of APIs and generally deliver the highest performance.

 See also