Creating and using an SQLite database for data persistence in Android apps. Covers the basics, as well as using foreign keys. Full source included.

We dig into the different options available to store data locally on an android device, complete with sample source code.

The SQLite3 command line interface makes it incredibly easy to create databases, configure tables, delete records and even get status updates on the state of your SQLite database.