I try to deploy a next.js project to amplify, and it's really a disaster:

1. environment variables are not available in run time! I need use grep command to write environment variables to a .env.production file at build command

2. I finally have env var (DATABASE_URL), then there is a no simple way to make it access my RDS database. I search and find something like "override a Lambda VPC configuration..." kind of steps

Totally waste of time!