Should I be using onPostgresChange for realtime updates?
Title. It seems that people heavily discourage it online and say to use broadcast instead. I am developing an iOS app fyi.
4 Replies
Supabase recommends using broadcast channels with security and the database trigger to send them on changes.
Will the onPostgresChange be updated in the future to not be as flaky? Also, is broadcast ever flaky?
Not sure what you mean by flaky. I don't think they will do much with postgres changes as it is a resource hog on the database and performance drops quickly with lots of users.
There is no difference though in the realtime connections and things you have to deal with if channel errors.
Ok sounds good, thanks for the help!