Why your preview environments aren’t truly production-like
summary
A pet project adds a Postgres index directly in production, causing Prisma migrate to detect schema drift at merge and block deployment. The concrete fix: create preview DBs by branching from production so Prisma migrate Dev sees drift inside the PR, update migrations there, then merge cleanly. Neon’s serverless Postgres uses a copy-on-write filesystem and cold starts under ~500 ms. PGAnonymizer on a 1 TB snapshot takes ~20 minutes, so snapshot sampling + anonymization is recommended.
AI-written summary · about
chapters (4)
- 0:00Introduction and personal story
- 5:19Problems with preview environments
- 7:04Branching databases from production
- 9:13Q&A on branching and data handling
related talks
27mPlanetScale and Prisma: building in the cloud
23mPreview Environments: Now Everyone Is Part of the Software Development Process
46mTransform your development workflow with thin cloning
14mMaking Postgres serverless
21mWith Preview Environments, Everyone is Invited To the Party
28mNext.js and Prisma: Databases in Serverless Made Easy
45mPostgres: ServerLESS is more?
05mOpening Keynote