This is a Next.js project bootstrapped with create-next-app.

Getting Started

First, run the development server:

npm run dev
# or
yarn dev
# or
pnpm dev

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

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

API routes can be accessed on http://localhost:3000/api/hello. This endpoint can be edited in pages/api/hello.js.

The pages/api directory is mapped to /api/*. Files in this directory are treated as API routes instead of React pages.

This project uses next/font to automatically optimize and load Inter, a custom Google Font.

Learn More

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.

You can check out the Next.js GitHub repository - your feedback and contributions are welcome!

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.

PSQL:

sudo apt update && sudo apt upgrade -y
sudo apt install postgresql postgresql-contrib
psql

CREATE ROLE cs377_students WITH LOGIN PASSWORD 'cs377_students_password';
CREATE DATABASE demo;
CREATE DATABASE demo3;
GRANT ALL PRIVILEGES ON DATABASE demo TO cs377_students;
GRANT ALL PRIVILEGES ON DATABASE demo3 TO cs377_students;
\q

exit

17 is the current version of my psql, replace it with your own

nano /etc/postgresql/17/main/pg_hba.conf

add this to the end f the file:

host    all             all             0.0.0.0/0               md5

nano /etc/postgresql/17/main/postgresql.conf

listen_addresses = '*'

sudo systemctl restart postgresql  

psql -h 45.55.151.158 -U cs377_students -d demo

Password is: cs377-students-password

Quick Query Examples:

SELECT

SELECT * FROM university.course;

SELECT * 
FROM university.course
WHERE cnum >300
;

SELECT * 
FROM university.course
WHERE name='Software Design'
;

SELECT * 
FROM university.course
WHERE dept='CSC'
;

SELECT * 
FROM university.offering
WHERE dept='CSC' AND instructor='Jepson'
;

SELECT * 
FROM university.student
WHERE cgpa > 3.0
;