Migrating from Prisma to Drizzle - What would be helpful to track for a before / after?
Heyo, I’m migrating @Answer Overflow from Prisma to Drizzle and since it’s a project in production I figured it might be nice to get some real world data from the migration.
My main reasons for swapping over is to run on edge, cut my bundle size, and use the HTTP planetscale driver, and have the sql query builders. Also I like the name more
From the perspective of the Drizzle devs, is this something that’d be valuable to track for a before / after to have for Drizzles’ marketing / docs / blogs or is it not really needed?
Relevant GitHub link: https://github.com/AnswerOverflow/AnswerOverflow/tree/main/packages/db
GitHub
AnswerOverflow/packages/db at main · AnswerOverflow/AnswerOverflow
Indexing Discord Help Channel Questions into Google - AnswerOverflow/packages/db at main · AnswerOverflow/AnswerOverflow
5 Replies
Hey! Sounds great. We would love to hear your story about migrating to Drizzle. It would be really useful for us as feedback and for the community as an example
Have you had a chance to try Drizzle already? Perhaps some small examples, just to ensure it meets your needs?
Yeah I and @ꨄJolt have both played around with it and have enjoyed the experience, bit of learning to do going back to writing SQL but none of the queries on the project are that complex
For the driver part in a long running connection, I.e the discord bot would it make sense to do a different driver than the HTTP planetscale driver?
My understanding is the planetscale driver is great for serverless funcs since you skip the connection parts but since the bot is long running that may not be as big of a deal
Yeah, for long running apps I would suggest to just use a Pool connection to database
You can also benefit from prepared statements on long running servers
https://orm.drizzle.team/docs/performance
Good to know thanks, prepared statements also look pretty interesting I hadn’t seen those yet
I'm also in this same boat, do you know how much the bundle size difference there is between prisma and this?