If you upgrade to wrangler v3, the local database will be in a different location `./.wrangler/state

If you upgrade to wrangler v3, the local database will be in a different location

./.wrangler/state/v3/d1/<UUID>/db.sqlite

./.wrangler/state/v3/d1/<UUID>/db.sqlite

./.wrangler/state/v3/d1/<UUID>/db.sqlite

./.wrangler/state/v3/d1/<UUID>/db.sqlite instead of

./.wrangler/state/d1/DB.sqlite3

./.wrangler/state/d1/DB.sqlite3

./.wrangler/state/d1/DB.sqlite3

./.wrangler/state/d1/DB.sqlite3

I think it might be as simple as copying it over to the new location, but I haven't tried it myself.

Ttequila @betims @a11hard this might be the cause https://github.com/cloudflare/workers...

betim•5/17/23, 7:21 PM

thanks... that was it. after re-running the DB migrations, with a fresh D1 DB I was able to get things going again..

betim•5/17/23, 7:33 PM

I meant schema migrations, not data, ie. wrangler d1 migration apply ...wrangler d1 migration apply ...

Ttequila could you share the commands that you used? Maybe wrangler itself is capable of ...

Max (@rozenmd)OP•5/17/23, 7:55 PM

feel free to suggest it in #wrangler

Ttequila nope, I use `persist-to` with exactly the same location and it does not work

Max (@rozenmd)OP•5/17/23, 7:57 PM

note that the filename is different, you need to actually copy the file over and change the name

Yyamiteru I'm having the same issues

Max (@rozenmd)OP•5/17/23, 9:41 PM

does this help d1-database

CConfusedcius In the documentation, it says that backups are retained for 24 hours under the a...

Matt Silverlock•5/17/23, 11:39 PM

We only commit to storing backups for 24 hours right now, during the alpha. They may persist for longer, but (as an alpha product) it’s not final.

We’ll be moving away from full snapshots to something much better. Keep an eye on the blog on Friday

MMatt Silverlock We only commit to storing backups for 24 hours right now, during the alpha. They...

Sameer Ali•5/18/23, 3:10 AM

Can't wait for the Friday. Hopefully, we'll hear news about limit increase

DDavid (GMT-7)I'm using next.js on cloudflare pages and I'm able to connect a d1 database and ...

muslax•5/18/23, 6:51 AM

Hi, how and where do you setup the binding? Any example? Been struggling for weeks.

Ssourabh.sashank In wrangler .toml file. https://developers.cloudflare.com/d1/get-started/#4-bin...

muslax•5/18/23, 7:18 AM

But this is for workers, right? I read somewhere that Pages doesn’t support wrangler.toml.

muslax•5/18/23, 7:19 AM

I asked @asdf2 because he/she uses Nextjs, so I assume it’s Pages.

Mmuslax Hi, how and where do you setup the binding? Any example? Been struggling for wee...

Matt Silverlock•5/18/23, 9:46 AM

https://developers.cloudflare.com/d1/learning/using-d1-from-pages/

Bindings · Cloudflare Pages docs

A binding enables your Pages Functions to interact with resources on the Cloudflare developer platform. Use bindings to integrate your Pages Functions …

Ssourabh.sashank Can We directly insert JSON array of Objects as rows in batch to D1 ? If Yes, C...

Matt Silverlock•5/18/23, 10:26 AM

What have you tried? The draft documentation you linked is very close. Something like the below should work, depending on what you're trying to achieve:

INSERT INTO table(col1,col2)
SELECT key, value
FROM json_each('[55,66,77]')

INSERT INTO table(col1,col2)
SELECT key, value
FROM json_each('[55,66,77]')

… would attempt to insert the below values into col1,col2:

0,55
1,66
2,77

0,55
1,66
2,77

MMatt Silverlock https://developers.cloudflare.com/d1/learning/using-d1-from-pages/

muslax•5/18/23, 12:22 PM

Ty new doc.

ömer•5/18/23, 1:15 PM

hey hey, is there a way to create tests for d1 locally?

ömer•5/18/23, 1:15 PM

like spinning up a local sqlite?

Öömer hey hey, is there a way to create tests for d1 locally?

Matt Silverlock•5/18/23, 1:19 PM

https://developers.cloudflare.com/workers/wrangler/commands/#dev

```
wrangler dev
```
```
wrangler dev
```

Commands · Cloudflare Workers docs

Wrangler offers a number of commands to manage your Cloudflare Workers.

Öömer hey hey, is there a way to create tests for d1 locally?

Matt Silverlock•5/18/23, 1:20 PM

And https://developers.cloudflare.com/d1/get-started/#6-develop-locally-with-wrangler

Get started · Cloudflare D1 docs

This guide will instruct you through setting up and deploying your first database with D1. This guide assumes you already have a Cloudflare account.

MMatt Silverlock And https://developers.cloudflare.com/d1/get-started/#6-develop-locally-with-wra...

ömer•5/18/23, 2:09 PM

i meant unit testing sorry

Öömer i meant unit testing sorry

Matt Silverlock•5/18/23, 2:20 PM

@mrbbot might have a good example when they're around

Murder Chicken•5/18/23, 7:56 PM

With Wrangler v3 and the deprecation of

--local

--local

and

--persist

--persist

, how can we request Pages use a local copy of the DB in the .wrangler directory?

Murder Chicken•5/18/23, 8:46 PM

Yup. I've gotten to the point where I'm here: https://github.com/cloudflare/workers-sdk/issues/3244

GitHub

🐛 BUG: local dev persistence location changed - upgraded projects s...

Which Cloudflare product(s) does this pertain to? Wrangler What version of Wrangler are you using? 3.0.0 What operating system are you using? Mac Describe the Bug If you upgrade to wrangler v3, the...

Murder Chicken•5/18/23, 8:47 PM

Moved the sqlite DB to the new storage directory with UUID. Now I'm just getting

D1_ERROR

D1_ERROR

message when trying to do any kind of

prepare

prepare

statement.

Murder Chicken•5/18/23, 8:48 PM

The sqlite DB files?

Murder Chicken•5/18/23, 8:49 PM

Ahhh. What I was trying to figure out is how to get Pages to initiate a local DB file.

Murder Chicken•5/18/23, 8:50 PM

Is there a way to have local Pages dev utilize the actual remote binding and DB?

Murder Chicken•5/18/23, 8:50 PM

In the mean time...

Original message was deleted

Murder Chicken•5/18/23, 8:50 PM

Yup. It created the directory but not the sqlite file, which was odd.

Murder Chicken•5/18/23, 8:51 PM

It also created the v3 dir but not the UUID subfolder. Which makes sense because I'm not sure where that would be specified locally in config.

Mozzy•5/19/23, 11:32 AM

Is D1 having an especially hard time currently?

MMozzy Is D1 having an especially hard time currently?

Matt Silverlock•5/19/23, 12:17 PM

There's nothing service wide. Can you expand on what you're seeing/the issue you're having?

Mozzy•5/19/23, 12:18 PM

I saw an increase in D1_ERROR 500

Mozzy•5/19/23, 12:22 PM

This is also having a hard time loading

Mozzy•5/19/23, 12:22 PM

668d0e1f-b01a-4048-8796-fdf4530fb192

668d0e1f-b01a-4048-8796-fdf4530fb192

Mozzy•5/19/23, 12:23 PM

General issues POSTing to the DB

{
  "message": "D1_ERROR",
  "cause": "Error: Error 9000: something went wrong"
}

{
  "message": "D1_ERROR",
  "cause": "Error: Error 9000: something went wrong"
}

If you upgrade to wrangler v3, the local database will be in a different location `./.wrangler/state

Similar Threads

Similar Threads

Similar Threads