If any application wanted to share SQLite its data (e.g., contact list) with other applications running in your phone it would use Content Providers - content providers provide a uniform way to store, share and consume structured between applications but also within a single application (yes you set up an SQLite database and wrap it in a content provider to manage data).

The database access is restricted to the app that created it.

SQLiteOpenHelper a helper class to manage database creation and version management.Įvery Android app that wants to store structured data (e.g., contact information, march madness bracket) needs to create its own private database that the app creates and manages by itself.

Contains the SQLite database management classes that an application would use to manage its own private database.

Android SQLite Database and ContentProvider Tutorial.

Important: Make sure you read the course book section on (it has an example of using a background thread to query the database and another thread to write information to the database): 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.

Android sqlite tutorial