Tips for Android developer: SQLite Database

Android provides the following four mechanisms for storing and retrieving data: Preferences, Files, Databases, and Network. When managing the data, Android developers need a way to store and retrieve the data. The best approach may be the structured data within the databases, and Android offers the SQLite relational database library.

After creating relational databases for Android applications SQLite, developers can use them to manage structured data, such as create, delete, update and etc.

Android databases are stored in the /data/data/[package_name]/databases folder on the device or emulator. For example, the Android SMS database is stored in:

/data/data/com.android.providers/telephony/databases/mmssms.db

You can use the sqlite3 command by “adb shell” to view the Android application’s databases.

Related Android Apps:

  1. Latest Release of Oracle® Berkeley DB Provides Support for Android Platform
  2. Tips for Android developer: install & uninstall Android applications
  3. Tips for Android developer: Project contains errors
  4. Tips for Android developer: An SDK Target must be specified
  5. Tips for Android developer: Logcat
  6. Tips for Android developer: failed to copy file to system
  7. Tips for Android developer: “Conversion to Dalvik format failed: Unable to execute dex: null”
  8. Tips for Android developer: Android emulator appearance standard
  9. Tips for Android developer: Android source code
  10. Tips for Android developer: Android SDK tools PATH setting