Home » Blog » Topic » how to access sqlite database in a new application on android device ?

how to access sqlite database in a new application on android device ?

Stephen West ~ Modified: September 9th, 2015 ~ ~ 1 Minute Reading

Home Forums how to access sqlite database in a new application on android device ?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #614 Score: 0
    Stephen West
    Moderator
    4 pts

    I have a set of data in sqlite database. Is it possible to view the database in device? I have checked in ddms mode,the data is empty in file explorer.

    #620 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    you can try this:
    1. adb shell
    2. cd /go/to/databases
    3. sqlite3 database.db
    4. in the prompt, type .tables;

    .tables this will give you all the tables in the database.db

    5. select * from table1

    #767 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    If you are using a Real Device and it is not rooted then it is not possible to see your data base in File Explorer because due to some security reason that folder is locked in android system. And if you are using it in an emulator, you will find it in File Explorer /data/data/your package name/databases/your database.db

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.