Using SQLite Database with Android

By : balu - Where there's a will, there's a way.

Android embeds an Open Source Database called SQLite, which supports standard relational database features like SQL syntax, transactions and prepared statements. In addition it requires only little memory at runtime (approx. 250 KB). In this post I would like to show how to work with a simple pragmatic example : Baby Names App.

Before writing the code, let me show you some of the screen-shots of Baby Names App, which requires interaction with the database.

1. When ever you launch the App, it will shows a Menu of items as below.

2. When we click on the highlighted button - "Common Names", it will ...