Database trigger VS API trigger - which you think is better?

Hey all!

I have a bunch of actions I want to run whenever a user signs up for my app. I wonder if its better to run this via database trigger or to trigger this for the actual API that runs when a user signs up

Are there pros and cons worth considering?

Thanks!