View sqflite table contents for debugging

user_13111006 0
Viewed 3622

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.

sqflite flutter
3 Answers

  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

user_153131240

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

enter image description here

user_89214500

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!

user_55137880
Related