/SQLiteSync

Android Library to synchronize SQLite replicates

Primary LanguageJava

How to use SQLite3 on Android

  • turn on the debug mode of your device
  • connect your Android device via adb-usb-drivers of the manufactorer
  • install and run your application on the device
  • insert, update and delete data
  • close the application, to close the database
  • open the Android terminal emulator

run this, to get root permissions

$ su

go to the database directory

$ ls /data/data/com.example.app/databases

run sqlite3 and load the database

run all sql commands with (;) at the end

$ sqlite3 database.db

to get all attributes of a table, run:

$ PRAGMA table_info(tablename);

to get all tables in the database, run:

$ SELECT DISTINCT tbl_name from sqlite_master;