Feature and Technical Overview

Local Navigation

SQLite

You can create an application that uses the SQLite® database library that is available on a BlackBerry® device. SQLite is an open source relational database library. BlackBerry devices that run BlackBerry® Device Software 5.0 or later include the SQLite library.

SQLite is designed to make efficient use of memory resources and includes only a small set of features. As a result, it can be a good choice for embedded and wireless applications. You should consider using the SQLite API if you want to store application data, and your application would benefit from the additional structure and manageability that a relational database can provide.

You can use the SQLite API, provided in the net.rim.device.api.database package, to store application data persistently to eMMC memory or a microSD card. The SQLite API provides the option to store data in an encrypted format using the same mechanisms as the Persistent Store APIs.

To download a sample application that demonstrates how to use the SQLite API, visit www.blackberry.com/go/sqlitedemo. For more information about SQLite, see the BlackBerry Java Application SQLite Development Guide and the API reference for the BlackBerry® Java® Development Environment.

Next topic: Connections

Was this information helpful? Send us your comments.