[Live Project: https://url-shortner-sooty-delta.vercel.app/]

URL Shortener is a modern full-stack web app to create, manage, and share short links. It includes secure JWT authentication, custom short codes, a responsive dashboard UI, and an Owner Admin Dashboard to view platform metrics and activity.

• 🧩 Enhanced frontend dashboard with user profile card and quick logout
• 🟢 Google Sign-In flow using Google Identity Services (/user/google/config, /user/google)
• 👑 Owner-only admin analytics panel with user counts, link counts, and latest URL activity
• 🪪 GET /user/me now returns isOwner to enable role-based UI rendering

• 🔐 Email/password signup and login
• 🟢 Google Sign-In (login/signup via Google account)
• ✂️ Create short links from long URLs
• 🏷️ Optional custom short code while creating links
• 📋 View all your created links
• 🗑️ Delete your own links
• 📱 Responsive UI (Bootstrap + TailwindCSS)

• 🧾 Owner-only dashboard visibility (based on OWNER_EMAIL)
• 📊 Platform summary: total users + total links
• 👥 User table with per-user link count
• 🕒 Recent links feed with owner email
• 🔒 Protected admin API (/admin/overview)

• 🧠 REST API with Express
• 🗄️ PostgreSQL + Drizzle ORM
• 🔑 JWT auth middleware (Authorization: Bearer <token>)
• ✅ Input validation with Zod
• ↪️ Redirect short code to original target URL

• Backend: Node.js, Express, PostgreSQL, Drizzle ORM, JWT, Zod
• Frontend: HTML, Bootstrap 5, TailwindCSS, Vanilla JavaScript
• Auth: Email/Password + Google Identity Services
• Tools: Docker Compose, PNPM, Drizzle Kit

git clone <your-repo-url>
cd URL_Shortner
pnpm install

docker compose up -d

Create or update .env:

DATABASE_URL=postgres://postgres:admin@localhost:5432/postgres
PORT=8000
JWT_SECRET=your_jwt_secret
OWNER_EMAIL=your_owner_email@example.com
GOOGLE_CLIENT_ID=your_google_client_id.apps.googleusercontent.com

GOOGLE_CLIENT_ID is required only if you want Google Sign-In enabled.

pnpm db:push

pnpm dev

Open: http://localhost:8000

Make sure your latest changes are pushed to your repository.

• Go to Vercel Dashboard
• Click Add New Project
• Select this GitHub repository

• Framework Preset: Other
• Install Command: pnpm install
• Build Command: (leave empty)
• Output Directory: (leave empty)

Set these in Project Settings → Environment Variables:

• DATABASE_URL
• JWT_SECRET
• OWNER_EMAIL
• GOOGLE_CLIENT_ID (optional if Google Sign-In is used)

PORT is managed by Vercel automatically.

Run this against your hosted PostgreSQL database:

pnpm db:push

Add your Vercel domain to Google OAuth Authorized JavaScript origins, for example:

• https://your-project.vercel.app

1. Open Google Cloud Console: https://console.cloud.google.com/
2. Create OAuth Client ID (Web application)
3. Add Authorized JavaScript origin:
   • http://localhost:8000
4. Copy the generated Client ID into .env as GOOGLE_CLIENT_ID
5. Restart the app

• POST /user/signup
• POST /user/login
• POST /user/google
• GET /user/google/config
• GET /user/me (auth required)

• POST /shorten (auth required)
• GET /codes (auth required)
• DELETE /:id (auth required)
• GET /:shortcode (public redirect)

• GET /admin/overview (auth + owner email match)

URL_Shortner/
├── api/
│   └── index.js
├── db/
├── middleware/
├── model/
├── public/
│   ├── app.js
│   ├── index.html
│   └── styles.css
├── routes/
├── services/
├── utils/
├── validation/
├── docker-compose.yml
├── drizzle.config.js
├── index.js
├── package.json
├── server.js
├── vercel.json
└── README.md

This project is licensed under the ISC License.

For support or contributions, please open an issue or pull request in this repository.