The methods outlined here provide some powerful techniques for storing and manipulating data, but providing a structured database this way would be a tiresome task. Fortunately Android incorporates SQLite (version 3 to be precise), a server-less, transactional database engine for this purpose. Instruction in SQL is beyond the scope of this book and it is assumed that the reader has some familiarity with self-contained databases, cursors, and queries.
In this recipe we will demonstrate how to set up a simple SQLiteDatabase, add a table and include some entries.
SQLite databases can be created and accessed through Java code, so to begin this task start up a new Android project with Eclipse and open the main Java activity file.