it's a ticketing platform. you create an event (i'll make a DO for each), and you can create tickets

it's a ticketing platform. you create an event (i'll make a DO for each), and you can create tickets for each person attending (stored inside the DO). The problem is that I will need the following queries to execute rather quickly:

  • get all users (paginated) of each event.
  • get info about a specific ticket (they can have policies, so i'll want the ticket to return with the policies it follows)
  • find a ticket based on queries such as "holder's name"
policies are shared among other tickets too, so tickets and policies have a many-to-many relation

i can handle joins since i could handle constrains myself given the (relative) simplicity of the data.

tl;dr: i can't really not store the data or make a DO per ticket, since looking into every single "ticket DO" would be excruciatingly slow
Was this page helpful?