The SQL storage API allows developers to create applications that store and query large sets of structured data in a client-side database, for both online and offline usage. Developers can create applications that utilize SQL for data mining, searching, sorting, etc. Databases can be shared between applications installed within the same Pega Mobile Client. In order to prevent unauthorized access to locally stored data, the storage is encrypted using the user's credentials and the 256-bit AES algorithm.
The API presented below is based on the Web SQL Database specification. It uses a simplified SQLite implementation that does not support the primary or foreign key.
Pega Mobile Client only supports asynchronous access to client-side databases.
The Encrypted SQL feature is supported on Android and iOS devices only.
This API does not support handling of multiple connections to the same database. The behavior is undefined in such a case.