AWS Aurora PostgreSQL Movies Demo

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: View Demo

Getting Started: Click the "Deploy" button to clone this repo, create a new Vercel project, setup the AWS integration, and provision a new Aurora PostgreSQL database:

Once the process is complete, you can clone the newly created GitHub repository and start making changes locally.

Requirements

• Installed Aurora PostgreSQL. You can do that via Vercel Marketplace

Local Setup

1. Pull vercel environment variables locally

1
vercel env pull

1. Install dependencies:

1
pnpm install

1. Run migrations to create tables:

1
pnpm run db:migrate

1. Seed the database with movie data:

1
pnpm run db:seed

1. Start the development server:

1
pnpm run dev

1. View development server: http://localhost:3000