Relationship Builder

Stack

Frontend

React ReactStrap Bootstrap

API

NodeJS Express

Database

PostgreSQL

Demo Video

Install Dependancies

yarn install

Install's dependency for runnng app, first run this command before running main install

yarn install:all

This instruction will install dependencies in both client and api.

Run Project

yarn start

This command will start api on port 5000 and client in development on port 3000

Setup

Load the db.pgsql file located at the root in your postgresql local install

Update the credentials of PostgreSQL in .env at api/ , a sample .env file is at the api/ directory by the name .env.example

Update the API URL in .env at client/ , a sample.env file is at the client/ directory by the name .env.example

If you have an ssl encripted database please add the certificate in the api folder by the name ca-certificate.crt or edit the same in 14 th line at db.js file at api/

Else comment the following lines in db.js

    ssl: {
        rejectUnauthorized: false,
        cert: fs.readFileSync("./ca-certificate.crt").toString(),
    },

Scaling on AWS

The best option for scaling in amazon if the users exceed 1M is AWS Lambda Service. You only need to pay for what you use .