I always get a small anxiety spike when I use a DB query engine that doesn't have streaming reads or writes. 🙀 Seems in sqlite in node you just need to deal with it and do batching in your query layer?
@ireneista Yeah I don't blame sqlite. Sadly I am bound by a particular ORM built on top of it. https://orm.drizzle.team/docs/select#iterator
@mauve ah yep. sorry to hear.
@mauve sqlite has an API for it, we know this because we've implemented language bindings to it. if node doesn't support that mode that's the node binding's fault