Hey again, how would you guys handle fetching large amount of data? Let's say I want to fetch 100K users from my database and export their data. What's the best way to do it?

you could use

findall()

in small batches (eg. 5000 at a time) and paginate until you went through the whole thing

I can say Prisma does not support stream data now. in my experience I was using https://github.com/brianc/node-postgres/tree/master/packages/pg-query-stream to get large data

Do you want to fetch all 100K records in one go? You could use pagination to get records in batches.

Pagination it is, thanks 👍