DT
Drizzle Team•13mo ago
Rhys

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
Andrii Sherman
Andrii Sherman•13mo ago
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?
Rhys
Rhys•13mo ago
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
Andrii Sherman
Andrii Sherman•13mo ago
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
Rhys
Rhys•13mo ago
Good to know thanks, prepared statements also look pretty interesting I hadn’t seen those yet
imoby
imoby•11mo ago
I'm also in this same boat, do you know how much the bundle size difference there is between prisma and this?
Want results from more Discord servers?
Add your server
More Posts
Refetching?Hello I just put up an app using Next 13 app directory and I decided to give Drizzle a try. EverythiCount, Distinct, etc (postgres)Where can I find documentation for these kinds of db operations? I'm using drizzle with postgres-jsQuery/select statement of column via sql`` for extras fieldis it possible to make a normal select to another table inside a extras object in a relational queryonConflictDoUpdate arrayHi, is it possible to upsert/update an array? ```ts await db.insert(organizations).values(organizatRelational queries for editing?Relational queries look great, but they are just for reading data right? Nothing like `updateOne` orIs there a way to dynamically edit a query with the builder?I am using drizzle and I love it, but, coming from knexjs, I am missing a lot this feature: https://When trying to push:mysql its warning that schema has changed and data will be lost when it hasnt.```· You're about to change projected_points column type from alter_table_alter_column_set_type to dInvalid input value for enumI have this enum definition as below and whenever I’m to make a request to save a data of the kind oShare migrations in monorepoI am using drizzle in a monorepo (npm workspaces with turborepo) within an internal package that is Top-level await is not available in the configured target environment ("node14")```typescript import type { Config } from "drizzle-kit"; import { getDbUrl } from "./src"; export