David
David•12mo ago

How would batching result in a single database query?

On the httpBatchStreamLink docs it says that multiple query calls could result in a single database query. How would that work? Should you expect the passed input to possibly be an array to allow for this? 
After that, you can make use of batching by setting all your procedures in a Promise.all. The code below will produce exactly one HTTP request and on the server exactly one database query:
After that, you can make use of batching by setting all your procedures in a Promise.all. The code below will produce exactly one HTTP request and on the server exactly one database query:
4 Replies
Alex / KATT 🐱
Alex / KATT 🐱•12mo ago
if you use a dataloader for fetching stuff
Alex / KATT 🐱
Alex / KATT 🐱•12mo ago
https://github.com/graphql/dataloader
GitHub
GitHub - graphql/dataloader: DataLoader is a generic utility to be ...
DataLoader is a generic utility to be used as part of your application's data fetching layer to provide a consistent API over various backends and reduce requests to those backends via batc...
Alex / KATT 🐱
Alex / KATT 🐱•12mo ago
prisma does this automatically for findUnique https://www.prisma.io/docs/guides/performance-and-optimization/query-optimization-performance#solving-the-n1-problem
Prisma
Query optimization
How Prisma optimizes queries under the hood
David
David•12mo ago
Thank you! Is there some example code for this using trpc?
More Posts
TS error cause Query is not returning correct type to the client!So Ive build a query which return a type called Employee, for example. on my client I've props whichTypescript helper for router outputis there a helper to do this better? Get the output for a certain route? Or is this the way to do itAm I able to use "multer" with trpc?Im currently trying to implement file uploads within a T3 app using S3. I am following along with a Losing type inference in vs-codeHey, I'm having quite some trouble with type inference today. I create my client inside of functionHow would you implement basic auth session tokens with tRPC?I'm building a hobby app which requires basic auth. I'm used to use **express **and **express-sessioExample for tRPC, stable version, with RSCHi This may be a stupid question... The readme of the experimental example mentions > Note You Dynamic return typeIs there any way to have dynamic return type with tRPC? Simple example: If I provide x: true on boSometimes invalidate not work...hello sometimes invalidate method does not work in `onSuccess` anyone same? using NextJS, pnpmtrpc client request size limits?I am sending a pretty sizable request and am seeing ``` [TRPCClientError: JSON Parse error: UnexpecMake tRPC return Bad Request on Zod validation error?As the title says, how can I make tRPC return a proper error message, like a Bad Request, when there