Ah I think i get it. Because it's happening every minute for the last 30 days, i can just supply it

PPaul Ah I think i get it. Because it's happening every minute for the last 30 days, i...

H

You need the ID of the backup first:

$ wrangler d1 backup download example-db 123a81a2-ab91-4c2e-8ebc-64d69633faf1

$ wrangler d1 backup download example-db 123a81a2-ab91-4c2e-8ebc-64d69633faf1

$ wrangler d1 backup download example-db 123a81a2-ab91-4c2e-8ebc-64d69633faf1

$ wrangler d1 backup download example-db 123a81a2-ab91-4c2e-8ebc-64d69633faf1

P

PaulOP•10/31/23, 3:26 PM

I don't think the

backup

backup

backup

backup works anymore on beta?

H

Hello, I’m Allie!•10/31/23, 3:26 PM

Oh wait

H

Hello, I’m Allie!•10/31/23, 3:26 PM

Ur right

PPaul I don't think the `backup` works anymore on beta?

H

Hello, I’m Allie!•10/31/23, 3:27 PM

Yeah, then what you said should work fine

P

PaulOP•10/31/23, 3:27 PM

which is honestly a bit concering, i'd like to be able to easily export my entire database as standard sql

P

PaulOP•10/31/23, 3:27 PM

i feel like time-travel is a form of lock-in

P

PaulOP•10/31/23, 3:28 PM

it's an excellent feature for sure, but it's still very important for me to be able to down the entirety of my database, so I can load it up in a local client and play with it

PPaul it's an excellent feature for sure, but it's still very important for me to be a...

H

Hello, I’m Allie!•10/31/23, 3:28 PM

I think this falls under the

beta

beta

banner. Afaik they do still intend to have a way to dump the DB at some point

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

P

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

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

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

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

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

Ah I think i get it. Because it's happening every minute for the last 30 days, i can just supply it

Similar Threads

Similar Threads

Similar Threads