NextJS Intercepting routes
Hi there,
Been playing with the fancy new intercepting routes within Next and I need a 1am-programming-stupidity check.
Am I wrong to assume that this should be intercepting
/dashboard/post ?...
Help using Zustand and Pusher on the edge
I am trying to allow users on my Vercel deployed website to subscribe to Pusher messages. I understand that this isn't normally possible due to how the edge works.
From looking at the Zapdos repository I can see that it's possible to use Zustand to maintain a connection to Pusher on an edge deployment.
I've included screenshots of my Zustand store - on the left file I use the pusher store, then I have a useEffect that starts binding events when the room is defined....
I have TRPC question/problem
This works fine
```ts
getUser: publicProcedure
.input(z.object({ id: z.string()}))
.query(({ ctx ,input }) => {...
Solution:
npx prisma db push, restart your ide, should fix it
How to prefetch queries with tRPC?
The generateSSGHelpers function is deprecated as of now, what is the new way to prefetch queries with trpc?
Error validating: You defined the enum `UserRole`. But the current connector does not support enums.
Solution:
Looks like you're using sqlite. You can:
* have a UseRole table
* if your project isn't that complex/big, you can just just store it as a string
* isAdmin boolean (if that's all you'll need)?...
Drizzle vs. Prisma: why does Drizzle need less row reads?
I deployed a project to PlanetScale and noticed a high number of row reads for searching a table of 500 rows. I didn't think anything of it. I've been wanting to switch to Drizzle ORM anyway after I saw the TypeScript schema definition.
I made the switch with everything the same (except I'm not sorting by id) and noticed a HUGE rise in read/return efficiency with Drizzle. The SQL query is the same. The indices are the same. I did notice Prisma prepends the db name and table everywhere, like
db.Table.column wherever it can. Drizzle doesn't.
I'm impressed. Is there anything I'm missing? ...Solution:
Yeah, prisma doest use joins, it makes individual calls and combines the data.
