search

Allen-BME / pointless-analogies

1 stars 2 forks source link

Add DynamoDB database to stack to store voting information #11

Open NinteMars opened 1 week ago

NinteMars commented 1 week ago

A DynamoDB database should be added to the stack to store voting information.

I think, at least for now, that the database can be set up like Partition key: Image ID/key // Look at chapter07/gallery which created a hash for each

We will likely need to add a sort key that associates to a unique voter so we can check to see if someone already voted, but we can probably wait on that for now

samuelstanley0101 commented 4 days ago

I think we should make this into an RDS database, since with voting information we want the data to be 100% correct. We can do that with a DynamoDB if we have a queue and some additional logic, but since RDS already does that for us I figure that's what we should probably use.

NinteMars commented 4 days ago

Likely needed information: Key /ID: varchar(whatever size our hash output is) → Image ID to link to image in bucket Category1: varchar(30 should be plenty Category1VoteCount: int Category2: varchar(3) Category2VoteCount: int

If we ever plan on adding support for comments, we would likely need an additional database, as we couldn't implement an arbitrary amount of comments in the table with SQl.