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

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 SilverlockOP•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 SilverlockOP•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 SilverlockOP•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 SilverlockOP•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_ERRORD1_ERROR message when trying to do any kind of prepareprepare 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 SilverlockOP•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-fdf4530fb192668d0e1f-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"
}

Matt SilverlockOP•5/19/23, 1:02 PM

Big new updates to D1 incoming: https://blog.cloudflare.com/d1-turning-it-up-to-11/

The Cloudflare Blog

D1: We turned it up to 11

We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.

Mozzy•5/19/23, 1:03 PM

Jason Hostetter•5/19/23, 1:33 PM

when we enable global read replication, you won’t have to pay extra for it, nor will replication multiply your storage consumption.

when we enable global read replication, you won’t have to pay extra for it, nor will replication multiply your storage consumption.

Jason Hostetter•5/19/23, 1:34 PM

very excited, amazing work

MMatt Silverlock Big new updates to D1 incoming: https://blog.cloudflare.com/d1-turning-it-up-to-...

João Castro•5/19/23, 1:38 PM

this is reeeeally cool

Mozzy•5/19/23, 1:43 PM

What would be the ideal way to migrate an existing DB to the Beta/experimental version?

MMozzy What would be the ideal way to migrate an existing DB to the Beta/experimental v...

Matt SilverlockOP•5/19/23, 1:45 PM

Backup + download locally (https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally) -> convert to text format (https://developers.cloudflare.com/d1/learning/importing-data/#converting-sqlite-database-files) -> import (https://developers.cloudflare.com/d1/learning/importing-data/#import-an-existing-database).

Mozzy•5/19/23, 1:47 PM

Is this not correct?
data.sqlite3 is the file received from downloading the backup (but renamed)

MMozzy Is this not correct? data.sqlite3 is the file received from downloading the back...

Matt SilverlockOP•5/19/23, 1:48 PM

Don't open the shell. Just invoke it directly.

Original message was deleted

Matt SilverlockOP•5/19/23, 1:49 PM

https://github.com/cloudflare/cloudflare-docs/pull/9005

MMatt Silverlock Don't open the shell. Just invoke it directly.

Mozzy•5/19/23, 1:51 PM

Ahh, thanks

Matt SilverlockOP•5/19/23, 1:54 PM

https://twitter.com/KentonVarda/status/1659551757796515846?s=20 for those that want to understand a bit more about how our new storage backend works under the hood

Kenton Varda (@KentonVarda)

So I've spent the last ~three months writing a new distributed storage engine based on SQLite and it has been FUN!

https://t.co/NVorwS46x8