supabase-cache-helpers icon indicating copy to clipboard operation
supabase-cache-helpers copied to clipboard

Subscribing to updates on a join table

Open imownbey opened this issue 11 months ago • 2 comments

This is more of a question, but I am trying to subscribe to updates on a join table to add a row to a able. So if theres a table of "message_recipients" with message_id and user_id, and I have list showing all of a users messages, I want to subscribe to new messages to that user and update the list. I understand using useSubscriptionWithQuery to query for nested releationships when a subscription happens, but I do not know how I can update a list with that subscription.

imownbey avatar Mar 17 '24 22:03 imownbey

Hey @imownbey , did you ever happen to figure this out?

pranavbadami avatar Sep 25 '24 20:09 pranavbadami

Can you provide a code sample?

psteinroe avatar Sep 25 '24 21:09 psteinroe