HI guys, how can I aapply drizzle migrations to preview or local d1 database? im trying with -> wra

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

GabOP•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",

GabOP•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)

GabOP•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?

GGab HI guys, how can I aapply drizzle migrations to preview or local d1 database? i...

Deo Kumar•9/9/25, 6:47 PM

Does drizzle migration work after creating a new column in table schema?

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

seems to be working for me now

�

😈 Donkey 💫•9/9/25, 6:55 PM

my D1 is dead now

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

It's not entirely dead. Sometimes it succeeds. It's off and on right now.

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: "" } });

HI guys, how can I aapply drizzle migrations to preview or local d1 database? im trying with -> wra

Similar Threads

Similar Threads

Similar Threads