Query Stream Extension

This guide assumes familiarity with:

Some PostgreSQL clients, like node-postgres, require separate libraries to enable certain features, such as streaming and chunking. To make it work with waddler, you need to install the query-stream package and then configure Waddler to enable it

npm
yarn
pnpm
bun 
npm i pg-query-stream
import { queryStream } from 'waddler/extensions/pg-query-stream';

const sql = waddler(process.env.DATABASE_URL!, { extensions: [queryStream()] });

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

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

For more exmaples you can check stream and chunked pages