|
|
Article DetailsSQLite 3 database files - Identifying Deleted Data |
| Date Added: June 07, 2009 07:19:46 PM |
| Author: admin |
| Category: Documents |
|
SQLite 3 database format, a self contained relational database format used in a growing number of applications ranging from Internet Browsers to mobile phone backup software. Visit www.sqlite.org for more information. A sample database was created with a table ‘addressbook’, three records were inserted into the table listed below. One record was deleted, SQLite3 was closed and a backup of the database was performed. A different tool was used to list the available records after deletion.
Opening the same file in a hex editor the deleted record can be seen.
Recovery depends on the database complexity and/or host software (if the Vacuum command is issued on this database then the deleted data will be lost).
More information on SQLite3 and database commands: http://www.sqlite.org |