How to open SQLite database on DB Browser for SQLite(No emulator)

Question

I have been looking for hours now how to see my database using the program DB Browser for SQLite (http://sqlitebrowser.org/).

I downloaded the software and i can't find any file on my computer that can be opened with this software.

So what kind of file android SQLiteOpenHelper class generates? And how can i open it using the software mentioned(Or any other way i can see my database?).

I'm not using emulator. I run my app on an actual device.

EDIT So i guess i need to do this adb pull data/data/package-name/databases/database-name and i really dont know how to do it.

@Tony Never heard of it. Just installed it.I will check it out. — God
– God, Commented Nov 28, 2015 at 9:02
@Tony My device is not rooted so i cant open it with SQLite Debugger.It says i can only open it using sd card. — God
– God, Commented Nov 28, 2015 at 9:03

SamuelD · Accepted Answer · 2015-12-04 06:59:42Z

1

In my development i encountered same issue. Your database gets saved in "/data/data/yourapp/database.db".

This is not reachable by default. You have to root your device to view this location. This is something i didn't do. Instead i saved my database in another location that is reachable by default.

public static final String database_path = Environment.getExternalStorageDirectory() + "folder name";

Then i went in the Android Device Monitor and looked at that location to find my database.

Once i found it i used SQLiteStudio to view my database and look if everything is in order.

See http://sqlitestudio.pl for more information

Does that help you out ?

Update 1

You can put your database where you like, any folder you haver permission on. Then you will have to add the path to your constructor of your helper.

public MyDatabaseHelper(Context context) {
    super(context, DATABASE_PATH + DATABASE_NAME, null, 8);
    this.myContext= context;
}

How do you get your database? You copy it or you create it programmatically?

edited Dec 4, 2015 at 6:59

answered Dec 1, 2015 at 14:50

SamuelD

3332 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

God Over a year ago

Where did you exactly wrote that path line of code?

SamuelD Over a year ago

In your helper class for your database. My predefined db is in the assets folder, where i copy it locally into the device at the location i want. Be sure to set in the manifest, write external storage...See developer.android.com/training/basics/data-storage/… for reference

God Over a year ago

Thanks. i will look after that tomorrow.

God Over a year ago

The `"folder name" is any folder i choose? Like to open a new folder an call it db and store it there?

God Over a year ago

I do it programmatically. i Created a folder calledUsersDb and then i wrote in the SQLiteOpenHelper class public static final String DATABASE_PATH = Environment.getExternalStorageDirectory() + "UsersDb"; and now i only need to add the path to the constructor like you wrote?

|

Collectives™ on Stack Overflow

How to open SQLite database on DB Browser for SQLite(No emulator)

1 Answer 1

Update 1

7 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Update 1

7 Comments

Linked

Related