Wasp•10mo ago

Does anyone use Drizzle instead of Prisma?

I’m wondering if Wasp supports Drizzle or if someone is already using Drizzle in their Wasp project.
I prefer it much more since the queries are a lot closer to SQL

kapa.ai•2/20/25, 1:37 PM

Hi @lazycat. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base.

kapa.ai•2/20/25, 1:37 PM

----------------------
Based on the provided knowledge sources, I don't have specific information about Wasp supporting Drizzle or anyone using Drizzle in their Wasp projects. The documentation and discussions primarily focus on Wasp's integration with Prisma as its ORM.

Wasp currently uses Prisma as its primary database interaction layer. This is evident from several sources, including:

Prisma Configuration documentation, which details how Wasp uses Prisma to interact with databases.
Entities documentation, which shows how Wasp uses Prisma Client for database operations.
Various GitHub issues discussing Prisma integration and potential improvements, such as expanding Prisma support.

While there are discussions about potentially supporting other databases in the future, there's no mention of Drizzle specifically. If you prefer Drizzle's SQL-like queries, you might want to reach out to the Wasp community or maintainers to inquire about potential future support or workarounds. However, as of now, Prisma appears to be the primary and officially supported ORM for Wasp.
----------------------
Note: you can ask me a follow up question by @ mentioning me again

----------------------

kapa.ai•2/20/25, 1:37 PM

Sorry @lazycat, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist:

Perhaps try again in 15mins?

miho•2/21/25, 6:28 PM

Prisma is a baked in dependency on top of we built a lot of our features. You can't take it out, you could try using Drizzle in Wasp, but that's not something we recommend since you'd need to recreate pretty much all the operations and auth code (operations rely on Prisma, auth code uses Prisma etc.)

In the future Wasp might offer a way to swap out the DB layer - but not in the near future. We are not prioritising now