I want to create a new DB for each client, I guess best way it is to use CF API (https://developers.

I want to create a new DB for each client, I guess best way it is to use CF API (https://developers.cloudflare.com/api/operations/cloudflare-d1-create-database). But then how could I dynamically query the selected DB from the worker? (I don't want to query via API, but somehow bind it dynamically if it's possible)

kian•11/3/23, 10:11 AM

There is no dynamic bindings available currently

kian•11/3/23, 10:12 AM

d1-database

KuririnOP•11/3/23, 10:13 AM

ok, thanks

KKuririn I want to create a new DB for each client, I guess best way it is to use CF API ...

GuillaumeLakano•11/3/23, 10:25 AM

It's what we doing right now, the DB creation seems to works dynamically, but to inject the new D1 binding in the script, this not works for us ( workers-and-pages-helpworkers.api.error.invalid_script_config error 10202 )

GGuillaumeLakano It's what we doing right now, the DB creation seems to works dynamically, but to...

kian•11/3/23, 10:26 AM

It's a PATCHPATCH, but not really - you need to GETGET, upsert your new bindings, and then PATCHPATCH with the full set of settings.

kian•11/3/23, 10:26 AM

You seem to be doing that, so what's the error?

Kkian It's a `PATCH`, but not really - you need to `GET`, upsert your new bindings, an...

GuillaumeLakano•11/3/23, 10:29 AM

yep, it's what I've done as explained in the message, but I always receive the same error.
I've tried to do a GET of full settings and then to inject the new bindings, and to apply with a PATCH ( in form-data )
I've also tried to only PATCH the settings object with only the 'bindings' array inside
The only things working is if I'm creating a new binding with only one entry, but all previous are destroyed ( and from a HTTP PATCH philosophy, this should be better to only PATCH and not replace like a HTTP PUT )

Kkian You seem to be doing that, so what's the error?

GuillaumeLakano•11/3/23, 10:30 AM

workers.api.error.invalid_script_config error 10202

GuillaumeLakano•11/3/23, 10:30 AM

workers-and-pages-helpworkers.api.error.invalid_script_config error 10202 ( the link of thread )

kian•11/3/23, 10:56 AM

The incident is still on-going at the moment. There is no ETA for when it will be resolved.

kian•11/3/23, 10:56 AM

You can follow https://www.cloudflarestatus.com/incidents/hm7491k53ppg for updates.

_tweak^prone•11/3/23, 11:12 AM

I was just about to make my first D1 database yesterday, when this incident hit

I was so excited to move stuff to CF - and then boom.

_tweak^prone•11/3/23, 11:14 AM

Anyone has experience with https://github.com/renoki-co/l1 ? Does it work "just as a wrapper" where migrations, models, eloquent etc from Laravel is still available ?

Paul Shriner•11/3/23, 11:14 AM

D1 is in beta, which means, "It's gonna break y'all" so do not make this mission critical. While it sucks, it also means that every other service is in front of it regarding restoration.

The said that the issue was a power outage, I am guessing that they have to restore from full backup and the adjust configurations.

I can only imagine the size of a cloudflare backup.

PPaul Shriner D1 is in beta, which means, "It's gonna break y'all" so do not make this mission...

_tweak^prone•11/3/23, 11:15 AM

Yearh, I bet they cant do with the 16tb synology i got rocking

Dahoom•11/3/23, 11:15 AM

I want to read the upcoming blog post from this incident, some very unexpected stuff has to happen if cloudflare API is down for this long

Matt Silverlock•11/3/23, 11:21 AM

We’re currently working on bringing the D1 API back up. As before, existing D1 deployments/databases continue to operate and were not impacted.

omar4289•11/3/23, 11:28 AM

Why do we have a lot of stability issues in Cloudflare ? Everyday, a new issue happens

__tweak^prone Anyone has experience with https://github.com/renoki-co/l1 ? Does it work "just ...

Pascale•11/3/23, 12:00 PM

I have tried it in a PoC - yes, exactly. as long as the generated SQL is compatible with Cloudflare, that should work as you think it would.

PPascale I have tried it in a PoC - yes, exactly. as long as the generated SQL is compati...

_tweak^prone•11/3/23, 12:03 PM

Nice, thanks

Oomar4289 Why do we have a lot of stability issues in Cloudflare ? Everyday, a new issue h...

GuillaumeLakano•11/3/23, 12:04 PM

May be the series law

But the good point is, each time, the staff take time to create a blog article to explain why, to explain how they fix it to prevent this happening again. Nothing is never perfect, but at least, they're transparent and try to improve each time on theses outages

Oomar4289 Why do we have a lot of stability issues in Cloudflare ? Everyday, a new issue h...

Matthijs•11/3/23, 12:14 PM

guess it's just bad luck, we've been using Cloudflare on many products we've build and it's been really stable but this week is just bad luck, and this incident is a different magnitude

MMatt Silverlock We’re currently working on bringing the D1 API back up. As before, existing D1 d...

Paul Shriner•11/3/23, 1:29 PM

I am team Matt!

MMatt Silverlock We’re currently working on bringing the D1 API back up. As before, existing D1 d...

Paul Shriner•11/3/23, 1:33 PM

I know it is probably too early to ask this question, but do you have any kind of ETA on that, are we talking minutes, hours or days?

GuillaumeLakano•11/3/23, 2:07 PM

What is the maximum number of tables we can create per database please? The documentation doesn't mention this https://developers.cloudflare.com/d1/platform/limits/

To prevent to have a huge table of stats that growing everyday, we want after each day (or may be hour) to move the rows from the main table to a new dynamically created table « archive_stats_YYMMDD », but we don't known if we'll reach a D1 limit at some points.

Limits · Cloudflare D1 docs

Many of these limits will increase during D1’s public beta. Join the #d1-beta channel in the Cloudflare Developer Discord or subscribe to D1’s public …

Cyb3r-Jak3•11/3/23, 2:26 PM

I don’t believe there is a max number of tables.

Dahoom•11/3/23, 2:30 PM

sqlite max is ~2b i believe

Paul•11/3/23, 2:30 PM

Anyone else considering an alternative until this thing is GA? If so, is there one that would be a seamless transition?

Dahoom•11/3/23, 2:30 PM

possibly turso

DDahoom sqlite max is ~2b i believe

itsmatteomanf•11/3/23, 2:30 PM

Practically unlimited NotLikeThis

DDahoom possibly turso

Paul•11/3/23, 2:31 PM

Any experience with it? Seems like it’s the exact same offering

Iitsmatteomanf Practically unlimited <:NotLikeThis:946950222783840256>

GuillaumeLakano•11/3/23, 2:31 PM

Good, thank you all for the feedback !

SSamuel Barros is there a way to currently query a D1 database? dashboard doesn't work and wran...

Max (@rozenmd)•11/3/23, 2:51 PM

Workers can, both dashboard and wrangler use the API

SSamuel Barros yeah, but I don't think I can deploy a new worker to make a query since the bind...

Dahoom•11/3/23, 2:53 PM

APi is currently down/degraded

SSamuel Barros is there a way to currently query a D1 database? dashboard doesn't work and wran...

_tweak^prone•11/3/23, 2:53 PM

my wranglers get 502'ed - not timeout'ed - fun difference actually

fredddde•11/3/23, 2:54 PM

Rozen, if I bake you a chocolate cake will that speed up the fixing?

digeratidave•11/3/23, 2:58 PM

Is this where we look for D1 Dashboard updates? The DB appears to be working for our workers but we can't get to it from the dashboard. Any eta on resolution?

Ddigeratidave Is this where we look for D1 Dashboard updates? The DB appears to be working for...

digeratidave•11/3/23, 3:03 PM

came across this in downdetector.com but it doesn't list D1 https://www.cloudflarestatus.com/

Cloudflare Status

Welcome to Cloudflare's home for real-time and historical data on system performance.

Ddigeratidave came across this in downdetector.com but it doesn't list D1 https://www.cloudfla...

_tweak^prone•11/3/23, 3:04 PM

its under here:

Cloudflare dashboard: Degraded availability but accessible
API: Degraded availability but accessible

Original message was deleted

Dahoom•11/3/23, 3:29 PM

is this meant to make the queries the same? like dbSource.prepare('UPDATE vote_features SET vote_count_yes = vote_count_yes + 1 WHERE id = ?;', id)dbSource.prepare('UPDATE vote_features SET vote_count_yes = vote_count_yes + 1 WHERE id = ?;', id) can work with either const dbSource = new TursoDatabaseSource('your-turso-url', 'your-turso-token'); const dbSource = new TursoDatabaseSource('your-turso-url', 'your-turso-token'); or const dbSource = new D1DatabaseSource(event.platform?.env?.DB);const dbSource = new D1DatabaseSource(event.platform?.env?.DB);

Dahoom•11/3/23, 3:30 PM

asking because I'm horrible at typescript so its taking me a while to wrap my head around these files

Dahoom•11/3/23, 3:35 PM

I've been dreading having to create this myself so its interesting you already have one

Dahoom•11/3/23, 3:35 PM

I'm going to give it a try, thanks!

Dahoom•11/3/23, 3:37 PM

this might sound stupid but I'm going to untypescriptify it first

I want to create a new DB for each client, I guess best way it is to use CF API (https://developers.

Similar Threads

Similar Threads

Similar Threads