小白快速出海上站指南：Vercel + Supabase 先上个站再说

这是supabase的api文档https://supabase.com/docs/guides/api/api-keys

Project URL：xxxAPI Key：xxx
示例代码
import { createClient } from '@supabase/supabase-js'
const supabaseUrl = 'https://okqxrigpjgoncvoflenz.supabase.co'const supabaseKey = process.env.SUPABASE_KEYconst supabase = createClient(supabaseUrl, supabaseKey)

# 在本地编写/修改代码# 测试功能# 提交到GitHubgit add .git commit -m "添加Supabase集成"git push origin main

更新代码 → 推送到GitHub → Vercel自动部署不需要手动更新Supabase和Vercel（环境变量配置一次即可）

-- 创建愿景表CREATE TABLE IF NOT EXISTS public.visions (    id UUID DEFAULT gen_random_uuid() PRIMARY KEY,    user_id TEXT NOT NULL DEFAULT 'public_user',    content TEXT NOT NULL,    enhanced_text TEXT,    image_url TEXT,    image_prompt TEXT,    manifestation_count INTEGER DEFAULT 0 NOT NULL,    category TEXT DEFAULT 'general',    status TEXT DEFAULT 'active' CHECK (status IN ('active', 'completed', 'archived', 'withdrawn')),    metadata JSONB DEFAULT '{}'::jsonb,    created_at TIMESTAMP WITH TIME ZONE DEFAULT TIMEZONE('utc'::text, NOW()) NOT NULL,    updated_at TIMESTAMP WITH TIME ZONE DEFAULT TIMEZONE('utc'::text, NOW()) NOT NULL);
-- 创建索引CREATE INDEX IF NOT EXISTS visions_user_id_idx ON public.visions(user_id);CREATE INDEX IF NOT EXISTS visions_created_at_idx ON public.visions(created_at DESC);
-- 更新时间触发器CREATE OR REPLACE FUNCTION public.handle_updated_at()RETURNS TRIGGER AS $$BEGIN    NEW.updated_at = TIMEZONE('utc'::text, NOW());    RETURN NEW;END;$$ LANGUAGE plpgsql;
CREATE TRIGGER handle_visions_updated_at    BEFORE UPDATE ON public.visions    FOR EACH ROW EXECUTE FUNCTION public.handle_updated_at();
-- 启用RLSALTER TABLE public.visions ENABLE ROW LEVEL SECURITY;
-- RLS策略CREATE POLICY "公共用户可读" ON public.visions    FOR SELECT USING (user_id = 'public_user' AND status != 'withdrawn');
CREATE POLICY "公共用户可写" ON public.visions    FOR INSERT WITH CHECK (user_id = 'public_user');
CREATE POLICY "公共用户可更新" ON public.visions    FOR UPDATE USING (user_id = 'public_user');
CREATE POLICY "公共用户可删除" ON public.visions    FOR DELETE USING (user_id = 'public_user');
-- 权限GRANT SELECT, INSERT, UPDATE, DELETE ON public.visions TO anon;