I've set the location hint to EU, that's where I am, too. I just find it hard to believe that 30ms,

I've set the location hint to EU, that's where I am, too. I just find it hard to believe that 30ms, because if your app is doing 10 round trips requests to the db, that would already sum up to 300ms...

HHannes I've set the location hint to EU, that's where I am, too. I just find it hard to...

Chaika•4/12/24, 8:46 PM

EU west or EU East?

CChaika EU west or EU East?

HannesOP•4/12/24, 8:47 PM

EU West

Chaika•4/12/24, 8:47 PM

https://where.durableobjects.live/region/weur so it could be in any one of those

Where Durable Objects Live

Western Europe(region) | Where Durable Objects Live

Tracking where Durable Objects are created, wherever you are in the world.

Chaika•4/12/24, 8:48 PM

If you go to /cdn-cgi/trace/cdn-cgi/trace, ex: https://yourwebsite.com/cdn-cgi/tracehttps://yourwebsite.com/cdn-cgi/trace, colo= the airport code of the location you hit

Chaika•4/12/24, 8:49 PM

although I suppose that wouldn't be too helpful because we still have no clue where your DB ended up lol

Chaika•4/12/24, 8:49 PM

You could be in Germany and the DB could be in Spain

Chaika•4/12/24, 8:51 PM

eitherway there's going to be some network latency. You could enable Smart Placement on your worker bound to the database so that it tries to get placed "close" but the 1.92ms mentioned in the blog is purely just sqlite query procesing time

HannesOP•4/12/24, 8:55 PM

OK, thanks for the info!

Max (@rozenmd)•4/12/24, 8:59 PM

our perf isn't worth measuring before read replicas go live tbh

MMax (@rozenmd)our perf isn't worth measuring before read replicas go live tbh

Chaika•4/12/24, 9:00 PM

kind of a funny thing to say about a GA product

Chaika•4/12/24, 9:00 PM

still writes will have to go back to the main one anyway

Chaika•4/12/24, 9:00 PM

and Smart Placement can help a great deal if you need to make more then one query

CChaika kind of a funny thing to say about a GA product

Max (@rozenmd)•4/12/24, 10:08 PM

is it though? depends what GA means to you, i guess

Original message was deleted

Chaika•4/12/24, 10:28 PM

Even replication/performance aside, if we compare it to other offerings and typical use cases, the low storage limit becomes an issue. We're told D1 is different and wants a different approach (not unlike Turso), but then we're not given the tools to use that different approach on GA.

Chaika•4/12/24, 10:29 PM

Kind of like ordering a cake, getting one of the slices and being told it's ready, and the rest will come later.. that's what beta is for, not GA

Chaika•4/12/24, 10:30 PM

it's just kinda meh, I can forsee a lot of issues people using this "GA" product and being forced to use beta/alpha read-replicas or dynamic bindings to use it for a very typical use case, misaligned expectations

kian•4/13/24, 9:49 AM

there’s a d1 export command in Wrangler

Jjbithell I'm not sure if I'm missing something - but how do we run these migrations autom...

bun•4/13/24, 1:06 PM

what does it mean migrations are not run in production ?

bun•4/13/24, 1:06 PM

you can migrate your prod db by providing

--remote

--remote

flag

James•4/13/24, 2:10 PM

This is why marketing is so important to be explicit. Some people still believe to this day that D1 is (actually) globally distributed:

https://www.reddit.com/r/CloudFlare/comments/1c2a7im/is_d1_rest_api_performant_and_production_ready/kz8u3i5/

cortadomaltese's comment on "Is D1 rest api performant and producti...

Explore this conversation and more from the CloudFlare community

James•4/13/24, 2:15 PM

sadly, yes, same misleading marketing problem

João Castro•4/13/24, 2:17 PM

Then what does "Globally distributed" means here?

James•4/13/24, 2:19 PM

Yeah. It's globally distrubuted in the sense that I can create a DB in EU, US, etc. but individual DBs are not "distributed", or "replicated"

João Castro•4/13/24, 2:20 PM

lol

James•4/13/24, 2:20 PM

Read replication is coming, and was talked about briefly in https://blog.cloudflare.com/making-full-stack-easier-d1-ga-hyperdrive-queues, but it's not here yet

João Castro•4/13/24, 2:20 PM

In the case of D1 i understand its upcoming

João Castro•4/13/24, 2:20 PM

But for R2 thats a bad look

João Castro•4/13/24, 2:21 PM

Not the kind of thing i usually expect from Cloudflare, to be honest

oof2win2•4/13/24, 4:01 PM

whats the eta on d1 read replicas?

CChaika and Smart Placement can help a great deal if you need to make more then one quer...

HannesOP•4/13/24, 5:43 PM

Yes, definitely. I enabled that and it solved my issue completely. Now the whole page load time is faster than on my VPS with a local mysql db.

Iippa just putting my 2 cents into the above discussion about d1. I actually thought i...

Beny•4/13/24, 6:48 PM

The concept is that you should be giving each of your users (or system components) their own database for only their data, rather than having one huge database everyone's combined data is stored in. It's about changing the way you think about the data storage in your application.
Understandably the 10GB limit sounds small, but in reality it is a lot of space for a database. You can fit millions of records into it while remaining under the limit. My biggest db for example has 15 million records across 200 tables, and is just over 2.5 GB.

GGustavo How to perform joins though?

Beny•4/14/24, 1:58 AM

joins work in sqlite

GGustavo I mean, is it possible to perform joins in separate databases?

Beny•4/14/24, 2:01 AM

No, it's not possible at the moment. There is an ATTACH command in sqlite which can load in more databases but D1 hasn't implemented it, and I doubt they'll add it

JJames sadly, yes, same misleading marketing problem

1girl, best quality•4/14/24, 8:30 AM

It's not a problem, it's how marketing works

1girl, best quality•4/14/24, 8:31 AM

marketing is basically scam

1girl, best quality•4/14/24, 8:31 AM

every company I know does this

Original message was deleted

zegevlier•4/14/24, 10:40 AM

Please don't post random polls like this. This is considered spam

11girl, best quality marketing is basically scam

João Castro•4/14/24, 11:48 AM

You just don't know what marketing is. You can have a scam into basically anything, it doesn't necessarily means that everything is a scam

João Castro•4/14/24, 11:49 AM

If that was the case, we wouldn't be calling out just that very specific statement

NNautranot Hi all, I'm trying to deploy this tutorial: https://developers.cloudflare.com/d...

Matt Silverlock•4/14/24, 12:23 PM

Can you validate your code looks the same as https://github.com/lauragift21/staff-directory

GitHub

GitHub - lauragift21/staff-directory: an intuitive resource hub des...

an intuitive resource hub designed to showcase the teams within an organization. - lauragift21/staff-directory

NNautranot Yes, I downloaded from there

Matt Silverlock•4/14/24, 1:39 PM

What version of wrangler are you using? Have you made any changes? cc @gift-egwuenu

I've set the location hint to EU, that's where I am, too. I just find it hard to believe that 30ms,

Similar Threads

Similar Threads

Similar Threads