PitHouse Presets

A community site for browsing and downloading Moza sim racing wheel presets, built with Next.js, Supabase, and Tailwind CSS. Deployed for free on Vercel.

---

First-time setup

1. Create a Supabase project

1. Go to supabase.com and create a free account + new project.
2. Open the SQL Editor and run the contents of supabase-setup.sql to create the tables and helper function.
3. Go to Storage → New bucket, name it presets, and leave it as private.
4. In the storage bucket, go to Policies and add a policy for the service role:
   • Name: Service role full access
   • Operations: ALL
   • Role: service_role

2. Configure environment variables

cp .env.local.example .env.local

Then fill in all four values in .env.local:

Variable	Where to find it
NEXT_PUBLIC_SUPABASE_URL	Supabase → Settings → API → Project URL
NEXT_PUBLIC_SUPABASE_ANON_KEY	Supabase → Settings → API → anon public key
SUPABASE_SERVICE_ROLE_KEY	Supabase → Settings → API → service_role key
ADMIN_PASSWORD	Choose anything — this is what you type at /admin
ADMIN_SECRET	A long random string — run openssl rand -hex 32

3. Run locally

npm install
npm run dev

Open http://localhost:3000.

---

Deploy to Vercel

1. Push the project to a GitHub repository.
2. Go to vercel.com, import the repo, and deploy.
3. In Vercel → your project → Settings → Environment Variables, add all five variables from .env.local.
4. Redeploy once the variables are saved.

---

Site structure

Route	Description
/	Public browse page — search, filter, download
/preset/[id]	Preset detail page with rating widget
/admin	Admin login
/admin/upload	Upload a new preset file
/admin/presets	Edit or delete existing presets

---

Adding new wheelbases or games

Open lib/types.ts and add entries to the WHEELBASES or GAMES arrays. They'll automatically appear in all dropdowns and filters.

---

Tech stack

• Next.js 16 (App Router, TypeScript)
• Tailwind CSS v3
• Supabase (PostgreSQL + Storage)
• Vercel (hosting + serverless functions)

---

Cloudflare Turnstile (CAPTCHA for public uploads)

The public /upload page is protected by Cloudflare Turnstile, which is free with no usage limits.

1. Go to dash.cloudflare.com and sign up / log in
2. Navigate to Turnstile in the left sidebar
3. Click Add site
4. Give it a name (e.g. "PitHouse Presets"), enter your domain, choose Managed widget type
5. Copy the Site Key → NEXT_PUBLIC_TURNSTILE_SITE_KEY in your .env.local
6. Copy the Secret Key → TURNSTILE_SECRET_KEY in your .env.local
7. Add both keys to Vercel's environment variables when deploying

For local development, Turnstile provides a set of dummy keys that always pass — use 1x00000000000000000000AA as the site key and 1x0000000000000000000000000000000AA as the secret key in .env.local only.