- following commands needs to be done in each server and client directory once
npm install
for the node package managernpm install pm2@latest
for the process manager we use
- cd into server directory
- use
pm2 start server.js
to start the server on pm2
- cd into server directory
npm install
to install dependencies (only need to do once)- use
npm start
to run client
- get to psql shell (instructions below)
CREATE DATABASE capstonefinalproject;
(CAPS for psql defined commands is convention and NOT mandatory, "capstonefinalproject" is dbname(name it whatever you want), and ";" is at the end of psql commands)\c capstonefinalproject
in the psql console to connect to the capstonefinalproject database- go to server directory and find database.sql
- copy and paste
CREATE TABLE
with everything in parentheses and run the command. This will create the table for each of the elements we need
- Get psql version 15.2
https://www.linuxtechi.com/how-to-install-postgresql-on-ubuntu/#:~:text=PostgreSQL%2015%20package%20is%20not,package%20repository%20using%20following%20commands
- Stop after step 2 (beginning of step 3)
- Check status of db =
sudo service postgresql status
- Start running database =
sudo service postgresql start
- Stop running database =
sudo service postgresql stop
sudo service postgresql start
sudo -u postgres psql
(postgresql database must be running aka use above command first or check status to see if its running)
- to quit psql shell =
\q
- to connect to database =
\c dbname
More psql commands belowhttps://www.geeksforgeeks.org/postgresql-psql-commands/
sudo passwd postgres
- Enter new password
- restart terminal
More postgres details below
https://learn.microsoft.com/en-us/windows/wsl/tutorials/wsl-database#install-postgresql
- cd into client directory
- use
npm build
to build client - use
pm2 serve build 8080
in client folder to host built site on port 8080