Export device sqlite database and browse it on your computer using command line

This presupposes that you correctly installed the Android SDK have set up your $PATH and sqlite3 installed.

Tested on Android 9 use the command:

adb -d shell 'run-as org.akvo.flow cat /data/data/org.akvo.flow/databases/surveydata' > surveydata

will save surveydata to your current folder

sqlite3 surveydata

examples of commands to use:

.tables

.help

.schema tablename