Conversation

Notices

1. Embed this notice
   Eaton (eaton@phire.place)'s status on Monday, 04-Dec-2023 01:35:33 JST Eaton

   The epic saga of “building a database of every goddamn thing I ever put on the internet” continues. Current twist: work history! Turns out I’ve averaged about 3-5 web sites per year for about 25 years. Some of the has been built from scrathc, quite a few were working as part of a team. But that’s… a lotta web sites.

   • Embed this notice
     Eaton (eaton@phire.place)'s status on Monday, 04-Dec-2023 01:40:17 JST Eaton

     in reply to

     The Question: How to remember *when those projects happened?*

     The Answer: find old .mbox files, parse, export to .sqlite, extracting sender domain and year-week for each message.

     SELECT domain, week, count(1) as total FROM emails
     GROUP BY domain, week
     ORDER BY week asc, total desc

     Turns out, that is… an extremely good first pass at “when did I work on what projects.”

   • Embed this notice
     Eaton (eaton@phire.place)'s status on Monday, 04-Dec-2023 01:41:20 JST Eaton

     in reply to

     Grouping CI/issue notification emails by the name of the project in the subject worked well, too, once I hit the “bascamp/unfuddle/github” era.

   • Embed this notice
     Eaton (eaton@phire.place)'s status on Monday, 04-Dec-2023 01:43:05 JST Eaton

     in reply to

     • Ethan Marcotte

     @beep EXACTLY “holy crap, that’s right that’s how i spent thanksgiving 2002” etc etc

   • Embed this notice
     Ethan Marcotte (beep@follow.ethanmarcotte.com)'s status on Monday, 04-Dec-2023 01:43:07 JST Ethan Marcotte

     in reply to

     @eaton I started looking over some of my early freelance work (like, ~2002–2004), and I had honestly *completely forgotten* some of these websites.

     (uh this is not a “ooh i did so much work ooh” flex, so much as it is an “oh god i’m so old and my memory is basically cheesecloth” statement)