Learn from your iMessage history on the Mac

Did you know you can access your iMessage history on the Mac and that it is a SQLite DB?

Go to ~/Library/Messages/chat.db and open it in a SQL browser like the open-source DB Browser for SQLite. Now you can run queries on the db, like for example:

      LENGTH(text) -
      LENGTH(REPLACE(text, '👍', ''))
    ) as total
  from message where handle_id=23;

And get a count of the times you have sent 👍 to a friend with the ID “154”.

Pretty interesting to play around with…

← Read all articles