Background

At the moment if we're fetching a large number of records from a database without using streaming, we can potentially run into an OutOfMemoryError. This is because all the records are loaded into memory at once.

Feature

Streaming, on the other hand, loads data in chunks, keeping only a portion of the data in memory at any given time. This is more memory-efficient and can handle large datasets that would not fit into memory all at once.

Both Doobie and Slick support streaming. Moreover streaming integration with ZIO is possible. It would be great to explore the space and find out if/how we could introduce streaming capabilities into this library.