Ich habe 10 Jahre iMessages analysiert, um zu sehen, wie Freundschaften mit der Zeit verblassen [OC]
Von LatterLengths
Ich habe 10 Jahre iMessages analysiert, um zu sehen, wie Freundschaften mit der Zeit verblassen [OC]
Von LatterLengths
5 Kommentare
* Source:My personal iMessage history (`chat.db`), which is a local SQLite database stored on macOS
* Visualization: Generated using a project called join lore that parses the SQL database to map relationship equity over time
* Methodology:
* Data Extraction: I queried the `message` tables in `chat.db` to reconstruct conversation threads from 2016–2026.
* Equity Score: Calculated based on a weighted formula of message volume + recency. This ensures that a best friend from 2018 who I stopped texting doesn’t disappear immediately; they drift slowly as their „equity“ decays over time.
* Sectors: I used the timestamp of the first interaction to assign each contact to a specific cohort (e.g., 2016 Start, 2018 Start), which creates the sector view seen in the video.
* Pulsing Rings: I added pulsing rings to show the contacts whose equity growth far outpaced other contacts
* Lost contacts: Defined as over a year of no contact/text messages
* Physics: The nodes use a collision-based gravity model where size and distance = message volume and recency
* a few things that surprised me:
* the saddest part was watching my hometown sector. quite a few big bubbles just in the grey. those were close friends at one point
* you can see a ceiling for work friends. even when i was in office every day in 2019 they never came into the inner circle the way hometown friends did
Absolutely gold star top tier beautiful data. Incredible presentation. I bet we’ll see other people replicating your work this is stunning.
OP why is your mom’s bubble bigger than your girlfriend’s. does your gf know about this
Looks like you have a lot of work friends you’re not close to? I feel like mine would look the same honestly
I see one guy was ahead of your mom, then they suddenly flipped positions. That a high school friend? I feel like that would make sense if you moved away and grew apart from him (though not totally), but started messaging your mom more often because you can’t just walk into the other room to talk to her anymore. How close is my guess?
Also, I really love this, but wish it were a video and not a gif. I really wanted to pause at some points and just take it in, because there’s a lot to see at once.