System design for the question-and-answers portion of a retail portal's product page.

• Express (load balancer and API servers)
• PostgreSQL
• MongoDB (with Mongoose)

I tested service performance with both SQL and noSQL databases. The data shape was a little different for the two, so the re-shaping process for the SQL and noSQL implementations differed, which is why I have database-specific APIs.

SQL:

• PostgreSQL database: nemunoz/shopping-portal
• API with data scrubbing for PostgreSQL: nemunoz/shopping-portal-api

noSQL:

• MongoDB database: nemunoz/shopping-portal-db-nosql
• API with data scrubbing for MongoDB: nemunoz/shopping-portal-api-nosql

I chose to use human stick figures instead of personal computers as a way to remind myself -- as I can get hyper-focused on instances, containers, etc -- that people are actually the origin of requests in this system.