Cordova SQLite Devtools
A quick and easy way to pull a backup of a sqlite database from a connected Android device.
npm install -g cordova-sqlite-devtools
cordova-sqlite-devtools uses Android Debug Bridge (adb)
to communicate with your Android device. Make sure you have
adb installed / configured, and you
have connected your mobile phone to your laptop / desktop.
List all databases on the device.
Pull Database Backup
With the below command, you should be able to find the database copied into the
folder of the current directory. Use SQLite browser to open the
database and browse the data.
csd pull awesome.db
awesome.db is the optional name of the database to backup. Note: the database name is case
sensitive. If the database is not provided, you will be prompted to select from a list of available
databases on the device.
Delete Database Backups
_sqlite-backups folder and all backups.
The generated file can be included (
<script src="build/sqlite.js"></script>) and the queries accessed from code. For example,
if your SQL file is named
MyAwesomeQuery.sql, then you can access the query via
||Source glob of sql files.||
For easy development, clone the repo and run the following commands in the
npm installnpm linknpm run build