Is it possible to use Drizzle?

[cr101]

I’m planning to build a web app that needs SQLite Full-Text Search, which Prisma doesn’t currently support (and likely won’t for a while).

Are there parts of The Epic Stack that are so closely tied to Prisma that switching to Drizzle would be difficult?

[kentcdodds]

I would recommend looking into using raw SQL for that part of the codebase (and with typed sql the experience is actually really great). Similar to what we do for the user search in the notes app:

epic-stack/app/routes/users+/index.tsx

Line 18 in fb1f753

const users = await prisma.$queryRawTyped(searchUsers(like))

Give that a shot and let us know how it goes.

[cr101]

Thanks Kent. It requires a hack to make Full-Text Search work in Prisma with raw SQL queries

[kentcdodds]

I'll ask the team about it in my meeting with them next week.