Cloudflare Developers•7mo ago

Working with D1 Remote DB locally with nextjs

So i'm using Cloudflare D1, I imported data into my remote Cloudflare D1 database, i didn't do this for the --local one and i don't really want to if possible. I want to just locally develop with the remote database. I have my binding setup and i created an API route like this

import type { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { cases } from "@/schema";
import { CloudflareEnv } from "@/env";
import { db } from "@/db";

export const runtime = "edge";

export async function GET(request: NextRequest, env: CloudflareEnv) {
  const context = getRequestContext();

  const DB = db((context.env as CloudflareEnv).edendb);

  const result = await DB.select({
    CaseID: cases.CaseID,
    CasePriority: cases.CasePriority,
    CaseStatus: cases.CaseStatus,
    Pending: cases.Pending,
    Active: cases.Active,
    Closed: cases.Closed,
    NotReviewed: cases.NotReviewed,
  }).from(cases);

  return new Response(JSON.stringify(result), {
    status: 200,
    headers: {
      "Content-Type": "application/json",
    },
  });
}

import type { NextRequest } from "next/server";
import { getRequestContext } from "@cloudflare/next-on-pages";
import { cases } from "@/schema";
import { CloudflareEnv } from "@/env";
import { db } from "@/db";

export const runtime = "edge";

export async function GET(request: NextRequest, env: CloudflareEnv) {
  const context = getRequestContext();

  const DB = db((context.env as CloudflareEnv).edendb);

  const result = await DB.select({
    CaseID: cases.CaseID,
    CasePriority: cases.CasePriority,
    CaseStatus: cases.CaseStatus,
    Pending: cases.Pending,
    Active: cases.Active,
    Closed: cases.Closed,
    NotReviewed: cases.NotReviewed,
  }).from(cases);

  return new Response(JSON.stringify(result), {
    status: 200,
    headers: {
      "Content-Type": "application/json",
    },
  });
}

I deployed the site with pnpm run deploy everythings good and when i go to the live url/api/getallcases route, it works just as expected. But in local development I get a

✘ [ERROR] Error: D1_ERROR: no such table: Cases

✘ [ERROR] Error: D1_ERROR: no such table: Cases

I know this has something to do with the local vs remote database but I can't seem to figure out how to develop against it with Nextjs, could anyone help? I've gotten this error with both pnpm run dev (nextjs server) and pnpm wrangler pages dev

3 Replies

Hello, I’m Allie!•7mo ago

pages dev only supports local bindings at the moment, unfortunately So you would need to dump the DB to use it locally

TaylorOP•7mo ago

Damn, is there anyway to easily replicate my remote db to local?

Hello, I’m Allie!•7mo ago

Or have a seeder

Gaming

Programming

Working with D1 Remote DB locally with nextjs