This demo uses AWS Aurora PostgreSQL with Next.js to fetch movies from the database. It is able to securely connect to Aurora PostgreSQL without using hardcoded access tokens through Vercel's OIDC Federation and RDS IAM authentication.

Demo: TK

• Aurora PostgreSQL cluster with IAM authentication enabled
• Database user with rds-db-connect permission
• AWS IAM role configured for RDS access

1. Create .env.local file with required environment variables:

AWS_ROLE_ARN=arn:aws:iam::YOUR_ACCOUNT:role/YOUR_ROLE DB_CLUSTER_ENDPOINT=your-cluster.cluster-xxxxx.region.rds.amazonaws.com DB_USERNAME=postgres DB_NAME=postgres DB_PASSWORD=your-password AWS_REGION=us-east-1 

2. Install dependencies:

pnpm install

3. Run migrations to create tables:

pnpm run db:migrate

4. Seed the database with movie data:

pnpm run db:seed

5. Start the development server:

pnpm run dev