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?
Per this great answer: https://stackoverflow.com/a/12948036/475228

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.