Mike J Posts - Answer Overflow

Mike J

Explore posts from servers

•Created by Mike J on 11/23/2023 in #pages-help

Using 'pg' in an Astro API route

Hi. I think you can use Node's pg with Cloudflare workers according to https://developers.cloudflare.com/workers/tutorials/postgres I am trying to deploy an Astro API route like the following but the build is failing

The package "net" wasn't found on the file system but is built into node. Are you trying to bundle for node? You can use "platform: 'node'" to do that, which will remove this error.

It's not clear to me where I am supposed to specify the platform.

import { Client } from "pg";

export async function GET({ params, request }) {
  const DATABASE_URL = new URL(request.url).searchParams.get("database_url");
  const client = new Client({ DATABASE_URL });
  await client.connect();
  await client.query("SELECT pg_sleep(1);");
  await client.end();
  return new Response(
    JSON.stringify({
      DATABASE_URL: DATABASE_URL,
    })
  );
}

import { Client } from "pg";

export async function GET({ params, request }) {
  const DATABASE_URL = new URL(request.url).searchParams.get("database_url");
  const client = new Client({ DATABASE_URL });
  await client.connect();
  await client.query("SELECT pg_sleep(1);");
  await client.end();
  return new Response(
    JSON.stringify({
      DATABASE_URL: DATABASE_URL,
    })
  );
}

1 replies

Gaming

Programming