Come up with idea for View Components to natively support caching by running callbacks whenever an associated record is updated #wip (psuedo code)

Use fixed project logo URLs to reduce DB queries. If a project emoji logo doesn't load, please do hard a reload to refresh your browser cache #wip

See response times drop significantly after switching to permanent avatar URLs and fixing indexes for todo similarity search #wip

Move to fixed avatar URLs for all users ( wip.co/@marc/avatar ) and cache it with Cloudflare, so we no longer need to run an ActiveStorage database query each time we show an avatar somewhere #wip

Write long post about finally cracking "social network for makers" #wip twitter.com/marckohlbrugge/st…

Load "recent media" on user profiles in a turbo frame to see if it improves page speed #wip

Add caching keys as HTML comments so I can see if todos are properly cached #wip

Ask author of `neighbors` gem how to optimize my SQL queries, because I just realized that by adding vector embedding to the todos, we're now loading ~25x as much data whenever we're loading todos from the database even though in 99% of cases we don't need the embeddings #wip – github.com/ankane/neighbor/is…

Don't try to load todo comments if comments_count is zero, saving an unnecessary network request and making the site feel a bit more snappy #wip

Use comments_count cache for "Reply 3" buttons instead of doing a database query for each 😅 #wip

Make WIP streak mascott called "Streaky McWipperson" #wip

Add a comments_count cache to todos #wip

Simplify the way we count comments on a Post by including all replies too #wip

Render SVG fallback avatars on WIP itself rather than the unreliable node server we had before. Example: wip.co/avatars/1.svg?text=MK #wip

Add swapfile to server #wip

Manually clear out PgHero jobs that were stuck in the queue, not allowing any other backgrounds jobs to run #wip

Remove cron container which I think was one of the things breaking #wip

Change todo vector indexes from IVFFlat to HNSW #wip

Upgrade to new Rails 7.1 defaults. This might have invalidated some older cookies if you haven't signed in in a while #wip

Add uptime monitoring for cron jobs #wip