Learning Android™ Application Programming: A Hands-On Guide to Building Android Applications

Creating a Database

Android gives you a few options to persist data even after the application is terminated. One approach is to use text files stored in various areas of the phone, such as the files directory or the actual SD card. You could also use preferences to store the data, which are hidden from users and persist as long as the application is installed.

Sometimes, however, you need to perform more complex operations on this persistent data, or perhaps there is simply too much data to store in a text file or preference entry. For these occasions, Android supports SQLite, a self-contained, transactional, fast Structured Query Language (SQL) database engine with a small memory footprint that requires minimal configuration to set up and ...