A simple CRUD (Create, Read, Update, Delete), full-stack web application to create, read, update, and delete student grades

Try the application live on my porftolio website

• * Teachers can view a list of recorded grades
• * Teachers can view the average grade for the class
• * Teachers can add a grade to the table
• * Teachers can delete a grade from the table
• * Teachers can edit the student name, course name, or student grade from the table

1. Clone the repoistory

git clone https://github.com/Keith-Tachibana/Student_Grade_Table_Fullstack.git

2. Change directory to cloned folder

cd Student_Grade_Table_Fullstack/

3. Install all dependencies with NPM

npm install

4. Start PostgreSQL server

sudo service postgresql start

5. Create the database

createdb studentGradeTable

6. Import the schema

psql -d studentGradeTable -f schema.sql

7. Import the example data

psql -d studentGradeTable -f data.sql

8. Edit your nginx default site configuration to reverse proxy the Express.js server

cd /etc/nginx/sites-available
sudo nano default

• 8a. In the "server" code block, add this underneath the first location definition:

  location /api {
    proxy_pass http://127.0.0.1:3000;
  }

• 8b. Save your changes (Ctrl + O) and exit (Ctrl + X)
• 8c. Link your default site to the sites-enabled directory (if not already done):

  sudo ln -s /etc/nginx/sites-available/default /etc/nginx/sites-enabled/default

9. Start nginx

sudo service nginx start

10. Transpile React components using Webpack

npm run build

11. Change directory to the server folder

cd server/

12. Start the Express.js server using the PM2 module

sudo pm2 --name "studentGradeTable" start index.js

13. Open your default web browser and navigate to http://localhost:3000/ to see the result!