To choose your programming interface

1. Choose your target platform(s). UltraLite supports Palm OS, Windows Mobile, Windows XP/embedded Windows XP, and Java OS.

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

   Use this support matrix to help you quickly identify your development options.

   Deployment targets	UltraLite for C/C++ and embedded SQL	UltraLite.NET1	UltraLite for M-Business Anywhere2
   Palm OS	version 4 +	N/A	version 5.0 +
   Windows Mobile	CE 5.0 +	CE 5.0 with .NET compact framework 2.0	version 3.0 +
   Embedded Windows XP	Supported	.NET framework 2.0	version 5.0 +
   Java	Java SE (1.5 and later) RIM BlackBerry OS (4.1 and later)	N/A	N/A

   ¹ Development as an extension to Microsoft Visual Studio.NET. The driver supports ADO.NET versions 2.0.

   ² For browser-based deployments of UltraLite programming in JavaScript.

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

   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 databases are available. 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.

   Tip

   Even though a common interface exists, good development practice dictates that you create an abstract data-access layer when writing your application.

   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 has yields a different result in terms performance. For example UltraLite.NET might not perform as well as UltraLite C++, and UltraLite embedded SQL might even perform better than UltraLite C++.