@bubblydoo/cloudflare-workers-postgres-client

Cloudflare Workers Postgres Driver

This is an experimental module.

Heavily based on cloudflare/worker-template-postgres, but cleaned up and bundled into a single module.

import { Client } from '@bubblydoo/cloudflare-workers-postgres-client';

const createClient = () => {
  return new Client({
    user: 'postgres',
    database: 'postgres',
    hostname: 'https://<YOUR CLOUDFLARE TUNNEL>',
    password: 'keyboardcat',
    port: 5432,
  });
}

const worker = {
  async fetch(request, env, ctx) {
    const client = createClient();
    
    await client.connect()

    const userIds = await client.queryArray('select id from "Users" limit 10');

    ctx.waitUntil(client.end());

    return new Response(JSON.stringify(userIds));
  }
}

export default worker;

You also have to make sure the worker-overrides.ts file is imported, which sets the Deno and FinalizationRegistry values on globalThis. This is needed to make the Deno code work.

For example, in esbuild:

await build({
  ...,
  inject: ["./node_modules/@bubblydoo/cloudflare-workers-postgres-client/workers-override.ts"],
})

Or, you can just import it at the top of your main file:

import '@bubblydoo/cloudflare-workers-postgres-client/workers-override';

How it works

It uses the postgres Deno module, bundles it, and adds some code to make it work with Cloudflare Workers. The Deno module uses WebAssembly for its crypto module, so this is included as well.

Usage with Miniflare

[[build.upload.rules]]
type = "CompiledWasm"
globs = ["**/*.wasm"]