Waitlist-For-Saas — Next.js SaaS模板

SHA-256: a458e67dd5e0e4a331d9389559ea0c19fb5aa98467c9994fc1e360e84c754f39

2026-10-14T11:41:55.337Z

# Quick Setup Guide

## First Time Setup

Before using this app, you NEED to create the database table in Supabase:

### Option 1: Using Supabase Dashboard (Recommended - 1 minute)

1. Go to [Supabase SQL Editor](https://supabase.com/dashboard/project/_/sql)
2. Paste the SQL below and click "Run"
3. And you're DONE!

```sql
CREATE TABLE IF NOT EXISTS "Email collection" (
  id BIGSERIAL PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_email_collection_email ON "Email collection"(email);

ALTER TABLE "Email collection" ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Allow public insert" ON "Email collection"
  FOR INSERT TO anon WITH CHECK (true);

CREATE POLICY "Allow public select" ON "Email collection"
  FOR SELECT TO anon USING (true);

GRANT INSERT, SELECT ON "Email collection" TO anon;
GRANT USAGE, SELECT ON SEQUENCE "Email collection_id_seq" TO anon;
```

### Option 2: Using Setup Script (If you have service role key)

1. Add `SUPABASE_SERVICE_ROLE_KEY` to your `.env.local`
2. Run: `node setup-database.js`
3. Done

---

## Environment Variables Required

Make sure your `.env.local` has:

```bash
NEXT_PUBLIC_SUPABASE_URL=your_supabase_url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your_anon_key
UPSTASH_REDIS_REST_URL=your_redis_url
UPSTASH_REDIS_REST_TOKEN=your_redis_token
```

---

## After Setup

1. Run `yarn install`
2. Run `yarn dev`
3. Visit `http://localhost:3000`
4. Test the email subscription form!!

---

## Troubleshooting

**Error: "Could not find the table"**
- Run the SQL above in your Supabase SQL Editor

**Error: "Database not set up"**
- The table doesn't exist. Follow Option 1 above.

**Rate limiting errors**
- Check your Redis credentials in `.env.local`

Enjoyyy!