A high-performance, scalable class seat notification system for university students. Monitor class availability, get notified when seats open up, and track instructor assignments.

Built with vinext (Vite-based Next.js), Supabase, and deployed on Cloudflare Workers for edge performance.

• Seat Monitoring - Track when seats become available in full classes
• Instructor Tracking - Get notified when "Staff" instructors are assigned to specific professors
• Real-time Updates - Dashboard updates live via Supabase Realtime subscriptions
• Email Notifications - Instant email alerts via Resend when changes are detected
• Smart Deduplication - Prevents duplicate notifications using atomic PostgreSQL operations
• Scalable Queue Processing - Handles 10,000+ users with parallel Cloudflare Queues
• 30-Minute Checks - Automated checks via Cloudflare Workers Cron Triggers

We chose Cloudflare Workers as our deployment platform for several compelling reasons:

• Global Distribution: Code runs in 300+ data centers worldwide, ensuring low latency for all users
• No Cold Starts: Workers are always warm, providing consistent sub-100ms response times
• Smart Placement: Automatic routing to the nearest data center

• Generous Free Tier: 100,000 requests/day free, more than enough for most deployments
• Pay-Per-Use: Only pay for actual compute time, not idle servers
• No Infrastructure Management: Zero DevOps overhead

• Cloudflare Queues: Reliable message queue for processing class checks at scale
• Durable Objects: Distributed coordination for circuit breakers and cron locks
• Workers KV: Edge caching for fast data retrieval
• Hyperdrive: Connection pooling for PostgreSQL with automatic optimization

• Automatic Failover: Built-in redundancy across data centers
• DDoS Protection: Enterprise-grade security by default
• 99.99% Uptime SLA: Production-grade reliability

• vinext Compatibility: Deploy apps on Cloudflare Workers via Vite-based build
• Instant Deployments: Sub-second deployments via Wrangler CLI
• Integrated Monitoring: Real-time logs and analytics

User Browser
     |
     v
vinext App (Cloudflare Workers) <---> Supabase (Auth + PostgreSQL + Realtime)
     |
     v
Cloudflare Cron (every 30 min)
     |
     v
Cloudflare Queue (pickmyclass-queue)
     |
     v
Queue Consumers (100+ concurrent Workers)
     |
     v
ASU Class Search API (direct HTTP calls)
     |
     v
Change Detection --> Resend Email API --> User Notifications

CronLockDO - Prevents duplicate cron executions

• Auto-expires after 25 minutes
• Ensures only one cron job runs at a time across all isolates

• Bun (package manager)
• Supabase Account (free tier available)
• Cloudflare Account (free tier available)
• Resend Account (free tier: 100 emails/day)
• ASU API access (configured via ASU_API_BASE_URL and ASU_API_TOKEN)

git clone https://github.com/yourusername/pickmyclass.git
cd pickmyclass
bun install

1. Create a new project at supabase.com
2. Link your local project:

   bunx supabase link --project-ref your-project-id

3. Push database migrations:

   bunx supabase db push

4. Generate TypeScript types:

   bunx supabase gen types typescript --linked > lib/supabase/database.types.ts

Copy .env.example to .env.local:

cp .env.example .env.local

Required variables:

Edit wrangler.jsonc and update the placeholder values:

{
  "vars": {
    "NOTIFICATION_FROM_EMAIL": "[email protected]",
    "NEXT_PUBLIC_SITE_URL": "https://your-domain.com",
    "NEXT_PUBLIC_SUPABASE_URL": "https://your-project-id.supabase.co"
  }
}

Note: ASU_API_BASE_URL and ASU_API_TOKEN are configured as Cloudflare encrypted secrets (not vars) to avoid exposing the API endpoint in source code. Set them via wrangler secret put (see step 5 below).

Optionally configure a custom domain:

```jsonc
{
  "routes": [
    {
      "pattern": "your-domain.com",
      "custom_domain": true
    }
  ]
}

# Authenticate with Cloudflare
wrangler login

# Set secrets (you'll be prompted for values)
wrangler secret put NEXT_PUBLIC_SUPABASE_ANON_KEY
wrangler secret put SUPABASE_SERVICE_ROLE_KEY
wrangler secret put ASU_API_BASE_URL
wrangler secret put ASU_API_TOKEN
wrangler secret put RESEND_API_KEY
wrangler secret put RESEND_WEBHOOK_SECRET
wrangler secret put CRON_SECRET

bun run deploy

Your app will be live at https://your-worker.workers.dev or your custom domain.

Create the required queues in Cloudflare Dashboard:

1. Go to Workers & Pages -> Queues
2. Create pickmyclass-queue
3. Create pickmyclass-dlq (dead letter queue)

The app/legal/ directory contains Terms of Service and Privacy Policy pages with ASU-specific content and hardcoded email addresses ([email protected]). For your deployment:

• Update contact email addresses in:
  • app/legal/page.tsx
  • app/legal/terms/page.tsx
  • app/legal/privacy/page.tsx
• Review and customize legal content for your institution/jurisdiction
• Update the privacy policy to reflect your data practices

• Check the health endpoint: https://your-domain.com/api/monitoring/health
• Verify cron triggers in Cloudflare Dashboard -> Workers -> Triggers
• Test by adding a class watch in the dashboard

bun run dev              # Start dev server (localhost:3000)

bun run preview          # Build with vinext and preview locally

bun run build            # Build application
bun run lint             # Run Biome linter
bun run lint:fix         # Fix lint issues
bun run format           # Format code with Biome
bun run knip             # Find unused exports/dependencies
bun run cf-typegen       # Generate TypeScript types for Cloudflare env

bunx supabase db push                # Push migrations to remote
bunx supabase db pull                # Pull remote schema changes
bunx supabase migration new <name>   # Create new migration

• Frontend: vinext (App Router), React 19, TypeScript, Tailwind CSS 4
• Backend: Cloudflare Workers (via vinext), Supabase (PostgreSQL + Auth + Realtime)
• Data Source: ASU Class Search API (direct HTTP)
• Email: Resend (transactional emails)
• Deployment: Cloudflare Workers + Pages

app/                         # App Router
  ├── api/
  │   ├── class-watches/     # CRUD API for user watches
  │   ├── cron/              # Cloudflare Workers cron handler
  │   ├── queue/             # Queue consumer handlers
  │   └── webhooks/          # Resend webhook handlers
  ├── dashboard/             # Main dashboard with Realtime updates
  ├── login/                 # Authentication pages
  └── layout.tsx             # Root layout

lib/
  ├── supabase/              # Supabase clients (browser, server, service)
  ├── db/                    # Database query helpers
  ├── email/                 # Resend integration + templates
  └── hooks/                 # React hooks (Realtime subscriptions)

components/
  ├── ui/                    # shadcn/ui components
  └── ...                    # Feature components

supabase/
  └── migrations/            # Database migrations

worker.ts                    # Custom Cloudflare Worker
wrangler.jsonc               # Cloudflare Workers config

1. User adds class watch - Student enters section number on dashboard
2. Every 30 minutes - Cloudflare cron triggers enqueue all watched sections
3. Queue consumers process - 100+ Workers query ASU API in parallel
4. Change detection - Compare new state with PostgreSQL cached state
5. Atomic deduplication - PostgreSQL INSERT...ON CONFLICT prevents race conditions
6. Email notification - Resend batch API sends alerts for available seats
7. Real-time update - Dashboard reflects changes via Supabase Realtime

Contributions are welcome! Please see CONTRIBUTING.md for guidelines.

1. Fork the repository
2. Create a feature branch: git checkout -b feature/my-feature
3. Make your changes
4. Run linting: bun run lint:fix
5. Commit with conventional commits: git commit -m "feat: add new feature"
6. Push and open a PR

This project is licensed under the MIT License - see the LICENSE file for details.

• vinext - Vite-based Next.js reimplementation for Cloudflare Workers
• Supabase - Open source Firebase alternative
• Resend - Modern email API
• shadcn/ui - UI component library