[View]  [Edit]  [Lock]  [References]  [Attachments]  [History]  [Home]  [Changes]  [Search]  [Help] 

Managing and browsing sqlite databases

You can browse sqlite databases in your Android device from adb command line:
Microsoft Windows [Versión 10.0.16299.371]
(c) 2017 Microsoft Corporation. Todos los derechos reservados.

C:\Users\Pc>adb devices
List of devices attached
* daemon not running. starting it now on port 5037 *
* daemon started successfully *
5a95285e        device

C:\Users\Pc>adb -s 5a95285e shell
ailsa_ii:/ $ cd data
ailsa_ii:/data $ cd data
254|ailsa_ii:/data/data $ run-as net.smalltalking.s8.jx8
ailsa_ii:/data/data/net.smalltalking.s8.jx8 $ ls
app_textures cache      files shared_prefs testdb2 testdb3-shm testdb333
app_webview  code_cache lib   testdb       testdb3 testdb3-wal
127|ailsa_ii:/data/data/net.smalltalking.s8.jx8 $ exit
127|ailsa_ii:/data/data $ exit


You can also explore your data in Android Studio (AS):
go to menu view -> tool windows -> Device File Explorer

in the displayed tree navigate to data -> data -> net.smalltalking.s8.jx8

Then you can select your database and download it to your computer (right-button save option) and browse it by means of a database browser, like DB Browser for SQLite, or view it in AS.