[ianpurton]

You didn't say if you'll have a front end.

Supabase works best with single page apps. However a lot of the frameworks are moving towards server side react, so the need for having a rest API is going away.

So I would actually say use nextjs and get an AI such as bolt to generate an MVP.

If you are running AI such as LLM's you need GPU's. LLM's are constrained by memory bandwidth not CPU and GPUS have a ton of memory bandwidth.

Postgres is always a sold choice and RLS is defence in depth anyway.