Sqlite browser for Android development



Get the SQLite DB file from Android studio

Below android studio 3.5

Tool window bar -> "Device File explorer" 

Above Android 3.5
You can find "Device File Explorer" in the bottom right corner of the screen
open directory in data/data/your-application-package/databases



In the new architecture, 3 files are created in the databases directory
database-namedatabase-name-shmdatabase-name-wal
You have to export all these 3 files in the same directory then open the first one file (that is with database-name only ) in any SQLite browser.
Offline SQLite browser

Download DB Browser for SQLite free software for as per your operating system then open the "DB Browser for SQLite.exe" executable file

You can import the database file and view the data as per the below sample screenshot




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


Stetho tool for Android debugging

http://facebook.github.io/stetho/
http://gmariotti.blogspot.com/2015/07/a-first-glance-at-stetho-tool.html

Comments

Post a Comment

Popular posts from this blog

Google Assistant Implementation in Android application with app actions

Image
  Process flow to create app action in android native: Step 1) Create action.xml with Built-In Intent and defined in androidmanifest.xml Step 2) Create deep link through firebase dynamic link SDK Step 3) Map the Deeplink with built-in Intent in android action.xml Step 4) Create the application in Playstore Step 5) Upload the signed apk in Playstore as save in draft Step 6) Open the app action testing tool from latest android studio after upload the apk in playstore Step 7) Login the same google account in playstore, android studio and android device Step 8) Make sure the check the same Locale language (en-Us) in Android device and action testing tool   Built-In Intent & Sample Query: actions.intent. OPEN_APP_FEATURE           - Open History in <innovationName>           - Open sale in <innovationName>         ...
Read more