Here are the two other options I'm considering for app, but I want to understand if Supabase is a more efficient alternative. Thanks for help!
First way: (low cost)
VPS server on DigitalOcean
Setup node server and nginx
API and frontend managed by pm2 and serve through nginx as proxy
Setup managed PostgreSQL at DigitalOcean
Second Way:
React app on AWS Amplify/Heroku
Lambda/Serverless node API in aws
PostgreSQL at aws
First way: (low cost) VPS server on DigitalOcean Setup node server and nginx API and frontend managed by pm2 and serve through nginx as proxy Setup managed PostgreSQL at DigitalOcean
Second Way: React app on AWS Amplify/Heroku Lambda/Serverless node API in aws PostgreSQL at aws