supabase.realtime.filters — io.github.supabase-community/realtime 1.3.0

Fluent builder for postgres_changes filter strings.

Each fn appends one column=operator.value condition; conditions are joined with commas, which the Realtime server applies as AND (OR is not supported). Pass the builder straight to supabase.realtime/on — it is serialized to a string automatically — or call build yourself.

Mirrors realtime-js RealtimePostgresFilterBuilder: the operator surface is the PostgREST subset the Realtime server evaluates (containment, range and full-text operators are intentionally absent), values containing reserved characters (, ( ) " \) or surrounding whitespace are double-quoted and escaped the way PostgREST does, and any operator can be negated with not.

(require '[supabase.realtime.filters :as f])

(-> (f/gt "amount" 100)
    (f/not "status" :in ["draft" "archived"]))
;; builds: amount=gt.100,status=not.in.(draft,archived)

build clj

(build builder)

Serializes builder into the comma-separated (AND) filter string. An empty builder serializes to "", which the server treats as no filter.

eq clj

Rows where column equals value (column=eq.value).

gt clj

Rows where column is greater than value (column=gt.value).

gte clj

Rows where column is greater than or equal to value (column=gte.value).

ilike clj

Rows where column matches the case-insensitive pattern.

imatch clj

Rows where column matches the case-insensitive POSIX regex pattern (~*).

in clj

(in column values)

(in builder column values)

Rows where column is one of values (column=in.(a,b,c)). Duplicates are removed; at least one value is required; nil elements are rejected (use is for null checks).

is clj

(is column value)

(is builder column value)

Rows where column IS the given value (column=is.null). Accepts nil, a boolean, or :null/:true/:false/:unknown (keywords or strings).

isdistinct clj

Rows where column is distinct from value — NULL-safe inequality (IS DISTINCT FROM).

like clj

Rows where column matches the case-sensitive pattern (% wildcards).

lt clj

Rows where column is less than value (column=lt.value).

lte clj

Rows where column is less than or equal to value (column=lte.value).

match clj

Rows where column matches the POSIX regex pattern (~).

neq clj

Rows where column does not equal value (column=neq.value).

not clj

(not column operator value)

(not builder column operator value)

Negates any operator with the not. prefix (column=not.operator.value).

(f/not "status" :in ["draft" "archived"]) ;; builds: status=not.in.(draft,archived)

(f/not "deleted_at" :is nil) ;; builds: deleted_at=not.is.null