it depens where to host Next.js. You should avoid Prisma in case of Vercel serverless, while you can go with it if it's self-hosted. one reason is connection pooling, which won't work with serverless, thus Vercel and Neon tweaked it to have the connection pool in the DB side to connect via websocket.

thank you I am considering Drizzle

just keep in mind that connection pool doesn’t work in serverless as it does in self hosted servers

Yes I will deploy it on my server.

I found that next-auth dont have drizzle adapter. I am confused right not. I should use next-auth or drizzle or else I should try typeorm