Add in-house review system

aryanindarapu / addiction-info-website

A website to help addicts and the families of addicts find treatment centers and information about different addictions and treatments.

1 stars 0 forks source link

Add in-house review system #12

Open aryanindarapu opened 3 years ago

aryanindarapu commented 3 years ago

To increase the validity of the website, we need to build an in-house review system for each treatment center. Users should be able to place a review, which will show up on the website. Things to consider:

How will I get a sizable number of reviews?
Should I use current Google Maps reviews?
Contact Gareth
AWS or other database storage required

aryanindarapu commented 3 years ago

Current Idea: have each treatment center as its own table. The name of the table is the place id from Google Maps and each row is a new review. On a different table, have the table names and a dynamic average of the ratings given by the reviews. When each treatment center in the area is loaded, pull the corresponding row in the master table and output that rating.

aryanindarapu commented 3 years ago

https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ - this will help with production level implementation for security