DT
Drizzle Team•16mo ago
sps

Migrating from Prisma

Hi, I have an existing project already in production built using prisma and postgres (supabase). I am planning to go serverless and hence planning to migrate to drizzle + PlanetScale. Here is how I am planning it: 1. Use Prisma to generate the entire schema structure in MySQL (Planetscale) 2. Use Drizzlekit to introspect and generate types. 3. Use Drizzle ORM for querying. Am I thinking in the right direction? Or is there a recommended way?
1 Reply
alexblokh
alexblokh•16mo ago
hey! yep, it should be the fastest way. If you already have a live database it Planescale - you can just introspect it
Want results from more Discord servers?
Add your server
More Posts
Numeric // Decimal Postgres types are inferred as strings and expect string as an input as wellCannot read properties of undefined (reading '0')What is the expected behavior when using `get()` when there would be no matching results for a giveIs it recommended to create a SQL transaction every time we try to create a foreign relationship?prisma used to wrap every foreign upsert (2 entities) within a transaction to guarantee that both roDoesn't drizzle-kit generate:pg work yet when schema imports from esm package?``` > drizzle-kit generate:pg --out src/db/migrations --schema src/db/schemas drizzle-kit: v0.17.0