Supabase setup
Supabase gives you a hosted PostgreSQL database plus auth and an auto-generated API. Create a project, add tables in the dashboard, and query them from your app with the supabase-js client.
npm install @supabase/supabase-js
# .env.local
NEXT_PUBLIC_SUPABASE_URL=https://xyz.supabase.co
NEXT_PUBLIC_SUPABASE_ANON_KEY=your_anon_key
// lib/supabase.ts
import { createClient } from "@supabase/supabase-js"
export const supabase = createClient(
process.env.NEXT_PUBLIC_SUPABASE_URL!,
process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY!
)
// Query
const { data, error } = await supabase.from("posts").select("*")