{"id":21823,"date":"2026-01-30T20:41:43","date_gmt":"2026-01-30T20:41:43","guid":{"rendered":"https:\/\/johnjohnston.info\/blog\/?p=21823"},"modified":"2026-01-30T21:11:17","modified_gmt":"2026-01-30T21:11:17","slug":"local-toot-archive","status":"publish","type":"post","link":"https:\/\/johnjohnston.info\/blog\/local-toot-archive\/","title":{"rendered":"Local Toot Archive"},"content":{"rendered":"\n

I used to love Martin Hawksey’s tweet archive which I used for quite a while and mirrored on the web<\/a>.<\/p>\n\n\n\n

Yesterday I was reading Alan’s post: My Digital Cleanup: IFTTT \u2013 CogDogBlog<\/a> which explains how he now archives toots with make.com a sort of ifttt replacement. This sounds very useful. I’ve quite often failed looking for old toots with the mastodon interface.<\/p>\n\n\n\n

This made me think a bit. I’d been playing with json to sqlite for my flickr photos, On this Flickr Day<\/a>. I wondered if I could do this with my toots too.<\/p>\n\n\n\n

Turns out I could take a very similar approach:<\/p>\n\n\n\n

    \n
  1. A bash script pulls down all my previous toots to a sqlite database.<\/li>\n\n\n\n
  2. Another script updates the database.<\/li>\n\n\n\n
  3. A php file provides a search and display.<\/li>\n\n\n\n
  4. The search can be viewed in the browser using a simple php server.<\/li>\n<\/ol>\n\n\n\n

    There are a few things that could be improved.<\/p>\n\n\n\n