SQLite App Databases
Also called app SQLite stores, WAL, freelist records.
The SQLite files mobile and desktop apps use to store messages, history, and state.
What it is
SQLite is the embedded database that most mobile and many desktop apps use to store structured data (messages, contacts, browsing history, caches) as .sqlite/.db files often accompanied by write-ahead log (-wal) and shared-memory (-shm) sidecars. Records deleted from a table may persist in freelist pages, unallocated areas, and the WAL.
Why it matters
These databases are the heart of mobile forensics, and recovering deleted rows from freelists, unused page space, and the WAL frequently restores 'deleted' messages and history. Forgetting to collect the -wal/-shm files, or to check them, risks missing the most recent and the most-deleted records.
In practice
Carving freelist pages and the -wal sidecar of a chat app's database recovered messages the user had deleted from the conversation view.
What to look for
- Message, history and account tables in app databases.
- Write-ahead log files holding recent changes.
- Free pages with deleted records.
Common mistake
Copying only the .db file. The -wal and -shm files can hold recent and deleted data.
Practice it nearby
CyberKit has no tool for this term itself. These are the closest places to practice it.
- Linux Persistence Reader
Read a crontab line, a systemd unit or an auditd record, and see what runs, when, and as whom.
- Linux Case
A server making outbound connections nobody can explain: read its audit log, journal and scheduled jobs, and say who did what.
In the field
Well-known tools where this shows up on the job. They are listed to show the landscape, not as a recommendation.
-
Mobile Verification Toolkit Open source
Checks iOS and Android backups and file systems for signs of known spyware.
-
iLEAPP Open source
Parses iOS extractions into readable reports of apps, messages and system logs.
Read next
- iOS Backup Artifacts: The structured backup an iPhone produces, a rich offline source of app and system data.
- Android Logcat: Android's runtime logging stream capturing system and application messages.
- KnowledgeC Database: Apple SQLite store of user-activity events used to reconstruct device usage.