How to migrate from Prisma to Drizzle?

[cr101]

Hi,

Personally I preffer Drizzle over Prisma as Drizzle is a query builder which aims to be close to SQL syntax.
Is there a quick way to migrate from Prisma to Drizzle?

[kentcdodds]

I don't plan on including (in the template or docs) ways to migrate away from the built-in decisions. But if you'd like to do so then you're welcome to do so :)

[jacobparis]

If it helps I have a little guide for setting up Drizzle in remix, and then you can just go through the prisma calls and replace them one by one

https://www.jacobparis.com/content/remix-drizzle

I like prisma for the Epic Stack because its API is basically pseudocode. You don't need to know prisma to be able to read the query/mutation and know what it's doing. Anyone who knows any other ORM or DB language can read it and reimplement their preferred choice, but the same can't be said of the inverse.

[stephen776]

A year later - I do wonder if this would be worth considering again. drizzle has matured a lot, the new query api allows for better syntax when querying, and the community seems to be growing.

[kentcdodds]

I'm not personally interested. The new typed SQL feature of prisma solved my one major gripe.

[stephen776]

Thanks Kent. I'll have to try out the typed sql feature.

Are there any other Prisma features that tip the scale for you?

[kentcdodds]

I like its API, schema config, and especially the migrations.