Hi Supabase team,
I’m a regular Supabase user and I recently came across Prisma’s new/updated transactions features ($transaction, interactive transactions, batch operations, etc.).
Here : https://www.prisma.io/docs/orm/prisma-client/queries/transactions.
I would really love to have a similar high-level transactions API directly in supabase-js, without having to rely on custom SQL/RPC functions to orchestrate transactions at the database level.
Are you planning to introduce a transaction API in supabase-js (for example, a way to group multiple operations into a single atomic transaction, or even a callback-style API similar to Prisma’s interactive transactions)?
If so, is this already on your roadmap or under discussion, and are there any public GitHub issues or resources I can follow for updates?
Thanks a lot for your work on Supabase and for any insight you can share about this.
Best regards,
A user requests a high-level transactions API in supabase-js similar to Prisma's, to avoid using custom SQL/RPC functions. They ask if such a feature is planned or discussed and seek resources for updates.
That would need to be done in PostgREST and have not seen any movement there. https://github.com/PostgREST/postgrest/issues/286#issuecomment-2094226935
This is mainly a user helping user site and your post likely won't be seen by Supabase staff.