Home » 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
  • September 9, 2015 at 12:30 pm #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.

    September 10, 2015 at 10:01 am #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

    September 30, 2015 at 9:05 am #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

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