AbsaOSS / AbsaOSS/fa-db

Fetching database records with streaming approach

Open
#107 0 comments 1 reaction 0 assignees View on GitHub
enhancement
Dominant language
Scala
Stars
2
Forks
0
Avg merge
3d 18h
Merged PRs (30d)
3

Description

## 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.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.