Display data using DB Browser for SQLite

When we consider about android developing, the database management part is important. Because nowadays most of the processes and analytics done by the users’ data. When we come to the android, there a several ways to handle databases. If you are looking for cloud based one, you have Firebase and Firestore. The other option is SQLite.

SQLite is little bit older. But still it facilitates some features to develop intermediate level apps. SQLite works with standalone processes. The purpose of this post is to introduce a way to display the data in SQLite databases that I found. Maybe you already know about this.

First you have to download and install DB Browser for sqlite. Then follow the steps mentioned below.

Download : https://sqlitebrowser.org/dl/

1)Open your project and run it using emulator

2)Then click on “Device File Explorer” tab.

Then you will see a interface like that

3) Then click on “data”

4) There is an another folder called “data” under the data folder. Click on it

5) Under this folder you have to find your app(You can find it easily by searching). After you find your app, expand the folder.There is a folder called database. expand that folder again and you will get few files like below.

6) There is a file with your database name. So you can right click on it and save it where ever you want. Then Open DB Browser.

7) Now you can open your database file from here.

Now all are set. Now you can easily open your database files using DB Browser for SQLite. I hope it will be useful for you. Thank You! 🖖