If you ever need to edit a SQLite database on Android then use the app I built: SqlitePrime. You can use the built-in SQL Editor, view and edit fields, create Tables, view DDL for Tables, Views, Indices, Triggers. It also has support for editing the Blob data type. You can also edit app's databases (Root needed)
The app can also be downloaded from here https://sqlite-prime.en.aptoide.com/ in case you can't download it from Play Store.
TODO: Migrate Sqlite Prime app entirely to Kotlin with MVVM and Open source it (I'm planning to do this when I find a bit more free time).
AutobiographerOct 11, 2017
This user hasn’t posted yet.