Supabase
Read post

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

Supabase's Postgres Changes feature now supports three new capabilities: AND-combined multi-column filters (using comma-separated conditions), additional filter operators including like, ilike, is, match, imatch, and isdistinct (with not. prefix for inversion), and column selection so subscriptions only return specified fields. The primary key is always included in payloads. Column selection requires supabase-js 2.109.0+. Both improvements reduce billable message and egress costs. OR composition, array/JSON containment, full-text search, and range operators are not yet supported.

    #backend#postgresql#supabase#websocket
Aug 05•3m read time•From supabase.com
Post cover image
Table of contents
Filter on more than one column #More filter operators #Select which columns you receive #What this does to your usage #Things to know #What's not supported yet #Get started #
47.9K Impressions
Supabase's image
Supabase

The Supabase Blog offers insights, tutorials, and updates on Supabase, an open-source alternative to...

902 Followers

•

3.8K Upvotes

Would you recommend this post?

Copy link
WhatsApp
Facebook
X
New Squad
  • © 2026 Daily Dev Ltd.
  • Guidelines
  • Explore
  • Tags
  • Sources
  • Squads
  • Leaderboard