Cloudflare Developers•6mo ago

Did you mean to post this in the R2 channel?

Llambrospetrou Did you mean to post this in the R2 channel?

Gagan Suie•7/3/25, 11:19 PM

you right. sorrrryyyy

Angiewolf•7/4/25, 1:29 AM

Hi I have a little hobby website on a worker and a d1 database bound to that worker. My d1 db is only accessable after signing in to the admin user but now I see suspicious queries on my d1 and I have no idea how or what.

AAngiewolf Hi I have a little hobby website on a worker and a d1 database bound to that wor...

lambrospetrouOP•7/4/25, 6:19 AM

What are the suspicious queries? The 3rd one for example is probably just the listing done for the UI dashboard if I remember correctly. The counts are very low to be an abuse.

Llambrospetrou What are the suspicious queries? The 3rd one for example is probably just the li...

Angiewolf•7/4/25, 6:24 AM

Sorry, first time using d1 here. So most of these are just because I was in the d1 dashboard and it was gathering info?

Angiewolf•7/4/25, 6:25 AM

Thank you for the reply

AAngiewolf Sorry, first time using d1 here. So most of these are just because I was in the ...

lambrospetrouOP•7/4/25, 6:26 AM

The 1st and 3rd seem specific writes to your own tables, so I assume triggerred by you right?
The others yeah seem safe.

Angiewolf•7/4/25, 6:26 AM

1st is def me, 3rd not too sure haha

JJumaron What is the limit of the amount of d1 databases you could increase it to? (Not t...

gruntlord6•7/4/25, 8:20 PM

its a case by case basis so you won't get a public answer. If you need that many I would use durable objects instead because they don't have any hard limits in terms of amount of objects (just the amount of classes) https://developers.cloudflare.com/durable-objects/platform/limits/#how-many-durable-objects-can-i-create

Cloudflare Docs

Limits

Durable Objects are a special kind of Worker, so Workers Limits apply according to your Workers plan. In addition, Durable Objects have specific limits as listed in this page.

okHadi (parhlai.com)•7/6/25, 2:35 AM

Hey, need (any) opinion on my appraoch on developing an application on D1. I'm thinking to implement a microservices based architecture, so each logical business unit (e.g users, signups, blogs) will have their own database. This works well in my mind.

I still can't wrap my mind around the 10gb limitation on each database. Even with a microservice architecture, if I have to scale at some point, I will hit this limit with a single db. Of course cloudflare says that you can have many DBs, but how can I even make it work?

In my application, most of the data will be shared (you can think of it as a info website). So each user will almost always see the same data. So I can't do a "multi tenant" approach here.

Another option is sharding: but I'm new to DB design and still wrapping my head around it. So far, sharding doesn't fill the usercase.

This sounds more of an architecture question than a d1 question, but I'm happy to learn any advice, or any case studies that I can be pointed towards. Thanks : )

okHadi (parhlai.com)•7/6/25, 2:39 AM

follow up question: is sharding really a recommended architecture with D1?

OokHadi (parhlai.com)Hey, need (any) opinion on my appraoch on developing an application on D1. I'm t...

gruntlord6•7/6/25, 2:44 AM

You need to be more specific, what data is shared? What data isn’t shared? Why are you convinced you will hit the limit?

Ggruntlord6 You need to be more specific, what data is shared? What data isn’t shared? Why a...

okHadi (parhlai.com)•7/6/25, 2:48 AM

Well, each user can sign up, and let's say, they have a shared access to the same data, let's say blogs. The blogs can be of finance, education or any other category. For each category, I can create a database. Makes sense to me. But if I a category has so many blogs that it reaches the 10gb limit?

I'm not convinced I'll hit the limit honestly, but it is still an interesting question for me to ask. "In case" I do, what should I do to plan to scale?

OokHadi (parhlai.com)Well, each user can sign up, and let's say, they have a shared access to the sam...

gruntlord6•7/6/25, 2:52 AM

I’m not really sure I understand, why would each use have a shared blog database?

For example, I have an application with hundreds of thousands of e-commerce products that store owners can import, that needs to be shared so I use a single d1 instance . But all the other data the stores have is in tenant based durable objects, because they don’t need to be shared and don’t apply in other contexts.

okHadi (parhlai.com)•7/6/25, 2:54 AM

okay well yeah ecommerce app makes more sense lol, my bad

like in your case, there a hunderds of thousands of products, if you were to scale it to millions and hit the limit, what would be the approach?

I haven't looked much into durable objects yet, I guess that should be my next study

gruntlord6•7/6/25, 2:55 AM

Each product type is its own database

gruntlord6•7/6/25, 2:56 AM

If I needed two for a single type I would just have the client be updated to reflect that. One of them is about a gb now but I could also just optimize it more

gruntlord6•7/6/25, 2:56 AM

A 10gb database is a big database. There are legitimately large databases that need to be bigger but most are just unoptimized or not well architected

okHadi (parhlai.com)•7/6/25, 2:57 AM

I see

okHadi (parhlai.com)•7/6/25, 2:57 AM

yeah makes sense

gruntlord6•7/6/25, 2:58 AM

D1 is great for shared data but durable objects are a lot nicer for tenant based data since you don’t need to deploy each one, just the base class

Silvan•7/6/25, 6:44 PM

yea most of the time i use d1 for just auth and then DOs for tenants/micro services

Silvan•7/6/25, 6:45 PM

i should use cf access more ngl

Ashkan•7/7/25, 11:23 AM

hello guys, I can't find table tab in D1 database ? where was it moved?

AAshkan hello guys, I can't find table tab in D1 database ? where was it moved?

lambrospetrouOP•7/7/25, 12:10 PM

See "Explore data" button at the right side.

gruntlord6•7/7/25, 4:38 PM

you can also remove the "/metrics" from the url when you open it to see the old way

Llambrospetrou See "Explore data" button at the right side.

gruntlord6•7/7/25, 4:38 PM

could you make it a tab like it was before? I found the tab view a lot more intuitive since all the other parts of the page nav use it

Ggruntlord6 could you make it a tab like it was before? I found the tab view a lot more intu...

Brayden•7/7/25, 4:44 PM

It's a consideration we're making but makes for an awkward experience since clicking it doesn't necessarily follow the "tab" experience as you'd expect it to. And if we embedded the new Studio experience below we'd have a double sidebar situation which also makes for a weird UI behavior.

Original message was deleted

gruntlord6•7/7/25, 8:55 PM

everyone gets lost since its not there, even I pause and go, oh yea its over here now

TrueHeads•7/7/25, 10:12 PM

Has anyone connected any D1 databases to graphical data trackers like grafana? I am building a web browser game of sorts and wanted a crude dashboard in grafana to show me stats for overall user metrics/etc.

Original message was deleted

TrueHeads•7/7/25, 10:15 PM

Hugeeeee gravedig post, do you still use grafana for d1 metrics/etc?

Original message was deleted

TrueHeads•7/8/25, 3:29 AM

Oh interesting, you are experiencing issues with D1 itself? Not grafana?

TrueHeads•7/8/25, 3:30 AM

I have paid workers plan so was gonna capitalize on the extra usage I get with D1 to track progression for users/etc

Original message was deleted

TrueHeads•7/8/25, 3:37 AM

Was estimating few thousand users, so few thousand rows with all of their associated tracking information, and then a few analytics databases to track certain progression metrics. So would love insight on if D1 is bad choice based on your experience

Original message was deleted

TrueHeads•7/8/25, 2:36 PM

Oof yeah that wouldnt be good. You were suggesting clickhouse as an alternative for grafana?

ac•7/10/25, 1:02 AM

why does d1 make it impossible to turn off foreign keys when doing migrations/queries? it's nuts

ac•7/10/25, 1:02 AM

How has this been open for a year and a half :NotLikeThis: https://github.com/cloudflare/workers-sdk/issues/5438

GitHub

🚀 Feature Request: Allow turning off foreign key check while mig...

Some table altering tasks in SQLite cannot be achieved without replacing it with a new table (by dropping - recreating the table) (like adding foreign keys, changing primary keys, updating column t...

vkalahas•7/10/25, 4:37 PM

Is Cloudflare planning any Postgres offerings anytime soon? The storage limits of D1 as well as being SQLite really don't help in my opinion. All that's missing from the Cloudflare ecosystem is a good database.

I'm thinking of using Supabase with Hyperdrive at this point, but would like to know if anyone has any better alternatives. Thank you!

cosbgn•7/11/25, 10:26 AM

My D1 is failing every now and then with these errors:

Failed query: select "id", "user_id", "team_id", "role", "created_at", "updated_at" from "teams_users" where ("teams_users"."team_id" = ? and "teams_users"."user_id" = ?)
params: tm_123,us_123x

Failed query: select "id", "user_id", "team_id", "role", "created_at", "updated_at" from "teams_users" where ("teams_users"."team_id" = ? and "teams_users"."user_id" = ?)
params: tm_123,us_123x

cosbgn•7/11/25, 10:27 AM

Is this an issue of D1 or a bug on