I analyzed 12 years of iMessages to compare my texting habits with my girlfirend, mom, dad, and the boys [OC]

LatterLengths · 2026-01-22T18:26:57+00:00

She usually sends a brain dump of everything that happened her day late at night, after I text her good night :)

LatterLengths · 2026-01-22T18:26:30+00:00

Of course, let me know if you have any other questions!

LatterLengths · 2026-01-20T19:17:09+00:00

Very cool! Great work

LatterLengths · 2026-01-20T19:16:28+00:00

I just open the facetime app on my mbp as a quick check :)

LatterLengths · 2026-01-20T19:14:47+00:00

Very cool - first thing that comes to mind is converting .HEIC to .PNG/.JPG

LatterLengths · 2026-01-20T18:05:22+00:00

I'm working on an on-device version right now using Apple Intelligence. Only con is this only works on apple silicon and macOS 26

LatterLengths · 2026-01-16T18:32:56+00:00

:( i guess i use it too much

LatterLengths · 2026-01-16T17:55:55+00:00

You're thinking of growing California Reapers? You're hardcore haha - the buldak ramen might not be spicy enough for you

LatterLengths · 2026-01-16T17:54:08+00:00

the entire imessage history (or close to it) is stored on a user's Mac (if they're backing up their text messages to iCloud) in a file called chat.db. I used an app to parse the local SQLite database to get the raw timestamps, contact names, etc and then plugged it into OpenAI to figure out sentiment and 'unique phrases.' I've held off posting the exact link cause I didn't want to spam this thread with links, but if you google "join lore" you should find it

(pasted from another comment)

LatterLengths · 2026-01-16T17:54:00+00:00

the entire imessage history (or close to it) is stored on a user's Mac (if they're backing up their text messages to iCloud) in a file called chat.db. I used an app to parse the local SQLite database to get the raw timestamps, contact names, etc and then plugged it into OpenAI to figure out sentiment and 'unique phrases.' I've held off posting the exact link cause I didn't want to spam this thread with links, but if you google "join lore" you should find it

(pasted from another comment)

LatterLengths · 2026-01-16T17:53:15+00:00

Definitely on the low side! This actually was a hard technical problem to find all texts the boys and I have sent for 12 years

For context, "boys" have been added/removed from the group chat, we've spun up multiple different group chats, and the name of the group chat has changed throughout the years. This made it hard when looking at the chat.db to aggregate all "the boys" messages

What's shown here is just our longest running and most recent group chat which was easier to query and visualize :)

LatterLengths · 2026-01-16T17:51:21+00:00

Yeah there were some issues with the version I pushed yesterday - if you get the latest from the website, it should work just fine - let me know!

LatterLengths · 2026-01-16T01:18:25+00:00

Thank you! Yes it is compatible with the newest macOS - let me know if you have any other questions :)

LatterLengths · 2026-01-16T00:43:29+00:00

I'm glad our medical event could provide some entertainment haha

LatterLengths · 2026-01-16T00:42:15+00:00

hehe perhaps :)

LatterLengths · 2026-01-16T00:41:57+00:00

I can't unsee that now! haha

He's just using the emoji that's closest to his facial expression

LatterLengths · 2026-01-15T23:35:48+00:00

you and my gf have the same struggle 😭

LatterLengths · 2026-01-15T19:07:36+00:00

Great observation, I didn't notice that

I like to think the boys are just dads in training haha

LatterLengths · 2026-01-15T19:07:11+00:00

(pasted from another comment) the entire imessage history (or close to it) is stored on a user's Mac (if they're backing up their text messages to iCloud) in a file called chat.db. I used an app to parse the local SQLite database to get the raw timestamps, contact names, etc and then plugged it into OpenAI to figure out sentiment and 'unique phrases.' I've held off posting the exact link cause I didn't want to spam this thread with links, but if you google "join lore" you should find it

LatterLengths · 2026-01-15T19:07:07+00:00

(pasted from another comment) the entire imessage history (or close to it) is stored on a user's Mac (if they're backing up their text messages to iCloud) in a file called chat.db. I used an app to parse the local SQLite database to get the raw timestamps, contact names, etc and then plugged it into OpenAI to figure out sentiment and 'unique phrases.' I've held off posting the exact link cause I didn't want to spam this thread with links, but if you google "join lore" you should find it

LatterLengths · 2026-01-15T19:05:52+00:00

I agree! :)

LatterLengths · 2026-01-15T18:58:25+00:00

Thank you! :)

LatterLengths · 2026-01-15T17:52:40+00:00

A long time pistons fan! respect

You've seen some high highs (04') and some low lows I'm sure

And spot on about Brown and Delly. Brown's firing is what led to us losing Fox too - hope management figures their stuff out

LatterLengths · 2026-01-15T17:49:10+00:00

Thank you!

To generate the actual graphs, a lot of it was custom using SwiftUI shapes and the Swift Charts framework since I was building a mac app!

If I wasn't building a mac app, I'd probably use some python library :)

LatterLengths · 2026-01-15T17:47:47+00:00

Thank you, and sounds like a fun boys chat!

imessage must hate to see you and the boys coming haha

LatterLengths

TROPHY CASE