🍄🌈🎮💻🚲🥓🎃💀🏴🛻🇺🇸 on Nostr: They always say "design your schema for your query pattern", and it helps to take a ...

They always say "design your schema for your query pattern", and it helps to take a step back and remind myself what I need to do this for.

I am saving this User's achievements to my database so that the next time I check I'll notice if there are new ones, and if so I'll have some ActivityPub messages to send to the User's subscribers.

Technically, I could just store a "lastAchievement" timestamp and then filter the User's recent achievements earlier than that.