Well, each user can sign up, and let's say, they have a shared access to the same data, let's say bl

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)OP•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)OP•7/6/25, 2:57 AM

I see

okHadi (parhlai.com)OP•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?

lambrospetrou•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

drizzle-orm

drizzle-orm

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

I can't find the issue because it doesn't always happen, only once in a while

PPotato ~when using/working with D1 database, we need to add database id in `wrangler.jso...

lambrospetrou•7/11/25, 11:10 AM

The database ID is not sensitive information on its own.

Ccosbgn My D1 is failing every now and then with these errors: ``` Failed query: select...

lambrospetrou•7/11/25, 11:11 AM

I don't see a D1 error message here.

cosbgn•7/11/25, 11:14 AM

There is no D1 error message, just failed query

cosbgn•7/11/25, 11:14 AM

cosbgn•7/11/25, 11:15 AM

I just don't understand why it would fail

Ccosbgn There is no D1 error message, just failed query

lambrospetrou•7/11/25, 11:27 AM

Who is logging that? They hide the actual error message. I can't help without more details.

cosbgn•7/11/25, 11:28 AM

I guess is drizzle then

MMikkel-T Any plans to have jurisdiction for D1?

lambrospetrou•7/11/25, 2:15 PM

It's planned but no exact ETA we can communicate yet.

matt•7/12/25, 2:45 AM

are there any plans for global active-active D1? especially useful for append-only tables

Ccosbgn I guess is drizzle then

vkalahas•7/12/25, 5:41 AM

i've run into problems with drizzle and d1 too, it looks like they haven't run through all the edge cases

Ccosbgn I guess is drizzle then

vkalahas•7/12/25, 5:48 AM

it's also telling that none of the official cloudflare templates on their github use drizzle at all, i think the way to go is just SQL without any abstractions

iLearn•7/12/25, 10:20 AM

is following a valid SQL for execution by Cloudflare D1 .. thanks ..

Reason (shared by ChatGPT) : As of July 2025, there's no evidence that changes() is supported in D1. Its omission in docs combined with reported limitations strongly suggests it’s not available.

Worker Code Snippet with SQL execution planned :
// AIM : "to execute stmtUpdate statement ONLY if insertRes statement is success, without any JS stament in between D1 calls"
const stmts = await env.DB.batch([
env.DB.prepare(INSERT INTO users (sid) VALUES (?)INSERT INTO users (sid) VALUES (?)).bind(sid),
env.DB.prepare(


        UPDATE users
        SET number_of_books = number_of_books + 1
        WHERE sid = ?
          AND changes() = 1


        UPDATE users
        SET number_of_books = number_of_books + 1
        WHERE sid = ?
          AND changes() = 1

).bind(sid)
]);

SQL File : (for reference)

CREATE TABLE users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
sid TEXT UNIQUE,
number_of_books INTEGER NOT NULL DEFAULT 0
);

PPotato ~thanks, but "..not sensitive .. on its own" ?? so far beside the database name i...

Silvan•7/12/25, 12:37 PM

its bound to the account yes

Vvkalahas i've run into problems with drizzle and d1 too, it looks like they haven't run t...

James•7/12/25, 7:57 PM

I find drizzle edge cases more annoying than just making the sql myself. There's still a bug that has something to do with setting an integer field as a date time with particular defaults in sql`` template syntax that just plain breaks. I'm sure there's more, but it was annoying as hell to deal with because it wasn't obvious at all.

JJames I find drizzle edge cases more annoying than just making the sql myself. There's...

vkalahas•7/12/25, 8:25 PM

i completely agree, drizzle has a lot of hype but it's not battle-tested, lots of non-obvious things breaking

i'm fairly comfortable in sql so the extra safety that drizzle provides isn't really worth it for small apps anyway in my opinion when you have to deal with the cost of fixing the bugs/problems that it causes

Vvkalahas i completely agree, drizzle has a lot of hype but it's not battle-tested, lots o...

James•7/12/25, 8:28 PM

not to mention with D1/DO, you're paying by the row r/w, it helps to fully understand your queries. AI sql generation just makes this even more of a no-brainer

Well, each user can sign up, and let's say, they have a shared access to the same data, let's say bl

Similar Threads

Similar Threads

Similar Threads