SQLite in Android

Related Examples
  • 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:

 

Download Link : http://code.google.com/p/droidexplorer/downloads/detail?name=sqlitebrowser_200_b1_win.zip&can=2&q=

 

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