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

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

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

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

I did and it's still not working

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

Are you supposed to build the project first?

SSylphritz Are you supposed to build the project first?

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

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

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

Okay, I'll do that then

CCole Xemi Not working anymore

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

Still not working?

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

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

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 Silverlock•9/19/23, 12:16 PM

Yes: remove the locallocal 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...

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

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.

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.

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

All the other databases are ok - only one seems to be acting up.

FFarhian All the other databases are ok - only one seems to be acting up.

James•9/19/23, 2:01 PM

What error are you seeing?

Internal error: failed to get DB size and num_tables

Internal error: failed to get DB size and num_tables

Farhian•9/19/23, 2:03 PM

"Failed to reach database. Please try again later."

James•9/19/23, 2:04 PM

@elithrar Seems like this error is growing - ~4 reports now I think

Farhian•9/19/23, 2:05 PM

(and I know that we 'should' not be using D1 for Prod - but we are :))

FFarhian Hi guys, we are having problems with one of our D1 databases - we can't seem to ...

Matt Silverlock•9/19/23, 2:20 PM

Please share the databaseId.

Farhian•9/19/23, 2:20 PM

sec

Farhian•9/19/23, 2:21 PM

@elithrar I've sent you the DB id in private

FFarhian @elithrar I've sent you the DB id in private

Matt Silverlock•9/19/23, 2:22 PM

Thanks. DB IDs can be public — no one can do anything with your DB ID.

Farhian•9/19/23, 2:22 PM

oh ok

Matt Silverlock•9/19/23, 2:22 PM

(I have it now, but for future)

Farhian•9/19/23, 2:23 PM

sounds good, thanks!

Farhian•9/19/23, 2:38 PM

@colexemi yes, the error from the networking tab is: "errors": [
{
"code": 7500,
"message": "Internal error: failed to get DB size and num_tables"
}
],

Matt Silverlock•9/19/23, 3:25 PM

@farhian @colexemi @Jeff -

we're looking to roll out a patch this afternoon that should address this (we believe all of your DBs are affected by this edge case).

Farhian•9/19/23, 3:25 PM

Thank you @elithrar !

dave•9/19/23, 3:27 PM

what happens if I delete a D1 database that is currently bound to two Workers?

dave•9/19/23, 3:27 PM

for context, I'm deleting a database that's in alpha, to recreate it as beta

Farhian•9/19/23, 3:30 PM

I think that the process should be (not an expert - just my thoughts)

Create the beta DB and migrate the data from the alpha
Update your worker's toml file in order to update the bindings to point the new DB
re-deploy your workers using the new bindings
delete the alpha DB

dave•9/19/23, 3:38 PM

oh, that's smarter

dave•9/19/23, 3:38 PM

I was gonna delete first lol

Farhian•9/19/23, 3:38 PM

Cyb3r-Jak3•9/19/23, 3:38 PM

I don’t think it will let you delete a binding in use

dave•9/19/23, 3:42 PM

hmm, can I have a duplicate name database though?

Farhian•9/19/23, 3:45 PM

I do not think so... what I did (which is probably NOT a good practice) was to do a backup first (you need it anyway for the migration), delete it (it did allow me to delete even if I had a worker using it) - like you I wanted to use the same name, went through the beta migration, updated the toml binding and used the new ID and then redployed the worker. In my case, it was OK to have an outage

Farhian•9/19/23, 3:52 PM

or the same one

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

Similar Threads

Similar Threads

Similar Threads