Skip to content

04 · Evidence area

Messaging Apps

Third-party messengers keep their data in app group containers, with their own schemas and their own encryption. WhatsApp's ChatStorage.sqlite reaches an iTunes or Finder backup; Telegram and Signal mostly need a full file system extraction, and Signal adds an encryption layer keyed from the keychain. This area maps the containers, the tables that matter and what each acquisition level can realistically recover.

  • ChatStorage.sqlite
  • AppDomainGroup
  • postbox/db
  • Signal (SQLCipher)

Guides

1 guides in this area

Artifact cheat sheets

  • WhatsApp ChatStorage.sqlite on iOS

    WhatsApp on iOS: ChatStorage.sqlite in the app group container, backup domain, ZWAMESSAGE and ZWACHATSESSION, media paths, LIDs and Cocoa time.

    /private/var/mobile/Containers/Shared/AppGroup/<UUID>/ChatStorage.sqlite (group.net.whatsapp.WhatsApp.shared; backup: AppDomainGroup-group.net.whatsapp.WhatsApp.shared, fileID 7c7fba66680ef796b916b067077cc246adacf01d)

  • Telegram on iOS: postbox db_sqlite and Media

    Telegram on iOS: the postbox db_sqlite key-value store, its SQLCipher layer and .tempkeyEncrypted, media cache, secret chats and Unix time.

    /private/var/mobile/Containers/Shared/AppGroup/<UUID>/telegram-data/account-<id>/postbox/db/db_sqlite (media: .../postbox/media/)

  • Signal on iOS: signal.sqlite, SQLCipher and Keychain

    Signal on iOS: the SQLCipher-encrypted grdb/signal.sqlite, the keychain key that opens it, attachments, what backups miss, and millisecond time.

    /private/var/mobile/Containers/Shared/AppGroup/<UUID>/grdb/signal.sqlite (+ -wal, -shm); attachments under .../Attachments/

  • interactionC.db: iOS Contact Interactions

    iOS interactionC.db records who the owner messaged, called or shared with, across Apple and third-party apps. Paths, tables, epochs and pitfalls.

    /private/var/mobile/Library/CoreDuet/People/interactionC.db (backup: HomeDomain, Library/CoreDuet/People/interactionC.db, fileID 1f5a521220a3ad80ebfdc196978df8e7a2e49dee)