pg-compat

Patch to make pg work with both Node.js and Cloudflare.

Target version pg@8.12.0 and ``pg@8.13.0`.

usage

• wrangler.toml

1compatibility_date = "2024-08-21"
2compatibility_flags = ["nodejs_compat_v2"]

1import { LoaderFunctionArgs } from "@remix-run/cloudflare";
2import pg from "pg";
3import { PrismaClient } from "@prisma/client";
4import { useLoaderData } from "@remix-run/react";
5import { PrismaPg } from "@prisma/adapter-pg";
6
7export default function Index() {
8  const values = useLoaderData<string[]>();
9  return (
10    <div>
11      {values.map((v) => (
12        <div key={v}>{v}</div>
13      ))}
14    </div>
15  );
16}
17
18export async function loader({
19  context,
20}: LoaderFunctionArgs): Promise<string[]> {
21  const url = new URL(context.cloudflare.env.DATABASE_URL);
22  const schema = url.searchParams.get("schema") ?? undefined;
23  const pool = new pg.Pool({
24    connectionString: context.cloudflare.env.DATABASE_URL,
25  });
26  const adapter = new PrismaPg(pool, { schema });
27  const prisma = new PrismaClient({ adapter });
28  await prisma.test.create({ data: {} });
29  return prisma.test.findMany().then((r) => r.map(({ id }) => id));
30}