SQLite in Android

• SQLite is an Open Source Database which is embedded into Android. SQLite is available on every Android device.
• SQLite require very less memory  at runtime (approx. 250 KByte).
• Enternally SQLite database creates filesystem so this may be slow, Therefore it is recommended to perform database operations inside the AsyncTask class.
• The package android.database contains all general classes for working with databases. android.database.sqlite contains the SQLite specific classes.
• If your application creates a database, this database is by default saved in the directory DATA/data/APP_NAME/databases/FILENAME.

How to see SQLite database inside Android

Download SQLite Browser:

• Open file sqlitebrowser_200_b1_win
• Please see this video for further details