Supabase Basics Cheat Sheet

# Install the Supabase CLInpm install -g supabase# Log in and link a local project to your Supabase projectsupabase loginsupabase initsupabase link --project-ref <your-project-ref># Start the local dev stack (Postgres, Studio, Auth, Storage) in Dockersupabase start# Generate a migration from schema changes and push itsupabase db diff -f add_orders_tablesupabase db push

-- Create a tablecreate table public.orders (  id uuid primary key default gen_random_uuid(),  user_id uuid references auth.users not null,  amount numeric not null,  created_at timestamptz default now());-- RLS must be enabled before any policy takes effectalter table public.orders enable row level security;-- Users can only see their own orderscreate policy "Users can view their own orders"  on public.orders for select  using (auth.uid() = user_id);-- Users can only insert orders for themselvescreate policy "Users can insert their own orders"  on public.orders for insert  with check (auth.uid() = user_id);

import { createClient } from '@supabase/supabase-js'const supabase = createClient(  process.env.SUPABASE_URL,  process.env.SUPABASE_ANON_KEY)// Sign in a userconst { data: authData, error: authError } =  await supabase.auth.signInWithPassword({ email, password })// Query data (RLS policies apply automatically for the logged-in user)const { data, error } = await supabase  .from('orders')  .select('id, amount, created_at')  .order('created_at', { ascending: false })  .limit(10)// Insert a rowawait supabase.from('orders').insert({ amount: 49.99 })// Subscribe to realtime changessupabase  .channel('orders-changes')  .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'orders' },    (payload) => console.log('New order:', payload.new))  .subscribe()