Waddler stream

This guide assumes familiarity with:

Quick start with Waddler - read here
Waddler SQL template - read here

Note

Stream is not implemented in d1, libsql, op-sqlite

All other drivers have support for a stream feature

.stream() lets you stream query result rows one by one:

for await

generator

const result = sql`select * from users`.stream();

for await (const row of result) {
  console.log(row);
}

{
  id: 1,
	name: "Alex",
}
{
  id: 2,
	name: "Oleksii",
}

const generator = sql`select * from users`.stream();

let result = await generator.next();
while (!result.done) {
  console.log(result.value);

  result = await generator.next();
}

{
  id: 1,
	name: "Alex",
}
{
  id: 2,
	name: "Oleksii",
}