Quiz App - Next.js Website with Clerk, PostgreSQL (Docker), and Prisma

A full stack Next.js application with user authentication via Clerk, database management with PostgreSQL, and Prisma ORM. The project uses PostgreSQL database from Docker for easy local development. Users can sign up, create quizzes, and attempt them.

Features

• Next.js 13+ (App Router)
• Authentication with Clerk
• PostgreSQL database running in Docker
• Prisma for database modeling and querying
• Environment variables for secure configuration
• Docker Compose for running DB

---

Prerequisites

• Node.js 18+
• npm package manager
• Docker Desktop
• Clerk account

---

Setup

Clone the repository

git clone <your-repo-url>
cd <your-repo-folder>
npm i

---

Add Details In .env

DB_URL="postgresql://user:mypassword@localhost:5432/quiz"
NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY=<your publishable key>
CLERK_SECRET_KEY=<your clerk secret key>
NODE_ENV='production'

---

Generating Prisma Client

npx prisma generate

---

Starting Frontend

npm run dev

---

Starting Backend

docker compose up

---

Some useful commands

To check tables in database: npx prisma studio
To stop database: docker compose down