CyberKit

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.

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.

Sources