Hi, how can I stream data using Prisma?

If you’re using GraphQL, you can use Subscriptions to stream data. If not, a combination of Prisma’s middleware and a PubSub mechanism should work as well.

I mean streaming data from database.

Could you elaborate on this?

Let's say I have big table that I need to stream from database to somewhere (client, file whatever). I don't want to fetch all the data into memory before processing it. Instead I want stream it from the database using node streams https://nodejs.org/api/stream.html . In similar manner to what Knex does: http://knexjs.org/#Interfaces-Streams

Unfortunately this isn’t supported. I would suggest creating a feature request here for the same with the above use case 🙂

Oh.. 😬

Cursor based pagination currently. That’s I think a workaround for not loading all data into memory.

Seems that there is already related issue: https://github.com/prisma/prisma/issues/5055 Streaming would be much smoother than cursor based pagination. The cursor example looks pretty cumbersome.