News for hackers. Stuff that matters.
Re:Analyzing iMessage with SQL by can16358p on Wednesday April 20, 2022 @04:43AM (#31094263)
How on Earth does the blogger have only 1GB of iMessage data since 2009?

Mine gets bloated with images and videos to multi gigabytes in days, and it's unlikely that it's used only for text for 13 years. (I mean, it's either never used at all, or used for all sorts of media not just text, and since it has been used, it should be the latter)

Even if the actual media isn't stored in the database, all the metadata for all those messages should exceed 1GB IMO.

Re:Analyzing iMessage with SQL by zimpenfish on Wednesday April 20, 2022 @05:12AM (#31094419)
> How on Earth does the blogger have only 1GB of iMessage data since 2009?

Anecdatum: My `chat.db` on this laptop is 44MB for 30863 messages going back just under 4 years (basically just a handful of family.) I can see that being 1GB even for triple the length of time and many more interactions, sure.

The `Attachments` folder next to it, on the other hand, is 6.4GB.

Re:Analyzing iMessage with SQL by can16358p on Thursday April 21, 2022 @03:20AM (#31106804)
Yeah for some reason I assumed the size is for both (db + attachments) while writing the comment, which is wrong.
Re:Analyzing iMessage with SQL by philshem on Wednesday April 20, 2022 @04:59AM (#31094341)
In the iOS settings under Messages you can choose how long you want to meep your messages and content.

https://www.macrumors.com/how-to/auto-delete-old-messages-ip...

Re:Analyzing iMessage with SQL by can16358p on Thursday April 21, 2022 @03:18AM (#31106790)
Yeah but I think the author has all the messages retained dating back to the beginning.
Re:Analyzing iMessage with SQL by dliff on Wednesday April 20, 2022 @02:38PM (#31101126)
Author here. I have sent/received 643,576 messages since 2009 which totaled 590MB. To my knowledge media is never stored in the SQL database (for iMessage).
Re:Analyzing iMessage with SQL by can16358p on Thursday April 21, 2022 @03:17AM (#31106788)
Wow. I thought it would be much bigger with all the indexes and many columns. (Even if the media itself isn't in the DB)

Thanks for the clarification.

Re:Analyzing iMessage with SQL by aaaaaaaaata on Wednesday April 20, 2022 @08:31AM (#31095908)
> it's either never used at all, or used for all sorts of media not just text

This seems to be where you went wrong.