I'm getting this error when I attempt to run things on a remote database: ``` A prepared SQL stat

D

daveOP•9/18/23, 3:02 PM

but it works locally

D

daveOP•9/18/23, 3:02 PM

with

--local

--local

--local

--local

MMatt Silverlock Are you using the new backend? Executed as-is for me. ```sh ~/repos/d1 (main) ✔ ...

D

daveOP•9/18/23, 3:06 PM

How can I check if I'm using the new backend?

┌───────────────────┬──────────────────────────────────────┐
│                   │ removed-removed-removed-removed-     │
├───────────────────┼──────────────────────────────────────┤
│ name              │ removed-worker-d1                    │
├───────────────────┼──────────────────────────────────────┤
│ created_at        │ 2023-09-09T03:49:34.773Z             │
├───────────────────┼──────────────────────────────────────┤
│ version           │ beta                                 │
├───────────────────┼──────────────────────────────────────┤
│ num_tables        │ 6                                    │
├───────────────────┼──────────────────────────────────────┤
│ running_in_region │ ENAM                                 │
├───────────────────┼──────────────────────────────────────┤
│ database_size     │ 2.59 MB                              │
├───────────────────┼──────────────────────────────────────┤
│ read_queries_24h  │ 533                                  │
├───────────────────┼──────────────────────────────────────┤
│ write_queries_24h │ 755                                  │
└───────────────────┴──────────────────────────────────────┘

┌───────────────────┬──────────────────────────────────────┐
│                   │ removed-removed-removed-removed-     │
├───────────────────┼──────────────────────────────────────┤
│ name              │ removed-worker-d1                    │
├───────────────────┼──────────────────────────────────────┤
│ created_at        │ 2023-09-09T03:49:34.773Z             │
├───────────────────┼──────────────────────────────────────┤
│ version           │ beta                                 │
├───────────────────┼──────────────────────────────────────┤
│ num_tables        │ 6                                    │
├───────────────────┼──────────────────────────────────────┤
│ running_in_region │ ENAM                                 │
├───────────────────┼──────────────────────────────────────┤
│ database_size     │ 2.59 MB                              │
├───────────────────┼──────────────────────────────────────┤
│ read_queries_24h  │ 533                                  │
├───────────────────┼──────────────────────────────────────┤
│ write_queries_24h │ 755                                  │
└───────────────────┴──────────────────────────────────────┘

┌───────────────────┬──────────────────────────────────────┐
│                   │ removed-removed-removed-removed-     │
├───────────────────┼──────────────────────────────────────┤
│ name              │ removed-worker-d1                    │
├───────────────────┼──────────────────────────────────────┤
│ created_at        │ 2023-09-09T03:49:34.773Z             │
├───────────────────┼──────────────────────────────────────┤
│ version           │ beta                                 │
├───────────────────┼──────────────────────────────────────┤
│ num_tables        │ 6                                    │
├───────────────────┼──────────────────────────────────────┤
│ running_in_region │ ENAM                                 │
├───────────────────┼──────────────────────────────────────┤
│ database_size     │ 2.59 MB                              │
├───────────────────┼──────────────────────────────────────┤
│ read_queries_24h  │ 533                                  │
├───────────────────┼──────────────────────────────────────┤
│ write_queries_24h │ 755                                  │
└───────────────────┴──────────────────────────────────────┘

┌───────────────────┬──────────────────────────────────────┐
│                   │ removed-removed-removed-removed-     │
├───────────────────┼──────────────────────────────────────┤
│ name              │ removed-worker-d1                    │
├───────────────────┼──────────────────────────────────────┤
│ created_at        │ 2023-09-09T03:49:34.773Z             │
├───────────────────┼──────────────────────────────────────┤
│ version           │ beta                                 │
├───────────────────┼──────────────────────────────────────┤
│ num_tables        │ 6                                    │
├───────────────────┼──────────────────────────────────────┤
│ running_in_region │ ENAM                                 │
├───────────────────┼──────────────────────────────────────┤
│ database_size     │ 2.59 MB                              │
├───────────────────┼──────────────────────────────────────┤
│ read_queries_24h  │ 533                                  │
├───────────────────┼──────────────────────────────────────┤
│ write_queries_24h │ 755                                  │
└───────────────────┴──────────────────────────────────────┘

Ooxygencraft I'm trying to setup the schema on my D1 database but when I run the wrangler com...

D

daveOP•9/18/23, 3:06 PM

Did you find a solution for this?

Ddave How can I check if I'm using the new backend? ``` ┌───────────────────┬────────...

I

Isaac McFadyen•9/18/23, 3:23 PM

You are. New is beta and old is alpha.

Ooxygencraft I'm trying to setup the schema on my D1 database but when I run the wrangler com...

D

daveOP•9/18/23, 3:31 PM

I found this as a solution:

--batch-size 1

--batch-size 1

--batch-size 1

--batch-size 1

Ddave How can I check if I'm using the new backend? ``` ┌───────────────────┬────────...

M

Matt Silverlock•9/18/23, 3:56 PM

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

Changelog · Cloudflare D1 docs

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

D

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

thanks, turns out my error was with the batch size

D

daveOP•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: ``` ...

M

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

is this

wrangler d1 execute

wrangler d1 execute

wrangler d1 execute

wrangler d1 execute?

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

D

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

yes

D

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

Is using a remote D1 database with

wrangler dev

wrangler dev

no longer possible?

D

daveOP•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

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

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

daveOP•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