See https://discord.com/channels/595317990191398933/992060581832032316/1157239450741526560.

Discord

Discord - A New Way to Chat with Friends & Communities

Discord is the easiest way to communicate over voice, video, and text. Chat, hang out, and stay close with your friends and communities.

NNatan Parmigiano is there any way of "dynamically binding" a D1 database? I cant see a way of app...

Cyb3r-Jak3OP•2/2/24, 8:15 PM

Not yet but it something planned

CCyb3r-Jak3 See https://discord.com/channels/595317990191398933/992060581832032316/115723945...

Natan Parmigiano•2/2/24, 8:17 PM

That answers my question!

MMatt Silverlock Double digits makes sense. 100GB _per database_ is just a very different thing. ...

Vignesh•2/3/24, 7:32 AM

For this to happen will Cloudflare does horizontal scaling automatically in the background or are we supposed to do it manually?

MMatt Silverlock It depends entirely on the index and the query!

Ɽ

ⱤØ₥₳₦•2/3/24, 7:51 AM

Like if there is a table with millions of rows and that has timestamp column and i use that for index, then?

ⱤⱤØ₥₳₦Like if there is a table with millions of rows and that has timestamp column and...

Matt Silverlock•2/3/24, 8:47 AM

Then the rows scanned will depend on how the query uses the timestamp and the index. I strongly suggest reading https://developers.cloudflare.com/d1/how-to/using-indexes/

Cloudflare Docs

Use indexes · Cloudflare D1 docs

Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) …

VVignesh For this to happen will Cloudflare does horizontal scaling automatically in the ...

Max (@rozenmd)•2/3/24, 9:39 AM

automatic scaling isn't implemented yet

MMax (@rozenmd)automatic scaling isn't implemented yet

Vignesh•2/3/24, 9:41 AM

Will it be ready in production? because I want to use D1 as primary DB for my SaaS

Max (@rozenmd)•2/3/24, 9:48 AM

if by production you mean when D1 becomes Generally Available - I don't know

MMax (@rozenmd)if by production you mean when D1 becomes Generally Available - I don't know

Vignesh•2/3/24, 9:53 AM

Ok, like how are other businesses using D1? Are they creating new DB for each user?

VVignesh Ok, like how are other businesses using D1? Are they creating new DB for each us...

Max (@rozenmd)•2/3/24, 10:04 AM

yes - via the API they create a new D1 db and update their Worker bindings for each new db. The UX is currently very rough.

Max (@rozenmd)•2/3/24, 10:05 AM

bigger DBs use hyperdrive

MMax (@rozenmd)yes - via the API they create a new D1 db and update their Worker bindings for e...

Vignesh•2/3/24, 10:07 AM

MMax (@rozenmd)yes - via the API they create a new D1 db and update their Worker bindings for e...

Vignesh•2/3/24, 10:07 AM

I love to run everything on Cloudflare, so asked

CChaika Yea iirc they disabled new alpha dbs a few months ago Under Workers & Pages -> D...

Epailes•2/3/24, 2:59 PM

Is 500rps roughly the upper limit for queries via api? Or via worker binding? Or is there no real difference?

EEpailes Is 500rps roughly the upper limit for queries via api? Or via worker binding? Or...

Max (@rozenmd)•2/3/24, 6:03 PM

we're bound by durable objects' RPS limit, the API gateway has a separate rate limit

See https://discord.com/channels/595317990191398933/992060581832032316/1157239450741526560.

Similar Threads