AWS Amplify Gen 2 Full stack CI/CD with Postgres (SSR, Web Compute, Auto-detection, SSM)

Neon Postgres Branch for each Amplify Hosting app branch.
⭐ GitHub repo with example Amplify Hosting Build Settings and Bash script: github.com/siegerts/neon-bran...
This video walks through how to integrate AWS Amplify Hosting with Neon Postgres for database management through CI/CD pipelines. The setup includes a custom Bash script for creating and cleaning up Neon database branches in correlation with the Amplify app branches. The database connection string for the branch is written into the .env file as an environment variable as DATABASE_URL.
This example uses an amplify.yml buildspec for an Amplify Gen 2 Backend. Specifically, this Nuxt SSR app is deployed using Amplify Hosting's WEB COMPUTE platform.
Instructor: / siegerts | / siegerts
→ Try Neon at neon.tech/youtube
→ Neon Discord: neon.tech/discord
→ Follow us on Twitter / neondatabase
→ Star us on GitHub github.com/neondatabase/neon
[00:00] - Intro
[01:53] - CI/CD and app architecture overview
[03:34] - Create a Nuxt SSR App in Amplify Hosting Gen 2 with GitHub repo
[04:17] - Configure app deployment, Service role, and build image
[05:10] - First deployment and Amplify Hosting secrets & AWS Systems Manager Parameter Store (SSM) overview
[06:28] - First App deployment build logs
[06:54] - Review the app build settings (amplify.yml, pnpm, Neon CLI)
[08:58] - Neon CI bash script to create branches
[09:29] - Review first deployment
[10:21] - Set up Amplify Hosting branch auto-detection
[11:11] - Create an inline policy in IAM for the service role to access the Neon API key in Parameter Store and listBranches
[14:30] - Redeploy the app
[14:37] - Review the Neon Project Branches
[15:01] - New Neon branch automatically created from CICD
[16:13] - Trigger a new Amplify app branch and Neon Postgres branch
[17:21] - Review the new Neon Postgres branch
[17:47] - Compare the Nuxt SSR app using the different database branches with Nuxt Server Routes
[20:23] - Review
[22:10] - Outro
#aws #fullstack #postgres #serverless #ssr #amplifyhosting #awsamplify #javascript

[@Website-Content-Creator]

bro do you have any full tutorial video i want to learn more about your neon database

[@neondatabase]

If you enjoyed watching this video, make sure to like and subscribe so you don't miss out on any future videos.
Try out Neon: neon.tech/youtube
Neon documentation: neon.tech/docs/