I think this falls under the `beta` banner. Afaik they do still intend to have a way to dump the DB

HHello, I’m Allie!I think this falls under the `beta` banner. Afaik they do still intend to have a...

P

Paul•10/31/23, 3:29 PM

Oh excellent.

PPaul Oh excellent.

D

Dahoom•10/31/23, 5:17 PM

https://github.com/nora-soderlund/cloudflare-d1-backups in the meantime you can use this

GitHub

GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a ...

A package to dump a copy of your experimental D1 database through a worker. - GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a copy of your experimental D1 database through a worker.

D

Dahoom•10/31/23, 5:19 PM

There should be a discord bot that scans for keywords like "export" and "dump" in this channel and automatically posts this url

Original message was deleted

M

Max (@rozenmd)•10/31/23, 8:52 PM

was on holiday, will get on it

G

GuillaumeLakano•11/1/23, 4:30 PM

Hi! I'm trying to dynamically create D1 database with the CF API, and then to PATCH the script bindings to permit to my worker to reach the new D1 database.
The dynamic creation works great, but the PATCH return me this error:

{
            "result": null,
            "success": false,
            "errors": [
              {
                "code": 10001,
                "message": "workers.api.error.content_type"
              }
            ],
            "messages": []
          }

{
            "result": null,
            "success": false,
            "errors": [
              {
                "code": 10001,
                "message": "workers.api.error.content_type"
              }
            ],
            "messages": []
          }

{
            "result": null,
            "success": false,
            "errors": [
              {
                "code": 10001,
                "message": "workers.api.error.content_type"
              }
            ],
            "messages": []
          }

{
            "result": null,
            "success": false,
            "errors": [
              {
                "code": 10001,
                "message": "workers.api.error.content_type"
              }
            ],
            "messages": []
          }

I'm not sure of how to adapt the documentation for the bindings specificity of D1:
https://developers.cloudflare.com/api/operations/worker-script-get-settings

I've tried multiple things:

{
    bindings: [
        { type: 'd1_databases', database_name: name, database_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', database_name: name, database_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', database_name: name, database_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', database_name: name, database_id: uuid }
    ]
}

and

{
    bindings: [
        { type: 'd1_databases', name, namespace_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', name, namespace_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', name, namespace_id: uuid }
    ]
}

{
    bindings: [
        { type: 'd1_databases', name, namespace_id: uuid }
    ]
}

If someone have some ideas to help

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

K

kian•11/1/23, 4:32 PM

Are you using FormData?

K

kian•11/1/23, 4:32 PM

K

kian•11/1/23, 4:32 PM

It sounds like you're only sending JSON.

K

kian•11/1/23, 4:33 PM

It should be FormData, with a

settings

settings

settings

settings key whose value is a stringified object

G

GuillaumeLakano•11/1/23, 4:37 PM

Oh good point, I'll try, thank you @kian !

B

Bram•11/1/23, 7:19 PM

Hi, for my use case I have to store large blobs of JSON (3-10MB files). My idea was to combine D1 (for metadata) and R2 (for blob storage). I was wondering if it is possible to write to both in a transactional way? Is there some kind of transaction API that I could use?

B

Bram•11/1/23, 7:22 PM

Hmm now I think about it, I would probably be better of having the user upload directly to R2 with signed urls?

B

Bram•11/1/23, 7:27 PM

or maybe not:

Typically, you will not share presigned URLs directly with end users or browsers, as presigned URLs are used more for internal applications.

B

Bram•11/1/23, 7:31 PM

Is it easy to subscribe to an event for when R2 is done uploading a new file?

B

Bram•11/1/23, 7:36 PM

ok thanks for the info

Original message was deleted

B

Bram•11/1/23, 7:36 PM

and yea that is true, will take the discussion there

J

jahir9991•11/2/23, 9:27 AM

In batch api how can use data from previous statement to the next statement like we do in db transactions ?

Z

zegevlier•11/2/23, 11:50 AM

Are you seeing this inside the worker, or using something like wrangler?

Z

zegevlier•11/2/23, 11:53 AM

Alright, that's likely related to the dashboard being unavailable. We've escalated it, thank you for reporting

Z

zegevlier•11/2/23, 11:56 AM

Status page: https://www.cloudflarestatus.com/incidents/hm7491k53ppg

Cloudflare Dashboard and Cloudflare API service issues

P

Paul•11/2/23, 5:51 PM

Doesn't seem like there's anyway to reach the d1 database during this outage. it's weird too since the website still works and insert/retreives rows just fine.

PPaul Doesn't seem like there's anyway to reach the d1 database during this outage. it...

C

Cyb3r-Jak3•11/2/23, 6:05 PM

The API was effected more than the edge services

CCyb3r-Jak3 The API was effected more than the edge services

P

Paul•11/2/23, 6:54 PM

haha damn, i might have to deploy a full admin dashboard just in case this stuff happens again

W

w3bcode•11/2/23, 8:03 PM

Hello team

Is there a way to dynamically create d1 databases per user and bind it to worker ?

Ww3bcode Hello team Is there a way to dynamically create d1 databases per user and bind ...

C

Cyb3r-Jak3•11/2/23, 8:27 PM

Not yet but it is planned with no ETA.

P

Pascale•11/3/23, 1:04 AM

What database size can we expect once d1 leaves beta? We hit that 2GB limit fairly early

P

Paul Shriner•11/3/23, 1:47 AM

Pretty sure that D1 may be the last thing restored

P

Paul•11/3/23, 2:44 AM

I’ve got a huge pitch tomorrow at noon. I am praying to the cloudflare gods it’s all fixed by then

PPaul I’ve got a huge pitch tomorrow at noon. I am praying to the cloudflare gods it’s...

P

Paul Shriner•11/3/23, 2:48 AM

I have arleady rescheduled

AAlCalzone Is there a good way to import large amounts of data into D1? What I'm doing now ...

J

JuProxy•11/3/23, 3:42 AM

Same question here, would like to how a good way of importing data plus1green

VViper Is D1 currently down?

L

limikael•11/3/23, 7:25 AM

Came here to ask the exact same thing...

L

limikael•11/3/23, 7:28 AM

My symptoms are: My site currently works and it seems like it can access the database (so working so far)... However, when I try to deploy a new version I get an error: "binding DB of type d1 failed to generate. Please try again later or contact support. [code: 10021]". Also, when trying to go to the D1 page in the Dashboard it just loads indefinitely... Hopefully something temporary! Will try again in a few hours...

VViper Is D1 currently down?

D

Dan•11/3/23, 8:38 AM

was gonna ask the same. Can't create a new DB from the UI or via Wrangler

M

Max (@rozenmd)•11/3/23, 9:12 AM

D1 databases are still up, API operations seem to be impacted by https://www.cloudflarestatus.com/incidents/hm7491k53ppg

Cloudflare Dashboard and Cloudflare API service issues

MMax (@rozenmd)D1 databases are still up, API operations seem to be impacted by https://www.clo...

L

limikael•11/3/23, 9:28 AM

Thanks! Btw, how should error code 10021 be interpreted? I googled and also spent some time searching the docs but couldn't find anything...

K

kian•11/3/23, 9:30 AM

10021 is a very generic Workers API error

K

kian•11/3/23, 9:30 AM

Could be a syntax error in your script, internal error in the API, etc

MMax (@rozenmd)D1 databases are still up, API operations seem to be impacted by https://www.clo...

M

morpig•11/3/23, 9:35 AM

same thing happening to hyperdrive..

  binding HYPERDRIVE of type hyperdrive failed to generate: Failed to perform request against sqc-config: Get
  "https://sqc-config-production.sd.cfplat.com/apiv4/internal/databases/xxx/binding-user":
  dial tcp 198.41.251.57:443: i/o timeout (Client.Timeout exceeded while awaiting headers). [code:
  10021]

  binding HYPERDRIVE of type hyperdrive failed to generate: Failed to perform request against sqc-config: Get
  "https://sqc-config-production.sd.cfplat.com/apiv4/internal/databases/xxx/binding-user":
  dial tcp 198.41.251.57:443: i/o timeout (Client.Timeout exceeded while awaiting headers). [code:
  10021]

  binding HYPERDRIVE of type hyperdrive failed to generate: Failed to perform request against sqc-config: Get
  "https://sqc-config-production.sd.cfplat.com/apiv4/internal/databases/xxx/binding-user":
  dial tcp 198.41.251.57:443: i/o timeout (Client.Timeout exceeded while awaiting headers). [code:
  10021]

  binding HYPERDRIVE of type hyperdrive failed to generate: Failed to perform request against sqc-config: Get
  "https://sqc-config-production.sd.cfplat.com/apiv4/internal/databases/xxx/binding-user":
  dial tcp 198.41.251.57:443: i/o timeout (Client.Timeout exceeded while awaiting headers). [code:
  10021]

Ɇ

Ɇ₦ĐɆⱤV₳₥₱łⱤɆ•11/3/23, 9:36 AM

can’t wait for d1 v2.0.0, call it the sequel.

I think this falls under the `beta` banner. Afaik they do still intend to have a way to dump the DB

Similar Threads