hey, is there a plan to add transaction support to D1?

OOr Thank you, the queries are quite simple there are just a lot of them due to high...

It's single threaded, and in each query we return its execution time, so you can track the latency of your queries and judge how many you can handle per second on average based on your traffic.
For example, if you see that your queries are on average 2ms, then you can handle roughly 500.

AAnes hey, is there a plan to add transaction support to D1?

lambrospetrou•9/5/25, 6:41 PM

You mean interleaving with JS code? If yes, not in the short-term.

Llambrospetrou Just to circle back on that. It's not a read replication issue, there is a regre...

lambrospetrou•9/5/25, 6:42 PM

Apologies for this bug that slipped through. The fix should be out to everyone by now, so the UI and the REST API returns the correct

read_replication_mode

read_replication_mode

again.

deternal•9/5/25, 8:23 PM

Hello team, for the past two weeks there were several thousands of D1 errors like network lost/d1 internal errors etc., that happens intermittently So we have tried deleting the data in our D1 database (previously around 4GB) and implemented retries, but now seeing the same level of intermittent errors saying "Exceeded maximum DB size" even the current storage is less than 50MB.

deternal•9/5/25, 8:24 PM

@lambrospetrou Any help would be appreciated, we tried looking at all forums and dont see a solution to this issue. This started only in last 15 days, and impacting our production losing the data

Ddeternal Hello team, for the past two weeks there were several thousands of D1 errors lik...

lambrospetrou•9/5/25, 11:45 PM

Exceeded maximum DB size

This error means that either you are inserting more than the limit for a single DB according to your plan (500MB/10GB), OR, that you are exceeding your account storage limit, again according to your plan.
If you go through support or you account manager they can raise the account limits. The DB size limit cannot be raised higher than 10GB.

VVisal .In The fix lands in production now. Let me know if you still encounter any other pr...

bren.app•9/6/25, 1:46 AM

confirmed it works! Thanks for your efforts here!

aza547•9/6/25, 11:03 AM

After enabling read replication on my D1 DB when should I expect to see the instance count increase from 1? The docs state that one will be spun up in every region, but I'm not seeing that yet (it was only 15 mins ago I enabled it). EDIT: still at 1 instance many hours later.

aza547•9/6/25, 11:06 AM

- Is there something that prevents replica creation if the DB isn't getting enough traffic? My database is very quiet just now (but not silent, it's still receiving queries from all over). But I was still hoping to see the replicas in action.
- Also curious if relicas are spun up on demand within the same region if traffic is high? Didn't see a mention of that in the docs.
I'm trying to dig myself out of a hole where my user database is overloaded during peak times by enabling read replication on it, I'd love to stick with D1 rather than going to another (multi-threaded) offering.

Tux•9/6/25, 1:30 PM

Hello, I am having issues with my D1 database, it is currently down for me. Where do I contact support?

Tux•9/6/25, 1:46 PM

Ah I see the issue. I tried exporting my db that had a virtual table which is now causing the db to not accept any queries

Tux•9/6/25, 1:46 PM

Is there anyway I can force restart my db?

Tux•9/6/25, 3:06 PM

^ Back after 1 hour.

Aaza547 - Is there something that prevents replica creation if the DB isn't getting enou...

lambrospetrou•9/7/25, 8:15 AM

Read replicas have the same lifecycle as a primary DB. If there is no constant traffic for 1-2 minutes, they will hibernate. Once the next request comes in they will start their boot process, and until they finish booting requests are forwarded to the primary. Once the replica boots (depends on the DB size how many (milli)seconds it will take), then replicas serve the read traffic in that region.

If your traffic is very low, once every few minutes for example, then you probably won't see any traffic served by replicas.

My database is very quiet just now (but not silent, it's still receiving queries from all over).

This is not concrete. What is quiet, and what is "still receiving queries from all over"?

Is there something that prevents replica creation if the DB isn't getting enough traffic?

No, replicas are always "created" as in ready to start, one in each region. But, the traffic is what keeps them alive. No traffic, and they will shutdown again.

Llambrospetrou Read replicas have the same lifecycle as a primary DB. If there is no constant t...

lambrospetrou•9/7/25, 8:18 AM

Each response has fields telling you if it's the primary or a replica handling your request and from which region: https://developers.cloudflare.com/d1/best-practices/read-replication/#check-where-d1-request-was-processed

const result = await env.DB.withSession()
  .prepare(`SELECT * FROM Customers WHERE CompanyName = 'Bs Beverages'`)
  .run();
console.log({
  servedByRegion: result.meta.served_by_region ?? "",
  servedByPrimary: result.meta.served_by_primary ?? "",
});

const result = await env.DB.withSession()
  .prepare(`SELECT * FROM Customers WHERE CompanyName = 'Bs Beverages'`)
  .run();
console.log({
  servedByRegion: result.meta.served_by_region ?? "",
  servedByPrimary: result.meta.served_by_primary ?? "",
});

Llambrospetrou Each response has fields telling you if it's the primary or a replica handling y...

lambrospetrou•9/7/25, 8:18 AM

Also, I assume you use the Sessions API. Otherwise, all your requests will go to the primary regardless if you have enabled read replication or not.

Llambrospetrou Also, I assume you use the [Sessions API](https://developers.cloudflare.com/d1/b...

aza547•9/7/25, 8:44 AM

Thank you for the detailed response. That clears it up for me

- It would be awesome if this could be captured in the docs.
- My problem is almost certainly that I'm not using the sessions API.

This is not concrete. What is quiet, and what is "still receiving queries from all over"?

What I was trying to convey is that there is consistent non-zero traffic in every region, and that I expected read replicas in every region to be queried. "Quiet" as in "not enough to overload the primary DB".

The docs to me imply that the sessions API is to guarantee sequential consistency for a set of queries, but the bulk of my traffic is pulling a single field out of the database so I don't actually care about sequential consistency in a lot of cases.

Feel free to point out if I'm missing the obvious, but I don't think the docs make it clear that the sessions API is required for queries to hit a read replica.

I'll go add some

.withSession()

.withSession()

calls to my worker and see what happens. Thanks again.

Aaza547 Thank you for the detailed response. That clears it up for me 🙂 - It would be a...

lambrospetrou•9/7/25, 8:45 AM

At the very top:

Your application can use read replicas with D1 Sessions API.

Your application can use read replicas with D1 Sessions API.

We can make it even stronger if that's not clear enough. I will add another clarifying sentence there.

aza547•9/7/25, 8:50 AM

That would be great, I guess I'm still reading that as "you can use the sessions API optionally to get sequential consistency which a read replication enabled DB otherwise doesn't provide"

aza547•9/7/25, 9:13 AM

Happy days

OOr Will enabling read replication cause the primary DB to be locked while the repli...

lambrospetrou•9/7/25, 9:42 PM

No, replication is done asynchronously, and there is no blocking time while replicas are being created. As I mentioned above though, in order to get benefits from replicas you would need some continuous traffic, especially since 3GB would need a few seconds to boot.
If you only have a request per minute for example, you will pretty much always go to the primary.

flof.fly•9/7/25, 9:56 PM

Is there a way to Duplicate a D1 (including data) via APICall or CLI?

Fflof.fly Is there a way to Duplicate a D1 (including data) via APICall or CLI?

lambrospetrou•9/8/25, 7:13 AM

Not at the moment

Pingo•9/8/25, 2:12 PM

Hi im a noob to d1 and my biggest concern is obviously avoiding something like tea app disaster. So I wanted to know if there is an awesome list with projects using d1 so I can learn how real life applications are configuring d1 with battle tested patterns. I am extremely paranoid about managing user data correctly. Sorry if this is not the place to ask about this.

PPingo Hi im a noob to d1 and my biggest concern is obviously avoiding something like t...

lambrospetrou•9/8/25, 2:24 PM

Hi im a noob to d1 and my biggest concern is obviously avoiding something like tea app disaster.

What is the "tea app disaster"?

D1 is durable storage, and provides up to 30 days of Point-in-time-restore for your data to be able to revert to any point in these 30 days.

There are certain limits, about storage (10GB) and fixed resource limits due to being single threaded execution of the queries, but we don't lose your data.

If you have specific concerns or questions, happy to answer. Or anyone in this community for what's worth.

Llambrospetrou > Hi im a noob to d1 and my biggest concern is obviously avoiding something like...

Isaac McFadyen•9/8/25, 2:28 PM

What is the "tea app disaster"?

Recent data breach from an app called Tea: https://www.bbc.com/news/articles/c7vl57n74pqo

IIsaac McFadyen > What is the "tea app disaster"? Recent data breach from an app called Tea: htt...

lambrospetrou•9/8/25, 2:55 PM

D1 data is encrypted at rest (built ontop of Durable Objects), but obviously access is authenticated using either your worker binding (so having access to deploying workers) or to the Cloudflare access tokens, so you should protect your access tokens as any other secret. I can't say anything specific about the leaked incident of Tea.

Gab•9/8/25, 3:35 PM

HI guys, how can I aapply drizzle migrations to preview or local d1 database?
im trying with ->
wrangler d1 migrations apply d1_database --local
the CLI say it works well, but when I come to sql editor, there is no schema in the database

Gab•9/8/25, 3:38 PM

when I use wrangler d1 migrations apply d1_database --remote
it workers well on the main d1 database, but --local does not seen to apply

GGab when I use wrangler d1 migrations apply d1_database --remote it workers well on ...

AnesOP•9/8/25, 3:43 PM

you can apply the migrations using drizzle, your drizzle.config.ts should look like this:

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

config({
  path: ".env.stage"
});

export default defineConfig({
  schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"],
  out: "./drizzle/app",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CF_ACCOUNT_ID,
    databaseId: process.env.CF_DATABASE_ID,
    token: process.env.CF_TOKEN,
    url: ""
  }
});

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

config({
  path: ".env.stage"
});

export default defineConfig({
  schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"],
  out: "./drizzle/app",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CF_ACCOUNT_ID,
    databaseId: process.env.CF_DATABASE_ID,
    token: process.env.CF_TOKEN,
    url: ""
  }
});

eg script:

"db:push": "drizzle-kit push --config=./drizzle.config.ts"

"db:push": "drizzle-kit push --config=./drizzle.config.ts"

Gab•9/8/25, 3:48 PM

ok, do i need to change the CF_DATABASE_ID for the local preview d1 database? (i can add in .dev.vars)

Gab•9/8/25, 4:19 PM

I got working with the old script, It was working, thje problem was at my betterAuth objecta tha was not findind the correct db

csmykay•9/8/25, 6:27 PM

Howdy all. Is there a good "best practices" document for working with D1 databases locally with multiple developers and how best to push updates? I actually have a response from Claude but looking for something to double check.

52Hz•9/8/25, 8:20 PM

Is it currently possible to download the data of a specific time point three days ago from the D1 database without modifying the database?

csmykay•9/8/25, 9:07 PM

On a side note a "best practices" in using drizlle on your docs page would be great.

552Hz Is it currently possible to download the data of a specific time point three day...

lambrospetrou•9/9/25, 7:30 AM

No, unfortunately.

52Hz•9/9/25, 7:50 AM

Is it possible to restore to a certain point in time, export the data, and then revert back to the point in time before the operation?

552Hz Is it possible to restore to a certain point in time, export the data, and then ...

lambrospetrou•9/9/25, 9:21 AM

Yes, with the caveat that during export your DB won't be able to process queries.

52Hz•9/9/25, 10:19 AM

OK. Thank you.

Dean•9/9/25, 6:27 PM

anyone else seeing D1 issues right now? WNAM region. database won't even load in dashboard

parisholley•9/9/25, 6:27 PM

yes

Dean•9/9/25, 6:28 PM

looks like it's back for me, for some dbs, some are still dead

nullptr•9/9/25, 6:29 PM

D1 is returning errors all over

aza547•9/9/25, 6:29 PM

Also seeing issues

nullptr•9/9/25, 6:30 PM

Guys any help here? Our production stack is on fire it looks like

Iaci•9/9/25, 6:31 PM

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

const result = await env.DB.withSession() .prepare(`SELECT * FROM Customers WHERE CompanyName = 'Bs Beverages'`) .run(); console.log({ servedByRegion: result.meta.served_by_region ?? "", servedByPrimary: result.meta.served_by_primary ?? "", });

import { defineConfig } from "drizzle-kit"; import { config } from "dotenv"; config({ path: ".env.stage" }); export default defineConfig({ schema: ["./src/app/schema.ts", "./src/app/auth-schema.ts"], out: "./drizzle/app", dialect: "sqlite", driver: "d1-http", dbCredentials: { accountId: process.env.CF_ACCOUNT_ID, databaseId: process.env.CF_DATABASE_ID, token: process.env.CF_TOKEN, url: "" } });

hey, is there a plan to add transaction support to D1?

Similar Threads

Similar Threads

Similar Threads