neondatabase/serverless-cfworker-demo

Demo app for @neondatabase/serverless — details at https://blog.cloudflare.com/neon-postgres-database-from-workers/

serverless-cfworker-demo's Issues

I am getting the following error, how to resolve?

code:

import { Client } from '@neondatabase/serverless';
interface Env { DATABASE_URL: string; }

export default {
async fetch(request: Request, env: Env, ctx: ExecutionContext) {
const client = new Client(env.DATABASE_URL);
await client.connect();
const { rows: [{ now }] } = await client.query('select now();');
ctx.waitUntil(client.end()); // this doesn’t hold up the response
return new Response(now);
}
}

error:

wrangler dev
Delegating to locally-installed [email protected] over global [email protected]...
Run npx wrangler dev to use the local version directly.

⛅️ wrangler 2.12.0 (update available 2.13.0)

⬣ Listening at http://0.0.0.0:8787

• http://127.0.0.1:8787
• http://192.168.1.19:8787
  Total Upload: 220.65 KiB / gzip: 54.03 KiB
  A hanging Promise was canceled. This happens when the worker runtime is waiting for a Promise from JavaScript to resolve, but has detected that the Promise cannot possibly ever resolve because all code and events related to the Promise's I/O context have already finished.
  1:28:37 AM GET / 500
  ✘ [ERROR] Uncaught (in response) Error: The script will never generate a response.

Connection Pool Instead of (or in addition to) Client

Creating a new client / calling client.connect() for every request / cron trigger in a Cloudflare worker (or any codebase) is not ideal. I suggest updating the demo to use a connection pool instead. Alternatively, give a second demo with connection pools.