3 ms·
Postgres has LISTEN and NOTIFY. People build DIY pub-sub with this.
by pornel 5y ago
Postgres has LISTEN and NOTIFY. People build DIY pub-sub with this.
- nicoburns 5y agoSure, but it's a very manual process. I want to be able to write an artbitrary SQL query (or subset of SQL query), and have the subscription aspect "just work".
- acjohnson55 5y agoMaterialize.io does something like this, although in a separate system from Postgres, and I'm not sure it's possible to push live queries to a client.