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

For more on SQL itself, check out this article. SQLite is an implementation of a relational database, specifically aimed for embedded scenarios. It’s ideal for the likes of an Android app.

The tutorial has two parts: Part one introduces the example app, and how to use a content provider with a local SQLite database. Part two covers data synchronisation.