3

I am working with a SQLite3 Database in my .NET MAUI App. The App is running on Pixel 5 - API 33 (Android 13.0 - API 33)-Emulator right now.

Right now, I am doing my SELCT-Statements to verify my stored data directly in the adb command probmpt (VS > Tools > Android > Android Adb Command Prompt...).

This command prompt is not very comfortable for me as it doesn't even provide a history of the commands I executed. Also, I always have to login first as "adb root" then run "adb shell" and within that connect to my SQLite3 database (sqlite3 /data/user/0/com.companyname.myapp/files/MyDatabaseSQLite.db3).

Is there a Database Editor I can use in combination with App-Development and connect to my database which is actually running in my Emulator. In case there is no Database Editor is there anything that at least provides some history for the commands I executed?

Improve this question
7
  • Why dont you use the Database Inpector ?developer.android.com/studio/inspect/database Commented Apr 29, 2023 at 6:37
  • Not an answer but maybe you could use EF along with and maybe editor would not be needed: medium.com/@taublast/…. Google for "EF compiled queries chapsas" after that. Commented Apr 29, 2023 at 6:53
  • @Q.u.a.n.gL. - I am working with Visual Studio 2022 and Pixel 5 - API 33 (Android 13.0 - API 33)-Emulator. I can't see the option described there neither in VS-Menus nor in the Android Device Manager Commented Apr 29, 2023 at 7:19
  • Not sure I understand your setup, but maybe dbeaver.io Commented Apr 29, 2023 at 8:39
  • Try SQLite Editor for Android Commented Apr 29, 2023 at 9:04
Related questions
3412
Improve INSERT-per-second performance of SQLite
1445
How can I list the tables in a SQLite database file that was opened with ATTACH?
1134
How do I check in SQLite whether a table exists?
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.