View sqflite table contents for debugging

Question

I am integrating a Database into my flutter app with sqflite. Since I am a visual understander in terms of problems, I would like to be able to see table contents for debugging.

Is there a possibility to view/read the table contents on the phone via some kind of UI or via debug? I am using visual studio code.

Silvery

Previously asked here: #57159501 – Derr

Answer 1

1. Android Studio , Use Database Inspector as Code Poet Said

2. IntelliJ IDEA / DataGrip. you can choose Android SQLITE db, and it detect your connected devices. IntelliJ Screenshot

*dont have enough reputation to post img

Swick

Answer 2

You can use Database Inspector at bottom bar of Android Studio to view

Illyes

Answer 3

Open project in Android studio, click on App Inspection

Apis

Answer 4

You can find Database Inspector to see visual of database in android studio and for that you need to open App Inspection Tools->App Inspection->Database Inspector

Humorist

Answer 5

If you were willing to move to Android studio, from version 4.1 which is available in the Canary and Dev channels, there is a Database Inspector.

Alternatively, I see that there is a VS code extension that might correspond to what you are looking for.

Finally, you could simply use DB Browser for Sqlite.

Good luck!

Shophar

The sql file should stay in the mobile device. How these tools can connect to those files? – Coffeecolored