- TypeScript
- Next.js
- Express.js
- NextUI
- Tailwind
- PostgreSQL
Go to backend
folder and run psql umd < umd.pgsql
- Create a database called
umd
- Create a table called
users
with the following columns:username character varying(44)
- Set this as unique
firstname character varying(48)
lastname character varying(55)
user_id integer NOT NULL
- Set this to primary key
- This is the serial
Full SQL:
CREATE TABLE IF NOT EXISTS public.users
(
username character varying(44) COLLATE pg_catalog."default",
firstname character varying(48) COLLATE pg_catalog."default",
lastname character varying(55) COLLATE pg_catalog."default",
user_id integer NOT NULL DEFAULT nextval('users_user_id_seq'::regclass),
CONSTRAINT users_pkey PRIMARY KEY (user_id),
CONSTRAINT username_uniq UNIQUE (username)
)
TABLESPACE pg_default;
ALTER TABLE IF EXISTS public.users
OWNER to dummy;
If user is not dummy
and database name is not umd
, go to backend/db.js
and change the following code:
const db = new Pool({
user: "dummy", // change this line
database: "umd", // change this line
host: "localhost",
port: 5432,
});
Run both backend and frontend.
- Inside of the
backend
folder donpm install
- Then do
nodemon index.js
ornode index.js
- Inside of the
frontend
folder donpm install
- Then do
npm run dev