Neon Twin: How to deploy a change tested in Neon to prod in RDS
Blog post from Neon
The article explores a workflow for migrating changes from a development environment, Neon Twin, back to a production database on AWS RDS, emphasizing two methodologies: SQL scripts and Prisma ORM. It elaborates on setting up a Neon Twin as a development database and introduces database branching in Neon, which allows developers to experiment safely with isolated copies of production data. The process involves documenting schema changes using Neon's schema diff feature and implementing GitHub Actions to automate the migration either by manually applying SQL scripts with psql or using Prisma's migration tools. Both methods aim to streamline database schema management and improve development efficiency. Additionally, the article discusses re-synchronizing the production database with Neon Twin after migrations to ensure both environments remain aligned.