Supabase

Example: Blog App
- users (id, email, name, avatar)
- posts (id, title, content, author_id, created_at)
- comments (id, post_id, user_id, text)

Create a database table for blog posts with title,
content, author, and published date

-- Users can only read their own data
CREATE POLICY "Users read own data"
ON users FOR SELECT
USING (auth.uid() = id);

-- Users can only update their own posts
CREATE POLICY "Authors update posts"
ON posts FOR UPDATE
USING (auth.uid() = author_id);

Add user authentication with email signup and Google login

import { createClient } from '@supabase/supabase-js';

const supabase = createClient(url, key);

// Sign up
const { data, error } = await supabase.auth.signUp({
  email: '[email protected]',
  password: 'securepassword'
});

// Sign in
const { data, error } = await supabase.auth.signInWithPassword({
  email: '[email protected]',
  password: 'securepassword'
});

// Get current user
const { data: { user } } = await supabase.auth.getUser();

// Sign out
await supabase.auth.signOut();

// Upload file
const { data, error } = await supabase.storage
  .from('avatars')
  .upload('public/avatar.png', file);

// Get public URL
const { data } = supabase.storage
  .from('avatars')
  .getPublicUrl('public/avatar.png');

// Subscribe to changes
const subscription = supabase
  .channel('posts')
  .on('postgres_changes', {
    event: '*',
    schema: 'public',
    table: 'posts'
  }, (payload) => {
    console.log('Change:', payload);
  })
  .subscribe();

// supabase/functions/hello/index.ts
Deno.serve(async (req) => {
  const { name } = await req.json();
  return new Response(
    JSON.stringify({ message: `Hello ${name}!` }),
    { headers: { 'Content-Type': 'application/json' } }
  );
});

Add a "likes" column to the posts table

Create a table for storing user notifications