supabase/apps/docs/content/guides/realtime/subscribing-to-database-changes.mdx

---
id: 'subscribing-to-database-changes'
title: 'Subscribing to Database Changes'
description: 'Listen to database changes in real-time from your website or application.'
sidebar_label: 'Videos'
---

Supabase allows you to subscribe to real-time changes on your database from your client application.

You can listen to database changes using the [Postgres Changes](/docs/guides/realtime/postgres-changes) extension.
The following video shows how you can enable this feature for your tables.

## Demo

<div className="video-container">
  <iframe
    src="https://www.youtube-nocookie.com/embed/2rUjcmgZDwQ"
    frameBorder="1"
    allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture"
    allowFullScreen
  ></iframe>
</div>

## Setup

You'll first need to create a `supabase_realtime` publication and add your tables (that you want to subscribe to) to the publication:

```sql
begin;

-- remove the supabase_realtime publication
drop
  publication if exists supabase_realtime;

-- re-create the supabase_realtime publication with no tables
create publication supabase_realtime;

commit;

-- add a table called 'messages' to the publication
-- (update this to match your tables)
alter
  publication supabase_realtime add table messages;
```

## Streaming inserts

You can use the `INSERT` event to stream all new rows.

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

const supabase = createClient(process.env.SUPABASE_URL, process.env.SUPABASE_KEY)

const channel = supabase
  .channel('schema-db-changes')
  .on(
    'postgres_changes',
    {
      event: 'INSERT',
      schema: 'public',
    },
    (payload) => console.log(payload)
  )
  .subscribe()
```

## Streaming updates

You can use the `UPDATE` event to stream all updated rows.

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

const supabase = createClient(process.env.SUPABASE_URL, process.env.SUPABASE_KEY)

const channel = supabase
  .channel('schema-db-changes')
  .on(
    'postgres_changes',
    {
      event: 'UPDATE',
      schema: 'public',
    },
    (payload) => console.log(payload)
  )
  .subscribe()
```

## More resources

- Learn more about the [Postgres Changes](/docs/guides/realtime/postgres-changes) extension.
- Client Libraries:
  - [JavaScript](/docs/reference/javascript/subscribe)
  - [Flutter](/docs/reference/dart/stream)
  - [Python](/docs/reference/python/subscribe)
  - [C#](/docs/reference/csharp/subscribe)