An SQL database is provided for use by all applications.
Trolltech Qtopia applications use the database for PIM data, Categories, and the Document Management system. Using an SQL database improves performance and flexibility of classes requiring permanent storage.
To integrate an alternative database engine, tasks include:
Providing a Qt SQL Driver (many already supported - see Qt documentation)
Creating schema and queries to compensate for any peculiarities of the database engine, if any.
Where an SQL database is used for storage in Qtopia, non-SQL based APIs are provided for application development. This avoids database implementation dependencies and provides faster development for commonly accessed data.
Features
SQLite Integration
Qtopia ships with the SQLite database engine. It is also possible to integrate other database engines.
Schema Migration
The following facilities are available for migrating to newer versions on a database schema update:
a version table that records all the release versions ever installed on the device
a script that runs at start-up, and is implemented in ensureSchema(), that looks at the version table and updates the database (finally adding a row to the version table)
