UltraLite User's Guide
Developing UltraLite Applications
Introduction
When developing UltraLite applications, you will be working with the following tools.
A reference database A reference database is an Adaptive Server Anywhere database that serves as a model of the UltraLite database you want to create. You create this database yourself, using tools such as Sybase Central.
Your UltraLite database is a subset of the columns, tables, and indexes, in your reference database. The arrangement of tables and of the foreign key relationships between them is called the database schema.
In addition to modeling the UltraLite database, you need to add the SQL statements that are to be included in your UltraLite application to the reference database.
For more information, see Preparing a reference database.
A supported development tool You use a standard development tool to develop UltraLite applications. For the non-UltraLite specific portions of your application, such as the user interface, use your development tool in the usual way. For the UltraLite-specific data-access portions, you also need to use the UltraLite development tools.
It can be convenient to separate the data access code from the user interface and internal logic of your application.
For information on supported application development tools, see Supported platforms.
UltraLite development tools UltraLite includes several tools for development.
The UltraLite generator This application uses Java classes in the reference database to generate source code that implements the underlying query execution, data storage, and synchronization features of your application. The generator is required for all kinds of UltraLite development. The Java classes in the database are called the UltraLite Analyzer.
The SQL preprocessor This application is needed only if you are developing an UltraLite application using embedded SQL. It reads your embedded SQL source files and generates standard C/C++ files. As it scans the embedded SQL source files, it also stores information in the reference database that is used by the generator.
UltraLite runtime libraries UltraLite includes a runtime library for each target platform. On some platforms, this is a static library that becomes part of your application executable; on other platforms it is a dynamic link library. For Java, the runtime library is a jar file. UltraLite includes all the header files and import files needed to use the runtime libraries.