When will D1 be accessible through the Cloudflare API? What would be the best way to manually implem

When will D1 be accessible through the Cloudflare API?
What would be the best way to manually implement exporting/backup?

CretezyOP•8/23/23, 4:29 AM

Is appears probably using dump and a custom endpoint? https://developers.cloudflare.com/d1/platform/client-api/#await-dbdump

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

CCretezy When will D1 be accessible through the Cloudflare API? What would be the best wa...

chientrm.com•8/23/23, 4:30 AM

you can use this package to access D1 from outside: https://github.com/chientrm/wrangler-proxy

TTom Hi there ! I've made a url shortening service using workers & a D1 database. I...

Max (@rozenmd)•8/23/23, 3:26 PM

you could create a user-land backup using a script like d1-database

Max (@rozenmd)•8/23/23, 3:29 PM

otherwise, you can time travel via the D1 console in Cloudflare's dashboard:

TTom Hi there ! I've made a url shortening service using workers & a D1 database. I...

Dahoom•8/23/23, 10:40 PM

I recommend using this repo by Nora soderlund, it's amazing and I'm using it myself https://github.com/nora-soderlund/cloudflare-d1-backups

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.

Dahoom•8/23/23, 10:44 PM

It saves the db as an sql file which can be set to a cron job and you can easily input the created file in wrangler and reset it as shown in the md of the repo

Ben-xD•8/24/23, 8:13 AM

I'm trying to run multiple migration/sql files on a D1 database. Is there a way I can have access to the D1 binding from inside a script (so I can read sql files and execute sql into D1)? Without being a "module worker" or "service worker"

Mikyari•8/24/23, 8:23 AM

Is procedure is available to use in D1 for now?

Mikyari•8/24/23, 8:23 AM

I did not see it in docs, but only this article: https://blog.cloudflare.com/whats-new-with-d1/

The Cloudflare Blog

D1: our quest to simplify databases

Get an inside look on the D1 experience today, what the team is currently working on and what’s coming up!

BBen-xD I'm trying to run multiple migration/sql files on a D1 database. Is there a way ...

advanced•8/24/23, 8:59 AM

you can try cfw-bindings-wrangler-bridge or the latest version of miniflare with getBindings api

BBen-xD I'm trying to run multiple migration/sql files on a D1 database. Is there a way ...

chientrm.com•8/24/23, 9:00 AM

https://github.com/chientrm/wrangler-proxy

Ssourabh.sashank Database Id: 08c3458c-812d-48bf-801d-5a87b4649f49 Not opening in dashboard, con...

Max (@rozenmd)•8/24/23, 9:09 AM

looks like an overloaded db using the old backend, would recommend the new backend

Ssourabh.sashank Can't we upgrade the same DB to be using new backend ?

Max (@rozenmd)•8/24/23, 10:35 AM

You'll need to export your database: https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally
and import it into a new database running on the new backend: https://developers.cloudflare.com/d1/learning/importing-data/#import-an-existing-database

James•8/25/23, 1:06 AM

What does your worker look like? It has to be in modules format to use D1 from that error: https://developers.cloudflare.com/workers/learning/migrate-to-module-workers/

Migrate to ES modules format · Cloudflare Workers docs

This guide will show you how to migrate your Workers from the Service Worker format to the ES modules format.

SStar Bright I migrated it but now I'm getting ```js errors: [ { code: 10021, ...

Matt Silverlock•8/25/23, 7:08 AM

Make sure you’re uploading it as a module Worker.

SStar Bright I migrated it but now I'm getting ```js errors: [ { code: 10021, ...

Matt Silverlock•8/25/23, 7:09 AM

d1-database

chientrm.com•8/25/23, 12:31 PM

No.1 reason why I love D1?
Because I'm an SQL fetish.

rob•8/26/23, 12:19 AM

D1 bindings require module-format workers. [code: 10021]

rob•8/26/23, 12:19 AM

What do i need to do in my wrangler ?

Rrob What do i need to do in my wrangler ?

itsmatteomanf•8/26/23, 12:45 AM

Read the conversation just above

d1-database

rob•8/26/23, 1:04 AM

hey i fixed it! now im having an issue

rob•8/26/23, 1:05 AM

[[d1_databases]]
binding = "clickDB" # i.e. available in your Worker on env.clickDB
database_name = "click-db"
database_id = "XXXXXXXX"

[[d1_databases]]
binding = "clickDB" # i.e. available in your Worker on env.clickDB
database_name = "click-db"
database_id = "XXXXXXXX"

rob•8/26/23, 1:05 AM

I deploy and it says my worker has access to - D1 Databases:
- clickDB: click-db

rob•8/26/23, 1:05 AM

I get this error tho: TypeError: env.clickDB.put is not a function

Rrob I get this error tho: TypeError: env.clickDB.put is not a function

itsmatteomanf•8/26/23, 1:06 AM

Because it's not

itsmatteomanf•8/26/23, 1:06 AM

Read the docs.
https://developers.cloudflare.com/d1/platform/client-api/

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

rob•8/26/23, 1:06 AM

rob•8/26/23, 1:06 AM

rob•8/26/23, 1:07 AM

got it

chientrm.com•8/26/23, 8:50 AM

Although I only have 12 users registered,
How would you recommend me to implement Snowflake Ids with multiple D1 databases binded?

chientrm.com•8/26/23, 8:51 AM

Replace

Worker ID

Worker ID

with

DatabaseId

DatabaseId

Cchientrm.com Although I only have 12 users registered, How would you recommend me to implemen...

Matt Silverlock•8/26/23, 11:22 AM

Generate it in your app at insert time? Do you want to use it as the primary key column?

MMatt Silverlock Generate it in your app at insert time? Do you want to use it as the primary key...

chientrm.com•8/26/23, 11:32 AM

yes.

chientrm.com•8/26/23, 11:36 AM

so there are

timestamp

timestamp

worker_id

worker_id

and

sequence_id

sequence_id

.
Because

sequence_id

sequence_id

is autoincrement and reset to 0 when it touch the highest value

(12 bits).

chientrm.com•8/26/23, 11:36 AM

I can't find an sql function implementation for

snowflake_id(worker_id)

snowflake_id(worker_id)

chientrm.com•8/26/23, 11:38 AM

and idk how to

When will D1 be accessible through the Cloudflare API? What would be the best way to manually implem

Similar Threads

Similar Threads

Similar Threads