Sched-Aroo

Description

To help solve the annoyance of needing to create a schedule manually every few months, why not build an app?? Specific pain points include:

same people volunteering leading to burnout
unavailable date constraints
volunteers serving in specific fields constraints.

Tech Stack

Postgres
Node.js
Express
React
Redux
Sequelize
Materialize
Passport for Auth

Database Schema

Schema diagram can be found at repo root level as png file or click here

Initial Setup

Add a .env file with the tokenSecret value of your choosing. This is needed for the signing of the JWT
Run createdb scheduler-dev in the terminal. You must have Postgres installed to perform this. This will create the local database
Modify the ORM/config file accordingly with your credentials to connect to your local db
Run sequelize db:migrate in the terminal before launching the application. This will perform all the migrations to setup the database
Yarn && cd/client Yarn - node module installs for server and client dependencies
Yarn dev to launch the app locally

Other Notes

Shout out to jmuturi for posting a tutorial on wiring up Node, Postgres, and Express with a Sequelize ORM. Checkout the tutorial. For any questions referring to the setup of Sequelize, refer to the article.
Trello board
Many-to-Many guide for Sequelize