It's 50,000 but they've mentioned they've just set that so people don't go crazy. It can be increase

It's 50,000 but they've mentioned they've just set that so people don't go crazy. It can be increased to anything.
https://developers.cloudflare.com/d1/platform/limits/

Cloudflare Docs

Limits · Cloudflare D1 docs

If you would like to explore other storage solutions for your application, Cloudflare also offers Workers KV, Durable Objects, and R2.

BBeny It's 50,000 but they've mentioned they've just set that so people don't go crazy...

Gunnar•4/11/24, 11:07 AM

Oh jesus, sorry, I'm blind, it's the top line

GGunnar Is there a max db count limit?

Max (@rozenmd)•4/11/24, 11:08 AM

when we release dynamic bindings, it'll look a bit more like DO's limits page

BenyOP•4/11/24, 11:09 AM

Next we need an unlimited KV's limit

That one is pretty small

BBeny Next we need an unlimited KV's limit 😄 That one is pretty small

Gunnar•4/11/24, 11:11 AM

There is a "Limit Increase Request Form" for KV
https://developers.cloudflare.com/kv/platform/limits/

Cloudflare Docs

Limits · Cloudflare Workers KV

Request adjustments to limits that conflict with your project goals by contacting Cloudflare. To request an increase to a limit, complete the Limit …

BBeny Next we need an unlimited KV's limit 😄 That one is pretty small

Hello, I’m Allie!•4/11/24, 11:12 AM

You can also just create new “namespaces” by giving each a prefix

HHello, I’m Allie!You can also just create new “namespaces” by giving each a prefix

BenyOP•4/11/24, 11:14 AM

Yeah this is a thing, but that workaround wouldn't be good in combination with Workers for Platforms, otherwise the user workers will be able to see other's data

GGunnar There is a "Limit Increase Request Form" for KV https://developers.cloudflare.co...

BenyOP•4/11/24, 11:18 AM

I've never tried the limit increase before but I've seen some people here mention their requests went unanswered for weeks so it puts me off a bit (and it is strange hosting it on a Google form, doesn't feel official)

Oom Can d1 sizes be increased more then 10gb?

Max (@rozenmd)•4/11/24, 11:42 AM

no, see conversation above: d1-database

Oom I get it. It's awesome. But how much can a 10gb store. If it's json row?

Max (@rozenmd)•4/11/24, 11:44 AM

millions of rows: d1-database

Max (@rozenmd)•4/11/24, 11:45 AM

figure out how big your rows are, divide 10GB by that size, that's how many rows you can store

Oom And if i separate database so much. Like if have blog and it's exceeding 10gb. T...

Max (@rozenmd)•4/11/24, 11:47 AM

the classic challenge is figuring out the right way to split the data, not always easy

Oom Is there way can I invoke a worker or http request if the data in the db changes...

Max (@rozenmd)•4/11/24, 11:47 AM

not without polling the db, not yet anyway

Oom And if i separate database so much. Like if have blog and it's exceeding 10gb. T...

Max (@rozenmd)•4/11/24, 11:54 AM

say you have a blog with 10kb of text (~1k words) per article, that's a million articles for 10GB

ZZiga Zajc I have json string stored in D1. What function should be used to return object b...

Max (@rozenmd)•4/11/24, 12:34 PM

this doc might be useful https://developers.cloudflare.com/d1/build-with-d1/query-json/

BBeny Yeah this is a thing, but that workaround wouldn't be good in combination with W...

Hello, I’m Allie!•4/11/24, 12:44 PM

Could you pass in an RPC target that makes reads only to their “namespace”?

ZZiga Zajc ```sql SELECT uuid, json_array(titles) as titles, year FROM anime; ```

Max (@rozenmd)•4/11/24, 12:46 PM

wouldn't you want to do something like:

json_extract(titles, $.romanji) as romanji, json_extract(titles, $.english) as english, ...

json_extract(titles, $.romanji) as romanji, json_extract(titles, $.english) as english, ...

Max (@rozenmd)•4/11/24, 12:47 PM

not sure if sqlite supports the idea of nesting objects in a response

Max (@rozenmd)•4/11/24, 1:14 PM

titles -> $

titles -> $

titles ->> $

titles ->> $

might do it

dakom•4/11/24, 1:29 PM

is it safe to leak the database id? i.e. to publish

wrangler.toml

wrangler.toml

which has database id bindings ?

Ddakom is it safe to leak the database id? i.e. to publish `wrangler.toml` which has da...

Hello, I’m Allie!•4/11/24, 1:32 PM

Yes. The entirety of

wrangler.toml

wrangler.toml

is safe to publish, as long as you aren't putting secrets in it

Ddakom is it safe to leak the database id? i.e. to publish `wrangler.toml` which has da...

Acе•4/11/24, 1:40 PM

The ID only works for workers in your account so it should be fine

mau•4/11/24, 3:55 PM

My where condition with an index on id is taking 2.0-2.2 seconds. If I get everything from the table it takes 2.3-2.8 seconds. Is it normal?

mau•4/11/24, 3:58 PM

mau•4/11/24, 3:59 PM

It's 50,000 but they've mentioned they've just set that so people don't go crazy. It can be increase

Similar Threads