@vercel/postgres Document the use of LISTEN and NOTIFY (if at all possible).

[romeovs]

The documentation states full compatibility with postgres, does this include LISTEN/NOTIFY?

The Neon docs mention LISTEN/NOTIFY and it works from psql so I would assume we can use them, but I see no clear way to call these commands from the SDK.

import { sql } from "@vercel/postgres"

const res = await sql`LISTEN foo`
console.log(res)
// This immediately returns
// {
//   command: "LISTEN",
//   fields: [],
//   rowAsArray: false,
//   rowCount: null,
//   rows: [],
//   viaNeonFetch: true
// }

Is this feature supported, and if so, what are the limitations.

If not, can we clarify that in the docs?

[abhishekchouhannk]

Hi remeovs, were you able to figure this out?
I too have been in a bind, struggling with trying to get my vercel/postgres to send a notification to my node.js app hosted on a different domain.

However, none of the methods I tried seemed to work.

[vvo]

@romeovs, I'm not sure if you got an answer elsewhere, but given the nature of serverless, it would seem that listen/notify could behave strangely, as "clients" could connect and disconnect anytime in a much more random way than traditional servers/clients.

What was your usecase for listen/notify in the context of your application? good luck