Getting SQLite database by adb shell in cmd

Question

Very simple question but confusing . i am using sqlite in my android app.

i want to know we can perform (create ,insert,update,delete) operation in sqlite by command prompt:-

path> adb shell

shell@android:/ $ sqlite3 /data/data/pack/databases/name

sqlite> operations.....

this all success with my emulator.

but i did same thing after attaching my google nexus device.

path> adb shell

error:-/system/bin/sh: sqlite3: not found

why its showing this error after closing the emulator and adding the device.

this means we can not read the database of device(not emulator) by cmd.

or is there any way to read device(not emulator)database by cmd.

Answer 1

The sqlite3 program is normally not installed on production devices. To inspect or modify the database you would have to copy it over to your development machine and use the sqlite3 program from the Android SDK.