Postgres Changes just got more capable. We're shipping three improvements: filters that combine across multiple columns, more filter operators, and column selection so a subscription returns only the fields you ask for. All three are available now.
Postgres Changes lets you subscribe to inserts, updates, and deletes on a Postgres table and receive them over a WebSocket as they happen.
A support inbox is a good example. You want a live view of the tickets that are open and assigned to your team, and nothing else. Until now a filter could only look at one column, so you could match on status or on team, but not both at once. The workaround was to subscribe to every open ticket in the table and drop the ones for other teams once they reached your app.
Filters now compose. Separate them with a comma and every condition has to match:
_13supabase_13 .channel('team-inbox')_13 .on(_13 'postgres_changes',_13 {_13 event: 'UPDATE',_13 schema: 'public',_13 table: 'tickets',_13 filter: 'status=eq.open,team=eq.billing',_13 },_13 (payload) => console.log(payload)_13 )_13 .subscribe()
