How to See SQLite Database Data Saved in Device using Android Studio

 

from https://aboutreact.com/see-saved-data-of-the-sqlite-database-in-device/

4. Find Device File Explorer

If you are unable to find the Device File Explorer then try to find view option in the top menu and hover over “Tool Windows”. Here you will see the “Device File Explorer” option just click on it.

5. Select the Device

After clicking on it, you will see a window. At the top of that window, you can see a dropdown with a list of devices connected with your development machine (also includes emulators). Select the device from which you want to see the Realm database. Select the device and expand the data option.

6. Find Package Name

Find the package name of your application in the list.

7. Export the SQLite database file

Expand the application package directory and expand the database directory under that. You can see the database you have created. After finding the database right click on that and save it to any directory.

Please save the database on a known location. (This process is like downloading the database from the mobile application to your PC/Laptop)

8. Download SQLite Browser

You can download SQLite Browser from here and can install it. This SQLite browser will help you to see the content of the exported database file.

9. Open the exported file in SQLite Browser

If you have successfully installed the SQLite browser or already have any then you open it.

Now Open the database using File > Open Database> Select the exported DB file.

10. Done

If you are lucky or have followed every step then you will be able to see the database in SQLite Browser. You can explore SQLite Browser and can query the data as per your need.

This is how you can See SQLite Database Data Saved in Device using Android Studio. If you have any doubts or you want to share something about the topic you can comment below or contact us here. There will be more posts coming soon. Stay tuned!

Hope you liked it.