$0 Comments - Answer Overflow

Hyperdrive works not only with PostgreSQL databases — including Neon, Google Cloud SQL, AWS RDS, and Timescale, but also PostgreSQL-compatible databases like Materialize (a powerful stream-processing database), CockroachDB (a major distributed database), Google Cloud’s AlloyDB, and AWS Aurora Postgres.

Hyperdrive works not only with PostgreSQL databases — including Neon, Google Cloud SQL, AWS RDS, and Timescale, but also PostgreSQL-compatible databases like Materialize (a powerful stream-processing database), CockroachDB (a major distributed database), Google Cloud’s AlloyDB, and AWS Aurora Postgres.

The documentation does not include instructions on how to connect to AlloyDB, so I am trying the same method as Google Cloud SQL. https://developers.cloudflare.com/hyperdrive/examples/google-cloud-sql/

10 replies

CDCloudflare Developers

•Created by $0 on 8/2/2024 in #pages-help

Unexpected end of JSON ( How to use Durable Objects with next-on-pages? )

I tried binding the DurableObject directly, but I still get the same error.

export const runtime = "edge";

import { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { getPrismaClient }from "@/lib/db";
import checkAuth from "@/utils/checkAuth";

export async function GET(req: NextRequest): Promise<Response> {
  try {
    const prisma = getPrismaClient();
    const { profileId } = await checkAuth(prisma) || {};
    if (!profileId) {
      console.log("User not authenticated.");
      return new Response("User not authenticated.", { status: 401 });
    };

    const id = getRequestContext().env.WEBSOCKET.idFromName(profileId.toString());
    const roomObject = getRequestContext().env.WEBSOCKET.get(id);

    console.log("aaa");
    const response = await roomObject.fetch(`http://service-binding/websocket`, req);
    console.log("bbb");
    console.log(response.status);

    return response
  } catch (error) {
    console.log("Internal server error.");
    console.error(error);
    return new Response("Internal server error.", { status: 500 });
  };
};

export const runtime = "edge";

import { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { getPrismaClient }from "@/lib/db";
import checkAuth from "@/utils/checkAuth";

export async function GET(req: NextRequest): Promise<Response> {
  try {
    const prisma = getPrismaClient();
    const { profileId } = await checkAuth(prisma) || {};
    if (!profileId) {
      console.log("User not authenticated.");
      return new Response("User not authenticated.", { status: 401 });
    };

    const id = getRequestContext().env.WEBSOCKET.idFromName(profileId.toString());
    const roomObject = getRequestContext().env.WEBSOCKET.get(id);

    console.log("aaa");
    const response = await roomObject.fetch(`http://service-binding/websocket`, req);
    console.log("bbb");
    console.log(response.status);

    return response
  } catch (error) {
    console.log("Internal server error.");
    console.error(error);
    return new Response("Internal server error.", { status: 500 });
  };
};

aaa bbb 101 [wrangler:err] SyntaxError: Unexpected end of JSON input [wrangler:err] TypeError: Web Socket request did not return status 101 Switching Protocols response with Web Socket [wrangler:inf] GET /api/users/profiles/websocket 500 Internal Server Error (68ms)

4 replies

CDCloudflare Developers

•Created by $0 on 8/2/2024 in #pages-help

Unexpected end of JSON ( How to use Durable Objects with next-on-pages? )

src/app/api/users/profiles/websocket

export const runtime = "edge";

import { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { getPrismaClient }from "@/lib/db";
import checkAuth from "@/utils/checkAuth";

export async function GET(req: NextRequest): Promise<Response> {
  try {
    const prisma = getPrismaClient();
    const { profileId } = await checkAuth(prisma) || {};
    if (!profileId) {
      console.log("User not authenticated.");
      return new Response("User not authenticated.", { status: 401 });
    };

    const url = new URL(req.url);
    url.pathname = `/${profileId}/websocket`;
    const request = new Request(url, req.clone());
    
    const workerResponse = await getRequestContext().env.WEBSOCKET.fetch(request);
    
    console.log("Worker response status:", workerResponse.status);
    console.log("Worker response headers:", Object.fromEntries(workerResponse.headers));

    return workerResponse;
  } catch (error) {
    console.log("Internal server error.");
    console.error(error);
    return new Response("Internal server error.", { status: 500 });
  };
};

export const runtime = "edge";

import { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { getPrismaClient }from "@/lib/db";
import checkAuth from "@/utils/checkAuth";

export async function GET(req: NextRequest): Promise<Response> {
  try {
    const prisma = getPrismaClient();
    const { profileId } = await checkAuth(prisma) || {};
    if (!profileId) {
      console.log("User not authenticated.");
      return new Response("User not authenticated.", { status: 401 });
    };

    const url = new URL(req.url);
    url.pathname = `/${profileId}/websocket`;
    const request = new Request(url, req.clone());
    
    const workerResponse = await getRequestContext().env.WEBSOCKET.fetch(request);
    
    console.log("Worker response status:", workerResponse.status);
    console.log("Worker response headers:", Object.fromEntries(workerResponse.headers));

    return workerResponse;
  } catch (error) {
    console.log("Internal server error.");
    console.error(error);
    return new Response("Internal server error.", { status: 500 });
  };
};

4 replies

CDCloudflare Developers

•Created by $0 on 8/2/2024 in #pages-help

Unexpected end of JSON ( How to use Durable Objects with next-on-pages? )

src/index.mjs

4 replies

CDCloudflare Developers

•Created by $0 on 7/28/2024 in #pages-help

the script will never generate a response.

Thanks to you, I understood the cause. It was necessary to connect the DB for each request.

13 replies

CDCloudflare Developers

•Created by $0 on 7/28/2024 in #pages-help

the script will never generate a response.

I'm not good at English, but translate and read this site, you can expect that the reason why the image is not displayed is to access the image at the same time with multiple img tags.

13 replies

CDCloudflare Developers

•Created by $0 on 7/28/2024 in #pages-help

the script will never generate a response.

Is this the cause? https://zuplo.com/blog/2022/03/04/the-script-will-never-generate-a-response

13 replies

CDCloudflare Developers

•Created by $0 on 7/28/2024 in #pages-help

the script will never generate a response.

It is strange that it may also be displayed in the case of img tags. The cache header of cloudflare is dynamic. The browser cache is disabled.

13 replies

CDCloudflare Developers

•Created by $0 on 7/28/2024 in #pages-help

the script will never generate a response.

When I entered the URL directly in the browser, it was displayed. Even if I open an error request in the network tab of the browser's developer mode, it will be displayed.

13 replies

Gaming

Programming