qweerky

Your favorite music suggestions app

Assumptions before setup (macOS)

Homebrew is installed along with npm and postgresql

• Install command located in: [https://brew.sh/]
• Brew is used to install npm & postgresql

brew install nvm
nvm install 16.9.1
brew install postgresql@14

Assumptions before setup (Windows)

PostgreSQL (14) is installed

• [https://www.postgresql.org/download/]

npm (7.21.1) & Node (v16.9.1) is installed with NVM

• [https://docs.npmjs.com/downloading-and-installing-node-js-and-npm]

Switching Node versions with nvm

nvm use 16

Switching npm versions

npm install -g [email protected]

Check Requirements

Note: brew only needs to be installed on macOS

npm --version
  - (7.21.1)
node --version
  - (v16.9.1)
brew --version
  - Homebrew 3.4.1
psql --version
  - (psql (PostgreSQL) 14.2)

Install Dependencies (/qweerky & /qweerky/backend)

npm i --save
cd backend/
npm i --save

Creating a Postgres database

• Paths and commands will be different for you, here's an example:

sudo chmod a+w /var/run/postgresql
export PATH=$PATH:/usr/lib/postgresql/14/bin/
export PGPORT=8888
export PGHOST=/tmp
initdb $HOME/db412
pg_ctl -D $HOME/db412 -o '-k /tmp' start
createdb qweerky

Connect to the created database and create role

psql -d qweerky
CREATE ROLE qweerky WITH LOGIN PASSWORD 'root';
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO qweerky;
\q

Add tables to created database (/qweerky/setup-backend)

In setup-backend please modify following in the (/qweerky/setup-backend/makefile):

MAKEFILE_PATH = /home/pi/dev/CSE-412/qweerky/setup-backend

• MAKEFILE_PATH = your/path

Also in setup-backend, please modify following in (/qweerky/setup-backend/setup_postgres/import_data.sql):

COPY song FROM '/home/pi/dev/CSE-412/qweerky/setup-backend/data/songs.csv' DELIMITER ',' CSV HEADER;

• COPY song FROM 'your/path' DELIMITER ',' CSV HEADER;

Then, run the following command in (/qweerky/setup-backend):

make setup_postgres

Running Locally (/qweerky)

First, run the Node.js development server:

node backend/index.js

Open http://localhost:3001 with your browser to see the backend-end result.

Then, open another terminal and run Next.js development server:

npm run dev
# or
yarn dev

Open http://localhost:3000 with your browser to see the front-end result.

Credit

• [https://blog.logrocket.com/getting-started-with-postgres-in-your-react-app/]
• [https://blog.logrocket.com/nodejs-expressjs-postgresql-crud-rest-api-example/]

Extras

You can start editing the page by modifying pages/index.js. The page auto-updates as you edit the file.

To learn more about Next.js, take a look at the following resources:

• Next.js Documentation - learn about Next.js features and API.
• Learn Next.js - an interactive Next.js tutorial.