Ross Duggan

Just spent the last couple of weeks exploring app development with #NextJS + #Supabase and still not sure whether it's brilliant or nightmarish.

Pros:
- #Postgres Row Level Security as a first class feature 😍
- Bundled auth for email/pass, SSO, magic link
- Slick local dev
- #pgvector and support for embeddings via edge functions 🫨

Cons:
- Forward only migrations 😐
- edge functions are Deno-only 🫠
- can only make embeddings with one model 🥲
- Some app logic can only be written in PL/pgSQL 😱

May 9, 2024 at 5:03pmWeb
Show threadVik FearingMay 9, 2024
@duggan
Tell me more about the #plpgsql problem?
Show threadRoss DugganMay 9, 2024

@xocolatl Well, Supabase wraps PostgREST rather than a native connection to Postgres, and does not support transactions at the client level — so when one needs transactions, the workaround is to use stored procedures, which means a good chunk of business logic may end up written in PL/pgSQL.

This may or may not be a good decision, but it is certainly a departure from the norm for many web app developers.

Show threadVik FearingMay 11, 2024
@duggan
Ah. Yes, that is an unfortunate “feature” of Supabase.