Managing and browsing sqlite databases

[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

C:\Users\Pc>

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.