MacOS – What’s the difference between chat.db, chat.db-shm and chat.db-wal


There are 3 files used to save Messages on Mac.

  • chat.db
  • chat.db-shm
  • chat.db-wal

What are each of them for?

Best Answer

Per this great answer:

The shm and wal are standard indexing and checkpoint files that accompany the main database file. Nothing special on th messages side other than using the sqlite3 format to store the data to disk.