supabase.postgrest — io.github.supabase-community/postgrest 1.1.0

Idiomatic Clojure builder for the PostgREST API.

Builds a request map via thread-first, then execute runs it through supabase.core.http and returns either a response or an anomaly.

Quick start

(require '[supabase.core.client :as sc]
         '[supabase.postgrest :as pg])

(def client (sc/make-client "https://abc.supabase.co" "anon-key"))

;; SELECT
(-> (pg/from client "users")
    (pg/select "*")
    (pg/eq "active" true)
    (pg/order "created_at")
    (pg/limit 10)
    (pg/execute))

;; INSERT
(-> (pg/from client "users")
    (pg/insert {:email "[e-mail]"})
    (pg/execute))

;; UPDATE filtered
(-> (pg/from client "users")
    (pg/eq "id" 42)
    (pg/update {:name "Jane"})
    (pg/execute))

;; DELETE filtered
(-> (pg/from client "users")
    (pg/eq "id" 42)
    (pg/delete)
    (pg/execute))

;; RPC
(-> (pg/rpc client "my_function" {:arg 1})
    (pg/execute))

See sub-namespaces for the full API:

• supabase.postgrest.filters — eq / gt / like / contains / and / or / not / ...
• supabase.postgrest.query — select / embed / insert / upsert / update / delete / rpc / aggregations
• supabase.postgrest.transform— order / limit / range / single / csv / explain / returning / ...
• supabase.postgrest.encode — pg-array / pg-range / pg-bool / ->iso (type coercion helpers)

all-of clj

any-of clj

avg clj

contained-by clj

contains clj

count clj

csv clj

delete clj

embed clj

eq clj

execute clj

(execute req)

Runs the built request. Returns {:status :body :headers} or an anomaly enriched with PostgREST error metadata.

execute-async clj

(execute-async req)

Async variant of execute. Returns a CompletableFuture resolving to the same value execute would, with PostgREST error enrichment applied.

The future is cancellable: (future-cancel fut) aborts the in-flight request (see supabase.core.http/execute-async). Wire it to a core.async channel or any external cancel signal:

(let [fut (-> (pg/from c "big_table") (pg/select "*") (pg/execute-async))]
  ;; on some signal:
  (future-cancel fut))

explain clj

filter clj

from clj

(from c table)

Starts a builder bound to table. Returns a request map you can thread through filters / verbs / transforms before calling execute. Returns an anomaly if the client is invalid.

geojson clj

gt clj

gte clj

ilike clj

ilike-all-of clj

ilike-any-of clj

insert clj

is clj

like clj

like-all-of clj

like-any-of clj

limit clj

lt clj

lte clj

match clj

max clj

maybe-single clj

min clj

negate clj

neq clj

order clj

overlaps clj

range clj

range-adjacent clj

range-gt clj

range-gte clj

range-lt clj

range-lte clj

returning clj

rollback clj

rpc clj

schema clj

(schema req new-schema)

Override the schema used for THIS request only. Defaults to the client's :db :schema.

select clj

single clj

sum clj

text-search clj

update clj

upsert clj

with-custom-media-type clj

(with-custom-media-type req media-type)

Override the accept header via a media-type keyword.

Valid keys: :default, :csv, :json, :openapi, :postgis, :pgrst-plan, :pgrst-object, :pgrst-array.

within clj