Information Technology Reference
In-Depth Information
Connecting to a database
Manual examination of iOS SQLite database files is possible with the use of free tools. The
following is an example of how to examine a database using native Mac commands in the
terminal. Make sure your device image is mounted as read-only to prevent changes being
made to the original evidence. To connect to a SQLite database from the command line, run
the
sqlite3
command in the terminal by entering your database file. This will give you a
SQL prompt where you can issue SQL queries:
$sqlite3 filename.sqlitedb
SQLite version 3.7.12 2012-04-03 19:43:07
Enter ".help" for instructions
Enter SQL statements terminated with a ";
"
sqlite>
To disconnect, use the
.exit
command. It exits the SQLite client and returns to the ter-
minal prompt.
