How to see SQLite database ?

  • 1
  • Question
  • Updated 4 years ago
Hello,

I'm using SQLite plugin to store my data. But there is no visual interface like php my admin to see what's going on the sqlite. and I'm used to with the phpmyadmin to create database, table and add/remove data. How can I see the sqlite in GUI ?

Thanks!
Photo of Abhishek Deshkar

Abhishek Deshkar

  • 48 Posts
  • 0 Reply Likes

Posted 4 years ago

  • 1
Photo of Petra V.

Petra V., Champion

  • 7794 Posts
  • 1391 Reply Likes
You could simply perform a query and display the results (in a test page of your app). After all, that's what phpmyadmin does, too.
Photo of Abhishek Deshkar

Abhishek Deshkar

  • 48 Posts
  • 0 Reply Likes
Thank you sir. I have used android studio and then used android device monitor and then imported .db file and opened it in mozilla firefox sqlite manager.
Photo of JesseMonroy650 (Volunteer)

JesseMonroy650 (Volunteer), Champion

  • 3325 Posts
  • 122 Reply Likes
@Abhishek,
some browsers support basic browsing support. I believe Google Chrome supports this, but there are also plugins like this:
https://chrome.google.com/webstore/de...

Jesse