is this `wrangler d1 execute`?

MMax (@rozenmd)is this `wrangler d1 execute`?

D

dave•9/18/23, 4:47 PM

yes

D

dave•9/18/23, 5:40 PM

Is using a remote D1 database with

wrangler dev

wrangler dev

no longer possible?

D

dave•9/18/23, 5:40 PM

I have some old code that does.

Ddave Is using a remote D1 database with `wrangler dev` no longer possible?

C

Cyb3r-Jak3•9/18/23, 5:41 PM

I believe the

—remote

—remote

—remote

—remote flag should

D

dave•9/18/23, 5:42 PM

hmmmm maybe I should just migrate

Ddave Is using a remote D1 database with `wrangler dev` no longer possible?

M

Max (@rozenmd)OP•9/18/23, 5:48 PM

the default was just changed for wrangler v3: https://github.com/cloudflare/workers-sdk/releases/tag/wrangler%403.0.0

M

Max (@rozenmd)OP•9/18/23, 5:48 PM

wrangler dev now runs fully-locally by default, using the open-source Cloudflare Workers runtime workerd.

To restore the previous behaviour of running on a remote machine with access to production data, use the new --remote flag.

The --local and --experimental-local flags have been deprecated, as this behaviour is now the default, and will be removed in the next major version.

IIsaac McFadyen You are. New is beta and old is alpha.

D

dave•9/18/23, 7:15 PM

Is there an easy way to migrate?

Ddave Is there an easy way to migrate?

C

Cyb3r-Jak3•9/18/23, 7:24 PM

If you need to migrate then you have to do a manual backup from the old one and then import it into the new one. There isn’t an automated process.

Ddave Is there an easy way to migrate?

M

Max (@rozenmd)OP•9/18/23, 7:37 PM

your database is already running beta, nothing to migrate?

MMax (@rozenmd)your database is already running beta, nothing to migrate?

D

dave•9/18/23, 7:54 PM

this is for a different Worker

JJeff Hey could someone check my DB it seemed to be completely bricked eb0c94ad-555b-4...

J

James•9/18/23, 9:35 PM

@Matt Can anyone take a look at this when available please?

JJames @Matt Can anyone take a look at this when available please?

M

Matt Silverlock•9/18/23, 9:48 PM

Looking now (have been in meetings)

J

James•9/18/23, 9:48 PM

Thank you

MMax (@rozenmd)> wrangler dev now runs fully-locally by default, using the open-source Cloudfla...

J

jimmydirt•9/18/23, 11:15 PM

Are there plans to enable the --remote flag for Pages?

CCole Xemi My DB is throwing the same error now at runtime - 4b353ed3-37e1-4c99-8377-a22dda...

C

Cyb3r-Jak3•9/19/23, 12:37 AM

Do you have a DB ID

CCole Xemi My DB is throwing the same error now at runtime - 4b353ed3-37e1-4c99-8377-a22dda...

C

Cyb3r-Jak3•9/19/23, 1:40 AM

@slient @elithrar If you could look at this one as well when you get the chance

C

Cyb3r-Jak3•9/19/23, 1:41 AM

Sorry for the ping NotLikeThis

meant to use silent

JJeff Hey could someone check my DB it seemed to be completely bricked eb0c94ad-555b-4...

M

Matt Silverlock•9/19/23, 8:09 AM

This should be fixed now.

JJeff yea im still getting internal errors

M

Matt Silverlock•9/19/23, 8:13 AM

Got it, may have prematurely claimed victory. We’re still investigating the root cause.

S

Sylphritz•9/19/23, 8:31 AM

Is there a way to try D1 locally in, say, a Nuxt.js app in dev mode? I tried running

wrangler pages dev --proxy [nuxt dev server port] -- pnpm dev

wrangler pages dev --proxy [nuxt dev server port] -- pnpm dev

wrangler pages dev --proxy [nuxt dev server port] -- pnpm dev

wrangler pages dev --proxy [nuxt dev server port] -- pnpm dev but the

context.cloudflare

context.cloudflare

context.cloudflare

context.cloudflare and

process.env.[DB_BINDING]

process.env.[DB_BINDING]

process.env.[DB_BINDING]

process.env.[DB_BINDING] don't seem to exist when I try to access them in

defineEventHandler()

defineEventHandler()

defineEventHandler()

defineEventHandler(). I read the documentation but I'm still not clear on how exactly to approach this. Any guidance or examples would be appreciated.

SSylphritz Is there a way to try D1 locally in, say, a Nuxt.js app in dev mode? I tried run...

M

Matt Silverlock•9/19/23, 8:33 AM

Are you passing

—D1=BINDING_NAME

—D1=BINDING_NAME

—D1=BINDING_NAME

—D1=BINDING_NAME

?

SSylphritz Is there a way to try D1 locally in, say, a Nuxt.js app in dev mode? I tried run...

M

Matt Silverlock•9/19/23, 8:34 AM

In Remix: https://github.com/elithrar/remix-plus-d1/blob/7c598d00b319be8c55aa512318b5a6596169167b/package.json#L8

GitHub

remix-plus-d1/package.json at 7c598d00b319be8c55aa512318b5a65961691...

An example app for combining Cloudflare's D1 database with Remix loader functions. - elithrar/remix-plus-d1

S

Sylphritz•9/19/23, 8:41 AM

I did and it's still not working

S

Sylphritz•9/19/23, 8:41 AM

Are you supposed to build the project first?

SSylphritz Are you supposed to build the project first?

M

Matt Silverlock•9/19/23, 9:05 AM

You may be better off asking in #pages-help if

context.cloudflare.env

context.cloudflare.env

context.cloudflare.env

context.cloudflare.env is not populated.

S

Sylphritz•9/19/23, 9:05 AM

Okay, I'll do that then

CCole Xemi Not working anymore

M

Matt Silverlock•9/19/23, 9:44 AM

Still not working?

JJeff @elithrar Another database went out c4310893-6b61-46b2-8596-ec6cd641d42c

M

Matt Silverlock•9/19/23, 11:34 AM

Is there anything particular about your usage pattern before they get stuck? Are you writing data in batches? Using Time Travel? Anything at all?

JJeff Nothing at all, They are barely used. And rarely called we just started using th...

M

Max (@rozenmd)OP•9/19/23, 11:39 AM

mainly reads, never write?

J

Jure•9/19/23, 12:09 PM

Hi! Is possible to run D1 migrations in the Pages deploy script? Something like:

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name
I would like that migrations are executed at the same time as pushing the code...

JJure Hi! Is possible to run D1 migrations in the Pages deploy script? Something like:...

M

Matt Silverlock•9/19/23, 12:16 PM

Yes: remove the

local

local

local

local flag but otherwise follow this - https://developers.cloudflare.com/d1/learning/local-development/#develop-locally-with-pages

Local development · Cloudflare D1 docs

D1 has fully-featured support for local development, running the same version of D1 as Cloudflare runs globally. Local development uses Wrangler, the …

J

Jure•9/19/23, 12:28 PM

I tried with this deploy scipt:

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name

npm run build && npx wrangler d1 migrations apply db-name and got error:

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Failed: Error while executing user command. Exited with error code: 1
Failed: build command exited with code: 1
Failed: error occurred while running build command

Is this a big mentioned here?
https://github.com/cloudflare/workers-sdk/issues/3598

GitHub

🐛 BUG: D1 migration doesn't work on Github Actions · Issue #3598 · ...

Which Cloudflare product(s) does this pertain to? D1 What version of Wrangler are you using? 3.1.2 What operating system are you using? Linux Describe the Bug When I try to apply a d1 database migr...

CCole Xemi It loaded a couple times successfully then is now failing

M

Matt Silverlock•9/19/23, 1:15 PM

Yes - we fixed it at 10:20PM ET and it looks to have last responded at ~3AM ET based on our data.

F

Farhian•9/19/23, 1:54 PM

Hi guys, we are having problems with one of our D1 databases - we can't seem to be able to reach it using either the web portal or from a worker.

Similar Threads

Similar Threads

Similar Threads