supabase_realtime_postgres_changes_subscription_for_table.ts

1import { createClient } from '@supabase/supabase-js'
2
3// Define your types (optional but recommended for TypeScript)
4interface Todo {
5  id: number
6  task: string
7  is_complete: boolean
8}
9
10// Initialize the Supabase client
11const supabaseUrl = 'https://your-project-url.supabase.co'
12const supabaseKey = 'your-anon-key'
13const supabase = createClient(supabaseUrl, supabaseKey)
14
15// Subscribe to changes in the 'todos' table
16const channel = supabase
17  .channel('schema-db-changes')
18  .on(
19    'postgres_changes',
20    {
21      event: '*', // Listen to all events: INSERT, UPDATE, and DELETE
22      schema: 'public',
23      table: 'todos',
24    },
25    (payload) => {
26      console.log('Change received!', payload)
27    }
28  )
29  .subscribe((status) => {
30    if (status === 'SUBSCRIBED') {
31      console.log('Ready to receive real-time changes!')
32    }
33  })