Hi, if I have two D1 databases in my account, one for production and one for staging. Is there anyw

Hi, if I have two D1 databases in my account, one for production and one for staging. Is there anyway to limit access to production database to some of the account members? Say we have compliance on who can access customer's data. It seems there is no resource based permission management for members in the account. Is there a solution other than creating a separate Cloudflare account for production environment? Thanks!

Jjiulongw Hi, if I have two D1 databases in my account, one for production and one for sta...

lambrospetrou•6/11/25, 5:54 PM

Unfortunately there aren't any resource level permissions at the moment. You can restrict writing to databases but as long as they have d1:readd1:read permissions they would be able to read all DBs.

Llambrospetrou Unfortunately there aren't any resource level permissions at the moment. You can...

jiulongwOP•6/11/25, 5:58 PM

Thanks! Looks like a new account is the way to go.

beingmudit [WePlayDOS]•6/11/25, 6:35 PM

Yeah my D1 is in APAC only. Do you see anything with this trace - 2h8oi9k493ebe4vtjriu3s41

beingmudit [WePlayDOS]•6/11/25, 6:37 PM

Thanks for updating on the APAC issue.

CC I triggered the issue again. The first time I tried to export: "X [ERROR] cell....

C•6/12/25, 1:59 AM

Tried to use Wrangler 4.19.2, the issue still exists.
Unable to export remote Database now.
cell.replace is not a function

C•6/12/25, 1:59 AM

SaM•6/12/25, 6:10 AM

Hi everyone! I have a question about Cloudflare D1 replication and latency:

My D1 database’s primary region is APAC (I’m in India).

If I call my Worker API without read replicas, my responses in India are around 300ms.

If I enable read replicas, my response time in India goes up to 500–700ms.

For a user in the UK, with read replicas enabled, the response comes from the WEUR region and is under 100ms (which is great!).

But if I turn off read replicas, UK users get responses from APAC and latency is over 700ms.

My question:
Is there any way to make my responses in India faster with D1 replication enabled?
Why is enabling read replicas increasing my latency locally, and what’s the best way to optimize for both my region (India) and global users?

Any tips or best practices would be greatly appreciated!

SSaM Hi everyone! I have a question about Cloudflare D1 replication and latency: My ...

lambrospetrou•6/12/25, 8:30 AM

Without database/account ID details I cannot know for sure, but I can see what you describe happening if the replica you are hitting from India is farther from your main database depending on which region you get routed since India doesn't have a region yet.
There is a plan for optimizing the choice of the replica to be the closest but now it's just selecting the replica of your closest region.

Llambrospetrou Without database/account ID details I cannot know for sure, but I can see what y...

SaM•6/12/25, 8:32 AM

45688789-5491-40fc-9532-191a5d7056db -> Database ID

SSaM 45688789-5491-40fc-9532-191a5d7056db -> Database ID

lambrospetrou•6/12/25, 8:47 AM

Do you send traffic in this database? I only see a handful of requests over the past few days.
Either way, my theory seems to be right. Your main database is in Singapore, and the replica of the same region ended up in Japan. :facesad:
Replica placement is the core priority for improving before going GA, so please continue reporting these cases and we examine them.

Llambrospetrou Do you send traffic in this database? I only see a handful of requests over the ...

SaM•6/12/25, 8:55 AM

099d4b89-ddcf-4172-830b-565143b85d36 is the database ID for the DB I’ve tested with both UK and India. The database ID I shared earlier is also one of my test databases.

Llambrospetrou Do you send traffic in this database? I only see a handful of requests over the ...

SaM•6/12/25, 9:02 AM

Is there anything specific I should do next?

SSaM Is there anything specific I should do next?

lambrospetrou•6/12/25, 9:09 AM

I will check with the team if there is any internal way to move replicas, although I am not aware of any at the moment. Will let you know later today.

Llambrospetrou I will check with the team if there is any internal way to move replicas, althou...

SaM•6/12/25, 9:13 AM

Thank you for looking into this. I’ll wait for your update. Let me know if you need anything else from my side.

SSaM Thank you for looking into this. I’ll wait for your update. Let me know if you n...

lambrospetrou•6/12/25, 12:29 PM

Unfortunately, there isn't a tool (it's in the roadmap) to manually relocate replicas. The routing optimization to pick the closest is in progress though, so hopefully it will go out soon.

Llambrospetrou Unfortunately, there isn't a tool (it's in the roadmap) to manually relocate rep...

Gladius•6/12/25, 12:58 PM

It would be great if you guys add a replica in India as well. India has many users but not always have fast internet. Reducing server side latency would increase user experience.

Successful-Arm-3762•6/12/25, 1:30 PM

Hi cloudflare devs, I have a D1 database that I'm using for my production use-case. It is a very small db, but from day 1, I've been facing random >10s wall time on my workers on random db operations. I've optimized queries. This was okay until I was the primary user, but I'm now looking to having more tenants and convert to a 1 db/tenant architecture, so therefore reaching out for help, as I would like to keep using D1.

harmw•6/12/25, 5:54 PM

anyone else running into D1 errors on the CF side?

harmw•6/12/25, 5:55 PM

(error) 17:52:13 [ERROR] Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

DaniFoldi•6/12/25, 6:03 PM

could someone nudge

ce2951f0-9233-455a-942d-bf1ff6b93538

ce2951f0-9233-455a-942d-bf1ff6b93538

database on

d0238d3a1eebca7fc036cb766a5e538f

d0238d3a1eebca7fc036cb766a5e538f

account please, it's giving

Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

Error: D1_ERROR: Internal error while starting up D1 DB storage caused object to be reset.

on 100% of requests

parisholley•6/12/25, 6:06 PM

same

parisholley•6/12/25, 6:08 PM

always something with d1

harmw•6/12/25, 6:09 PM

yeah, and hackernews mentions both FireBase and Twitch seeing issues as well

parisholley•6/12/25, 6:15 PM

https://downdetector.com/ - internet is broken

parisholley•6/12/25, 6:15 PM

https://tenor.com/view/friends-joey-door-slam-bye-im-out-gif-3389550

Tenor

Door slam

harmw•6/12/25, 6:18 PM

network issue, as usual

Tory•6/12/25, 6:31 PM

Same D1 errors here. Looks like an outage.

Chaika•6/12/25, 6:31 PM

yup https://www.cloudflarestatus.com/incidents/25r9t0vz99rp

Broad Cloudflare service outages

Sam•6/12/25, 6:45 PM

parisholley•6/12/25, 8:19 PM

funny enough, my d1's with replica work, non-replicated doesn't :p

beingmudit [WePlayDOS]•6/13/25, 7:19 AM

Hey Team, I read an announcement that a new UX layer has been added as D1 explorer but I don't see it in my dashboard. Is it still rolling out? How can I onboard.

Silvan•6/13/25, 8:25 AM

the three dots on the right and then explore data

ctrl-z•6/13/25, 9:09 AM

Hi team, I currently get this error

D1_ERROR: To execute a transaction, please use the state.storage.transaction() or state.storage.transactionSync() APIs ...

D1_ERROR: To execute a transaction, please use the state.storage.transaction() or state.storage.transactionSync() APIs ...

and after some research, I am a bit confused about the current state of D1 vs durable objects.

In order to use transactions via state.storage.transaction(), do I need to stop using D1 and switch over to DO? Or does state.storage.transaction() somehow work for existing D1 databases as well?

ctrl-z•6/13/25, 9:13 AM

also, a related question, as of today, is D1 actually implemented via DO? Is it just the sqlite interface to DO?

Cctrl-z Hi team, I currently get this error `D1_ERROR: To execute a transaction, please ...

lambrospetrou•6/13/25, 9:13 AM

That's probably an underlying error from Durable Objects that we shouldn't surface to users since you don't manage the underlying DOs and cannot run that anyway through D1.

What SQL did you try to run that gave you that error? I don't think I saw it before surfacing to users.

To summarize about transactions, since D1 is remote from your worker the traditional transaction approach of opening a transaction and interleaving JS code with SQL doesn't work (at least with the current implementation). The D1 batch query runs all the given queries within a transaction if you want multiple statements to be executed atomically.

Cctrl-z also, a related question, as of today, is D1 actually implemented via DO? Is it ...

lambrospetrou•6/13/25, 9:14 AM

Yes, you can read a lot of the technical details in https://blog.cloudflare.com/d1-read-replication-beta/

Llambrospetrou That's probably an underlying error from Durable Objects that we shouldn't surfa...

ctrl-z•6/13/25, 9:19 AM

I'm not running sql directly. I'm currently implementing an adapter for an ORM project called remult, and their test suite failed with that error https://github.com/nerdfolio/remult/blob/main/projects/tests/dbs/shared-tests/db-tests.ts#L951-L970
--
So sounds like the short answer still is D1 does not currently js-based transactions and sql-based transactions are done via batching.

ctrl-z•6/13/25, 9:20 AM

If all I need is access to an sqlite database for my app that does support transaction, do durable objects provide that capability at this time?

Cctrl-z If all I need is access to an sqlite database for my app that does support trans...

lambrospetrou•6/13/25, 9:23 AM

Yes, you can use SQLite DOs directly

SSilvan the three dots on the right and then explore data

workerBee•6/13/25, 11:44 AM

Thanks - I was waiting for that too... I wish the default table sort was ID DESC, but otherwise, this is a great update!

Larry•6/13/25, 12:24 PM

Brayden must be a proud papa today

Brayden•6/13/25, 2:33 PM

I couldn't be prouder

Brayden•6/13/25, 2:33 PM

Also we have a new "Explore Data" button coming when you click into a D1 instance, the prod deploy for that I think was moved to Monday so apologies for teasing that one a bit early the other day

beingmudit [WePlayDOS]•6/13/25, 3:17 PM

Ahh i see. No worries, thanks for updating Brayden++++
I guess engineers are handling with a massive incident ATM.

SSuccessful-Arm-3762 Hi cloudflare devs, I have a D1 database that I'm using for my production use-ca...

Successful-Arm-3762•6/13/25, 4:38 PM

bumping this again. Hopefully someone is able to help me.

SSuccessful-Arm-3762 bumping this again. Hopefully someone is able to help me.

lambrospetrou•6/13/25, 5:15 PM

This was okay until I was the primary user, but I'm now looking to having more tenants and convert to a 1 db/tenant architecture, so therefore reaching out for help, as I would like to keep using D1.

I am not sure what's the question here, though.

Regarding the slow latencies, it can be anything. Next time they happen send us the database and account IDs so that we can investigate. When the underlying datacenter has network issues certain operations take longer, so that's just one possible cause. The network can also impact just the response on its way back, not necessarily the query processing. Especially if you return MBs So, without exact timeranges we can't say what is the cause.

Tux•6/13/25, 6:22 PM

Hello guys, I have a question about the pricing of D1 of the paid plan. When it says "First 25 billion / month included" in the Rows read, does that mean I only get 25 billion for the first month and then get charged for the usage or does that reset and I get that every month

TTux Hello guys, I have a question about the pricing of D1 of the paid plan. When it ...

Chaika•6/13/25, 6:25 PM

It means every month the first 25 billion rows read are included with Workers Paid, and you only pay for any over

CChaika It means every month the first 25 billion rows read are included with Workers Pa...

Tux•6/13/25, 6:25 PM

Ah alright perfect. Thanks a lot

SSilvan the three dots on the right and then explore data

gruntlord6•6/13/25, 11:04 PM

I wish it was the default, it's so much nicer then the old UI

Hi, if I have two D1 databases in my account, one for production and one for staging. Is there anyw

Similar Threads

Similar Threads

Similar Threads