Postgres Changes gets AND filters, new operators, and column selection

Supabase has expanded Postgres Changes, its WebSocket-based system for receiving real-time insert, update, and delete events, with multi-column filtering, additional filter operators, and optional column selection. Filters can now combine multiple conditions with AND logic, enabling subscriptions such as tickets that are both open and assigned to a particular team, while new operators support patterns, null or boolean checks, regular expressions, NULL-safe inequality, and negation; a JavaScript filter builder is also available. Column selection allows subscribers to receive only needed fields, although primary keys are always included, reducing payload size and potentially lowering Realtime message and egress costs. Existing subscriptions remain unchanged unless these options are added, column selection requires supabase-js version 2.109.0 or later, and role permissions and Row Level Security continue to apply. OR logic, array and JSON containment, full-text search, and range operators are not currently supported, while DELETE events cannot use column filters because they only provide primary keys.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.