[kiwicopple]

supabase does support transactions through RPC calls - I think you already understood that based on your comment but want to make the distinction clear for other readers

I can completely understand if you don't to write everything in pgpsql though. Did you also try the Deno Functions?

We've been brainstorming ways to support transactions directly from the client libs in a way that won't lock up the database if there is a network failure between database operations. It seems doable, but not something we want to rush.

[crooked-v]

Well, the simple case is to start with transactions with only queries that aren't dependent on each other, which would cover a vast majority of cases by itself - client sends an array of queries as a single network call, gets either an array back of results or a failure state.

[msdrigg]

I will give deno functions a look -- I haven't really looked into them.

And for the record I am still loving supabase overall. PostgREST works for 90% of what I want to do and I can spin up a simple stateless backend to support the other 10%.