https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem

D1 now returns a count of rows_written and rows_read for every query executed, allowing you to assess the cost of query for both pricing and index …

MMatt Silverlock https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem

dave•9/18/23, 3:57 PM

thanks, turns out my error was with the batch size

dave•9/18/23, 3:57 PM

turning it down to 1 fixed the issue

Ddave I'm getting this error when I attempt to run things on a remote database: ``` ...

Max (@rozenmd)•9/18/23, 4:47 PM

is this

wrangler d1 execute

wrangler d1 execute

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

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

yes

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

Is using a remote D1 database with

wrangler dev

wrangler dev

no longer possible?

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?

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

I believe the —remote—remote flag should

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?

Max (@rozenmd)•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

Max (@rozenmd)•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.

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

Is there an easy way to migrate?

Ddave Is there an easy way to migrate?

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?

Max (@rozenmd)•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?

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...

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?

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

Looking now (have been in meetings)

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

Thank you

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

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...

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...

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

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

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...

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

This should be fixed now.

JJeff yea im still getting internal errors

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

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

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 devwrangler pages dev --proxy [nuxt dev server port] -- pnpm dev but the context.cloudflarecontext.cloudflare and process.env.[DB_BINDING]process.env.[DB_BINDING] don't seem to exist when I try to access them in 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...

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

Are you passing —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...

Matt SilverlockOP•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

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

I did and it's still not working

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

Are you supposed to build the project first?

SSylphritz Are you supposed to build the project first?

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

You may be better off asking in #pages-help if context.cloudflare.envcontext.cloudflare.env is not populated.

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

Okay, I'll do that then

CCole Xemi Not working anymore

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

Still not working?

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

Matt SilverlockOP•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...

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

mainly reads, never write?

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-namenpm 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:...

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

Yes: remove the

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 …

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

I tried with this deploy scipt: npm run build && npx wrangler d1 migrations apply db-namenpm 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

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...

https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem

Similar Threads