Cloudflare Developers•4mo ago

Is there a way to Duplicate a D1 (including data) via APICall or CLI?

Fflof.fly Is there a way to Duplicate a D1 (including data) via APICall or CLI?

lambrospetrou•9/8/25, 7:13 AM

Not at the moment

Pingo•9/8/25, 2:12 PM

Hi im a noob to d1 and my biggest concern is obviously avoiding something like tea app disaster. So I wanted to know if there is an awesome list with projects using d1 so I can learn how real life applications are configuring d1 with battle tested patterns. I am extremely paranoid about managing user data correctly. Sorry if this is not the place to ask about this.

PPingo Hi im a noob to d1 and my biggest concern is obviously avoiding something like t...

lambrospetrou•9/8/25, 2:24 PM

Hi im a noob to d1 and my biggest concern is obviously avoiding something like tea app disaster.

What is the "tea app disaster"?

D1 is durable storage, and provides up to 30 days of Point-in-time-restore for your data to be able to revert to any point in these 30 days.

There are certain limits, about storage (10GB) and fixed resource limits due to being single threaded execution of the queries, but we don't lose your data.

If you have specific concerns or questions, happy to answer. Or anyone in this community for what's worth.

Llambrospetrou > Hi im a noob to d1 and my biggest concern is obviously avoiding something like...

Isaac McFadyen•9/8/25, 2:28 PM

What is the "tea app disaster"?

Recent data breach from an app called Tea: https://www.bbc.com/news/articles/c7vl57n74pqo

IIsaac McFadyen > What is the "tea app disaster"? Recent data breach from an app called Tea: htt...

lambrospetrou•9/8/25, 2:55 PM

D1 data is encrypted at rest (built ontop of Durable Objects), but obviously access is authenticated using either your worker binding (so having access to deploying workers) or to the Cloudflare access tokens, so you should protect your access tokens as any other secret. I can't say anything specific about the leaked incident of Tea.

Gab•9/8/25, 3:35 PM

HI guys, how can I aapply drizzle migrations to preview or local d1 database?
im trying with ->
wrangler d1 migrations apply d1_database --local
the CLI say it works well, but when I come to sql editor, there is no schema in the database

Gab•9/8/25, 3:38 PM

when I use wrangler d1 migrations apply d1_database --remote
it workers well on the main d1 database, but --local does not seen to apply

GGab when I use wrangler d1 migrations apply d1_database --remote it workers well on ...

Anes•9/8/25, 3:43 PM

you can apply the migrations using drizzle, your drizzle.config.ts should look like this:

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

config({
  path: ".env.stage"
});

export default defineConfig({
  schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"],
  out: "./drizzle/app",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CF_ACCOUNT_ID,
    databaseId: process.env.CF_DATABASE_ID,
    token: process.env.CF_TOKEN,
    url: ""
  }
});

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

config({
  path: ".env.stage"
});

export default defineConfig({
  schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"],
  out: "./drizzle/app",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CF_ACCOUNT_ID,
    databaseId: process.env.CF_DATABASE_ID,
    token: process.env.CF_TOKEN,
    url: ""
  }
});

eg script:

"db:push": "drizzle-kit push --config=./drizzle.config.ts"

"db:push": "drizzle-kit push --config=./drizzle.config.ts"

Gab•9/8/25, 3:48 PM

ok, do i need to change the CF_DATABASE_ID for the local preview d1 database? (i can add in .dev.vars)

Gab•9/8/25, 4:19 PM

I got working with the old script, It was working, thje problem was at my betterAuth objecta tha was not findind the correct db

csmykay•9/8/25, 6:27 PM

Howdy all. Is there a good "best practices" document for working with D1 databases locally with multiple developers and how best to push updates? I actually have a response from Claude but looking for something to double check.

52Hz•9/8/25, 8:20 PM

Is it currently possible to download the data of a specific time point three days ago from the D1 database without modifying the database?

csmykay•9/8/25, 9:07 PM

On a side note a "best practices" in using drizlle on your docs page would be great.

552Hz Is it currently possible to download the data of a specific time point three day...

lambrospetrou•9/9/25, 7:30 AM

No, unfortunately.

52Hz•9/9/25, 7:50 AM

Is it possible to restore to a certain point in time, export the data, and then revert back to the point in time before the operation?

552Hz Is it possible to restore to a certain point in time, export the data, and then ...

lambrospetrou•9/9/25, 9:21 AM

Yes, with the caveat that during export your DB won't be able to process queries.

52Hz•9/9/25, 10:19 AM

OK. Thank you.

Dean•9/9/25, 6:27 PM

anyone else seeing D1 issues right now? WNAM region. database won't even load in dashboard

parisholley•9/9/25, 6:27 PM

yes

Dean•9/9/25, 6:28 PM

looks like it's back for me, for some dbs, some are still dead

nullptr•9/9/25, 6:29 PM

D1 is returning errors all over

aza547•9/9/25, 6:29 PM

Also seeing issues

nullptr•9/9/25, 6:30 PM

Guys any help here? Our production stack is on fire it looks like

Iaci•9/9/25, 6:31 PM

yes, same here:
Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

thirtyfourdifferentoranges•9/9/25, 6:34 PM

having catastrophic d1 failures here

kafk•9/9/25, 6:34 PM

same

Matthew•9/9/25, 6:34 PM

bunch of errors. had the same last night around 0:30 UTC

Tc001•9/9/25, 6:34 PM

lol just as I was trying to use my app built with it

to all the employees

thirtyfourdifferentoranges•9/9/25, 6:34 PM

oh my god, this is going to be a long day

parisholley•9/9/25, 6:35 PM

https://tenor.com/view/wet-hot-american-summer-group-hug-crying-sad-together-gif-5276724

Tenor

a good group cry

Paul Shriner - Titleless•9/9/25, 6:36 PM

Well this sucks.

kafk•9/9/25, 6:38 PM

I thought some villain hacked and dropped the db, fortunately it's just a global Cloudflare failure :MeowHeartCloudflare:

Hard@Work•9/9/25, 6:38 PM

Team is aware, thanks for the reports!

Tc001•9/9/25, 6:41 PM

Yay it's back for me (edit: nvm)

mrk•9/9/25, 6:43 PM

My production database is down as well! @Hard@Work | R2 do keep us posted

Chaika•9/9/25, 6:44 PM

Should be status page in a bit

Hard@Work•9/9/25, 6:44 PM

Yep, team is working on it

Chaika•9/9/25, 6:44 PM

yea, fully manual

Steps•9/9/25, 6:45 PM

Just had a worker failing with this:
Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

Is that normal? Does that happen often?

Chaika•9/9/25, 6:45 PM

https://www.cloudflarestatus.com/incidents/9pvscr0vmsy6

Performance impact for Cloudflare Services

SSteps Just had a worker failing with this: `Error: D1_ERROR: Internal error while star...

aza547•9/9/25, 6:45 PM

I don't think it's normal

Dean•9/9/25, 6:45 PM

Performance impact for Cloudflare Services seems kinda vague, d1 isn't even listed lol

Steps•9/9/25, 6:45 PM

So the error could be related?

Bbvd Seeing issues with other services that don't use D1 (durable objects) as well

Hard@Work•9/9/25, 6:46 PM

The issue is with DOs. D1 runs on DOs

HHard@Work The issue is with DOs. D1 runs on DOs

Chaika•9/9/25, 6:46 PM

Just Sqlite DOs, yea?

import { defineConfig } from "drizzle-kit"; import { config } from "dotenv"; config({ path: ".env.stage" }); export default defineConfig({ schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"], out: "./drizzle/app", dialect: "sqlite", driver: "d1-http", dbCredentials: { accountId: process.env.CF_ACCOUNT_ID, databaseId: process.env.CF_DATABASE_ID, token: process.env.CF_TOKEN, url: "" } });

Is there a way to Duplicate a D1 (including data) via APICall or CLI?

Similar Threads

Similar Threads

Similar Threads