> Also, it'd be nice to have locally replicated DO sqlite files for debugging. Maybe with something

Also, it'd be nice to have locally replicated DO sqlite files for debugging. Maybe with something like wrangler do --namespace <ns> read <id> <db.sqlite>

You mean, doing an export/dump/copy right once? You don't expect things to be replicated locally in real time when changes happen remotely.

After the DO gets evicted, next time it's accessed, if there was already a read replica in the new data center, that replica gets promoted to write leader.

This is something that we are thinking about but not as part of read replication. Moving the primary should take into account more than just a single request, so it wouldn't work like that, but yeah the team at some points wants to be able to move primary DOs.

Llambrospetrou > Also, it'd be nice to have locally replicated DO sqlite files for debugging. M...

Danny Navarro•4/30/25, 9:34 AM

You mean, doing an export/dump/copy right once? You don't expect things to be replicated locally in real time when changes happen remotely.

Right, I don't really care about real-time. I was thinking about explicitly doing a one way sync with a command, maybe is a better word. A command to export just once would be great, the one way sync would be just an optimization.

VVy Following https://blog.cloudflare.com/d1-read-replication-beta/, CF team is star...

John Spurlock•4/30/25, 1:45 PM

long time wish: export/backup/archive DO with read-only access to another DO's storage but without competing with the main DOs incoming request queue - a minimal replication delay would be fine

veeque•4/30/25, 4:15 PM

why is the 10gb limit a hard limit? it's not like the data has to travel to other locations, given that a DO only ever exists in the datacenter it was created.

Vveeque why is the 10gb limit a hard limit? it's not like the data has to travel to othe...

lambrospetrouOP•4/30/25, 4:26 PM

Few reasons, cold starts would be very slow and it would be hard to get the fast SQLite performance from local queries if you had to load pages from remote most of the time (even with caching). Also, the fact that the DOs do not move (yet), is just because it's not implemented, yet.

Llambrospetrou Few reasons, cold starts would be very slow and it would be hard to get the fast...

jed•4/30/25, 6:45 PM

is this still in the works? it’s been almost five years since the announcement that cloudflare “can transparently migrate objects between locations.”

Jjed is this still in the works? it’s been almost five years since the announcement ...

lambrospetrouOP•4/30/25, 7:05 PM

There is transparent migration already, but only when the original location is down, and not due to request traffic.

JJan Wilmake thanks. will remoive it, idk how to fix it either

gruntlord6•4/30/25, 8:27 PM

I think they said this will fix it durable-objects

jcheese•5/1/25, 1:04 AM

will DOs re-initialize whenever theres a new deployment that changes code? meaning, will the get called everytime when theres a new deployment and the DO gets accessed?

Jjcheese will DOs re-initialize whenever theres a new deployment that changes code? meani...

1984 Ford Laser•5/1/25, 1:05 AM

No but any open/hibernated Websockets will be terminated

11984 Ford Laser No but any open/hibernated Websockets will be terminated

jcheese•5/1/25, 1:08 AM

i see, but how can a js class have it's underlying code updated to even receive the new migrations in the file w/o actually re-initializing the class?

1984 Ford Laser•5/1/25, 1:09 AM

It will get called the next time the DO is accessed, but not immediately upon deployment. Sorry if thats what you meant

11984 Ford Laser It will get called the next time the DO is accessed, but not immediately upon de...

jcheese•5/1/25, 1:15 AM

i see. then do you know why for migration libs like this: https://github.com/lambrospetrou/durable-utils?tab=readme-ov-file#sqlite-schema-migrations

require in all sql queries, instead of a one off in the constructor?

GitHub

GitHub - lambrospetrou/durable-utils: Utilities for Cloudflare Dura...

Utilities for Cloudflare Durable Objects and Workers - lambrospetrou/durable-utils

Jjcheese i see. then do you know why for migration libs like this: https://github.com/lam...

Larry•5/1/25, 1:46 AM

lambrospetrou favors doing it "lazily" in case you have functionality in your DO that doesn't need stored data. If that's not the case for you, doing it in the constructor is fine. That's what I do.

LLarry lambrospetrou favors doing it "lazily" in case you have functionality in your DO...

jcheese•5/1/25, 1:48 AM

thanks!

that doesn't need stored data

what does this mean necessarily?

Jjcheese thanks! > that doesn't need stored data what does this mean necessarily?

Larry•5/1/25, 1:51 AM

Let's say you have a method that accepts two numbers and returns the sum. No stored data is involved.

LLarry Let's say you have a method that accepts two numbers and returns the sum. No sto...

jcheese•5/1/25, 1:51 AM

ah yea i get that, but if you have migrations in your DO, you always have stored data im assuming?

Jjcheese ah yea i get that, but if you have migrations in your DO, you always have stored...

Larry•5/1/25, 1:53 AM

Yes, but part of your DO's functionality might not use stored data. A commonly accepted software engineering principle is to not do work until it's needed.

LLarry Yes, but part of your DO's functionality might not use stored data. A commonly a...

jcheese•5/1/25, 2:12 AM

i see i see. thank you!

LLarry lambrospetrou favors doing it "lazily" in case you have functionality in your DO...

lambrospetrouOP•5/1/25, 9:43 AM

Exactly what @Larry said. I need to update the README of my library to explain this since many folks ask about it at this point. It seemed a bit obvious to me, but I was wrong assuming that.

Llambrospetrou Exactly what @Larry said. I need to update the README of my library to explain t...

jcheese•5/1/25, 11:23 AM

The internals of the DO and when constructor gets called and stuff isnt so obvious

jcheese•5/1/25, 11:24 AM

Thanks though, amazing library

VVy Following https://blog.cloudflare.com/d1-read-replication-beta/, CF team is star...

DaniFoldi•5/1/25, 11:24 AM

I'm still hoping one day we'll have DOs in all colos, even if storageless - the use case is for websocket handling and chat rooms where persistence is external anyways

DDaniFoldi I'm still hoping one day we'll have DOs in all colos, even if storageless - the ...

Zack•5/1/25, 11:29 AM

Isn't storageless DO just a worker?

ZZack Isn't storageless DO just a worker? 🤔

DaniFoldi•5/1/25, 11:30 AM

you can't use hibernation, connect multiple websockets to the same worker, so not quite

Zack•5/1/25, 11:30 AM

Ah I see

DaniFoldi•5/1/25, 11:30 AM

but I see where you're coming from, for a simple proxy, or maybe a filtering/logging service, yeah regular workers are just fine (even better for some things since no wall time charges)

ZZack Isn't storageless DO just a worker? 🤔

lambrospetrouOP•5/1/25, 11:34 AM

The big benefit of DOs over workers even without storage is coordination due to the global uniqueness of the DO ID.

Tobias•5/1/25, 6:44 PM

We just had a customer having an outage on an important realtime-flow because a DO was hanging for >1h - no requests timed out, they were hanging in pending state.

I'm a bit out of ideas here - since there are no errors, or no indicators on why this suddenly happened.

A re-deploy fixed this, and all connections were reset.

Tobias•5/1/25, 6:45 PM

(This wall time is from an alarm in a different DO that uses RPC to connect here)

Tobias•5/1/25, 6:46 PM

In the morning we had requests erroring with an overload error - self-recovered just fine after the load was gone. But this time, we're a bit clueless - especially since there was no self recovery :/

Tobias•5/1/25, 6:47 PM

The DB in the DO is still relatively small for DB standards, with just 50k records. Nothing that should hit the limit.

Tobias•5/1/25, 6:57 PM

@Sunil Pai - this was a partyserver DO with hibernation, not sure if you have seen this one before

Tobias•5/1/25, 7:15 PM

just happened again

Tobias•5/1/25, 7:24 PM

Yes, the requests are simply not connecting from either outside w/ Websockets or inside with RPC

Tim Lonsdale•5/2/25, 4:30 PM

Hey chaps, we've just started playing around with Sqlite Durable objects. We created a really simple alarm DO that wakes itself up every minute. The actual stored data is de minimis. Its a single column in a single row in a single table of ~100 bytes max. We've had this running for not very long - but our billable duration has already hit 1.6GB-s. I feel like that can't be right - do DOs have some fixed "base" storage associated with them?

Tobias•5/2/25, 4:52 PM

This is not storage but rather a RAM-like billing

Tobias•5/2/25, 4:53 PM

1,6GB-secs mean your DO was active for about 12 secs

TTim Lonsdale Hey chaps, we've just started playing around with Sqlite Durable objects. We cre...

lambrospetrouOP•5/2/25, 4:56 PM

It's indeed confusing to calculate it, but 1.6GB-sec means it's 12.5 seconds of 128MB (the DO memory you are charged). As Tobias said.

Tim Lonsdale•5/2/25, 4:57 PM

Ah but I assumed the DO was loaded into memory and thus the 128MB was the “size” of the DO

TTim Lonsdale Ah but I assumed the DO was loaded into memory and thus the 128MB was the “size”...

lambrospetrouOP•5/2/25, 5:00 PM

Durable Objects are code like Workers, and they have durable storage you can use up to 10GB. They don't load all that storage in memory. Your DO has 128MB to use for its normal code operations, and tha'ts what you are charged for duration. The durable storage itself is charged separately.
Read https://developers.cloudflare.com/durable-objects/platform/pricing/ if you haven't.

Tim Lonsdale•5/2/25, 5:03 PM

Ah thanks for the clarification

baher•5/3/25, 2:39 PM

anyone knows how long it takes to get into the realtimeSDK beta? I applied on the 17th of april and did not get in yet

SuperHelpflare•5/3/25, 6:34 PM

Please do not post your question in multiple channels/post it multiple times per the rules at #

welcome-and-rules. It creates confusion for people trying to help you and doesn't get your issue or question solved any faster.

formatc2013•5/5/25, 6:40 AM

Hey everyone!

I have a C++ application, that creates its own sqlite database for its internals. I want to use it in a Cloudflare Durable Object. I recompiled to Webassembly, created Emscripten bindings, so now I can trigger the creation of the aforementioned database from JS, in a Durable Object class.
Question:

is this setup taking advantage of the Durable Object setup ?
or in other words, do I have to feed my query strings to
this.sql.exec(...)
or is the db created by my C++/WASM code is just as fast?

The answer seems to me that I have to use this.sql.exec(...) from the Durable Object API, but I'd like to double check before I get to coding!
https://developers.cloudflare.com/durable-objects/api/storage-api/#sql-api

Thanks

Cloudflare Docs

Durable Object Storage

The Durable Object Storage API allows Durable Objects to access transactional and strongly consistent storage. A Durable Object's attached storage is private to its unique instance and cannot be accessed by other objects.

Fformatc2013 Hey everyone! I have a C++ application, that creates its own sqlite database fo...

lambrospetrouOP•5/5/25, 8:11 AM

Your WASM database will definitely be slower. And unless you use the DO storage I don't see how your changes will be durably persisted if you only do them inside WASM.

veeque•5/5/25, 8:28 AM

when adding / keys to my queries what's the upper practical limit i should use?

Vveeque when adding `limit`/`offset` keys to my queries what's the upper practical limit...

lambrospetrouOP•5/5/25, 8:32 AM

Depends on your queries, we have folks doing hundreds of thousands of rows read per second, and we have seen a few low millions too. It depends how many of these queries you have in parallel since your DO will be blocked for that amount of time per request.
A few low/single-digit thousands should be a good ballpark to start with to still stay within a few milliseconds.