Non SST specific question. I have the following data in DynamoDB

comicSeries: { title: 'whatevr', active: true/false }

and then customers

haveMany

subscriptions that look like this

subscriptions: {[{ comicTitle: 'whatevr', active: true/false }]}

So a comic or subscription can be

active

. This works great 🎉 When a comicSeries becomes inactive, I want to deactivate each subscription for each customer. Realistically, I can just do this in a lambda. But isn’t this technically a use for a queue? My question is, how would you handle this in a robust way?

there's actually 3 separate states here 1. Comic is active 2. Subscription is active 3. Can a user access the comic (need 1+2) to be true. You can store 1+2 as you do now and just compute 3 whenever it's requested If you do want to precompute and store the 3rd value yes you would need to bulk update things in a queue

What are you access patterns? How do you need to access the data?

I dont think this is a data modeling question…

Hmm, I guess I read the question as "how do I represent deactivated subscriptions if my data is modeled this way?"

I'm sorry I was unclear. Derek is correct. The question is how to deactivate all the comic subscriptions when the comic changes state to inactive

A queue would work just fine, allow retries, and enable you to have a DLQ, and is much easier if you are only ever going to do this once. If many times, consider above.

Gotcha. Ya they'll potentially go from active to inactive and back again. So I'll review those choices. Thanks so much Derek