This demo code is taken from Lars Voglel's tutorial on SQLite and slightly modified to include the delate all option.

Simple use of the camera databasedemo.zip.

The demo code used in this lecture include:

The SQLite layer: finally the SQLiteOpenHelper plumbing exposed!.

The data storage layer: CommentsDataSource.Performance issues: CursorLoader and asynchronously to cursor data.We will also tie databases to Content Providers - another important tool in the Android toolbox. I love abstraction - it's a powerful idea and allows you to hide the unnecessary details from the app designer. Abstraction is heavily leverage in use of SQLite on mobiles such as Android.

I have tried to describe the software architecture around three layers: the app layer, data storage layer, and the SQLite layer. If you've not used SQLite (an industry standard and great for mobiles) before then this should be cool. We will relate this simple example to the SQLite database you need to design and implement as part of MyRuns3. In this lecture, we will discuss how to use Android SQLite database through a simple demo project example. Android supports the very simple and very cool SQLite. Structured or relational data such as your list of contacts is best stored and managed using relational databases.

Unstructured data such as a jpeg file or html page is best stored in files. There are many ways to handle data on mobile devices.

Sqlitedatabase query