Cloudflare Developers•13mo ago

If D1 is distributed (read only) why so much diference from just a SELECT from the EU and the US?

Mmaguayo If D1 is distributed (read only) why so much diference from just a SELECT from t...

Hello, I’m Allie!•12/24/24, 7:05 AM

It’s not, D1 is single-location for now

HHello, I’m Allie!It’s not, D1 is single-location for now

maguayoOP•12/24/24, 7:07 AM

It's there a timeline? I am migrating everything because the documentation says it's distributed

maguayoOP•12/24/24, 7:09 AM

I thought you could have many instances in each region or something like that

maguayoOP•12/24/24, 7:10 AM

There is a whole section in D1 documentation about read replicas. Is this not true??

FFriday Candour "RETURNING *" not working on D1 how to get around that?

maguayoOP•12/24/24, 7:57 AM

I mean.. they market as D1 is distributed and read replicas.. I expected you know, they have read replicas.

Mmaguayo There is a whole section in D1 documentation about read replicas. Is this not tr...

Hello, I’m Allie!•12/24/24, 8:07 AM

It’s a planned feature, but it doesn’t exist yet

FFriday Candour but it's same query right?

maguayoOP•12/24/24, 8:14 AM

Exactly the same query from different locations.

HHello, I’m Allie!It’s a planned feature, but it doesn’t exist yet

maguayoOP•12/24/24, 8:15 AM

Can we know if it's planned for Q1 or more into the future?

FFriday Candour omg cloudflare

maguayoOP•12/24/24, 10:17 AM

Yeah.. Time to refactor everything since I counted with read replicas since their documentation mentions them...

TTrojan this happens because the API for the sqlite d1 file in miniflare is slightly dif...

theo•12/24/24, 6:12 PM

I might have a tool that helps a bit with managing the env/config

theo•12/24/24, 6:14 PM

loads config like dotenv but also has validations, and a nice wrangler integration - https://dmno.dev/

Ttheo I might have a tool that helps a bit with managing the env/config

Trojan•12/24/24, 8:38 PM

dang thanks! i’ll check it out

TTrojan dang thanks! i’ll check it out

theo•12/24/24, 8:44 PM

the cloudflare integration is brand new, so happy to help and work through any issues

Trojan•12/24/24, 8:52 PM

“Being able to see all of these values and which one is currently active will save you tons of headaches”

huge. im tired of “zero config” “common sense” “best practice” “no code” etc

FFriday Candour "RETURNING *" not working on D1 how to get around that?

o7•12/26/24, 11:39 PM

it works for me

Amodeus R.•12/27/24, 12:59 AM

I was trying out the d1 get started guide and the first command to create a d1 project doesn't work. I tried using npm and it throw a 404 Error. I tried using npx also but a similar error happened, although a little bit different as you can see on the terminal. I tried installing create-cloudfare and it also didn't work. What do I need to do to make it work?

AAmodeus R.I was trying out the d1 get started guide and the first command to create a d1 p...

James•12/27/24, 1:28 AM

It looks like you typo’d cloudflare to cloudfare

Amodeus R.•12/27/24, 2:36 AM

Oh, what a rookie mistake haha thanks for pointing it out

kamama•12/27/24, 5:16 AM

If I got multiple databases in local, how can I get the exact SQLite path for specific database ?

iqorex•12/27/24, 8:27 AM

Hey i have db per user case, and now i need to check it with cron if a user have some event scheduled to do some processing and send emails. Is there any smart way of querying all databases at once?

James•12/27/24, 2:08 PM

sadly not really. If we had dynamic bindings this'd be easier, which were a "before GA" promise as per https://canary.discord.com/channels/595317990191398933/992060581832032316/1164575886520090684, but still nothing to report there.

JJames sadly not really. If we had dynamic bindings this'd be easier, which were a "bef...

iqorex•12/27/24, 3:12 PM

thanks

JJames sadly not really. If we had dynamic bindings this'd be easier, which were a "bef...

Zack•12/27/24, 7:09 PM

Read only replicas are coming before the end of the year too!

:COPIUM:

ZZack Read only replicas are coming before the end of the year too! 😅 :COPIUM:

maguayoOP•12/27/24, 9:46 PM

where did you see that anouncement?

Mmaguayo where did you see that anouncement?

Zack•12/27/24, 9:46 PM

In one of the blog posts

Iiqorex Hey i have db per user case, and now i need to check it with cron if a user have...

1984 Ford Laser•12/28/24, 1:21 AM

Durable Objects would be the best way forward here

ajgeiss0702•12/29/24, 3:02 AM

the math aint mathing

Aajgeiss0702 the math aint mathing

Hello, I’m Allie!•12/29/24, 6:29 AM

That might be because the system that powers account-level analytics may be a bit behind the actual values

HHello, I’m Allie!That might be because the system that powers account-level analytics may be a bi...

ajgeiss0702•12/29/24, 6:29 AM

if thats the case, then that would be like a year behind

Aajgeiss0702 if thats the case, then that would be like a year behind

Hello, I’m Allie!•12/29/24, 6:30 AM

Weird

ajgeiss0702•12/29/24, 6:31 AM

that 3gb db has been well past that size for a loooong time

ajgeiss0702•12/29/24, 6:32 AM

not the end of the world, but a bit odd

Amodeus R.•12/29/24, 12:24 PM

Is it possible to use a backend framework like fastify in a wrangler/d1 project? And what about postgres to make queries?

kamama•12/29/24, 2:18 PM

I’m encountering D1 slow response, like 500ms+, but my table only have 10 rows, the database is under APAC region. Is that expected?

kamama•12/29/24, 2:18 PM

Request without D1 fetch, around 30ms. With D1 fetch around 600ms

Walshy•12/29/24, 2:19 PM

Where is your worker invoked?

Walshy•12/29/24, 2:19 PM

And are you using smart placement?

WWalshy Where is your worker invoked?

kamama•12/29/24, 2:22 PM

Also under APAC

kamama•12/29/24, 2:23 PM

default placement

Original message was deleted

Igal•12/29/24, 10:33 PM

Lighter Prisma is in the works.
The Kysely gap you described is solvable today-ish with plugins, and possibly in the future with some new APIs (but without turning the library into yet another ORM.)

kamama•12/30/24, 1:28 AM

Also when I create D1, if I don’t specific region, it will create in North America, but it’s obviously far away from APAC. Is this recommended?

fernvenue•12/31/24, 5:12 AM

Hello everyone, does D1 have a boolean value? If not, what are the best practices for implementing boolean values on D1?

fernvenue•12/31/24, 5:13 AM

fernvenue•12/31/24, 5:14 AM

Ah, got it.

Astral•12/31/24, 2:39 PM

Hey all

I'm a massive Cloudflare advocate in my big organization, and we use it heavily. So far we haven't been using D1 as we have no need. But I've started using it on a side passion project of my own.
So far everything works how I would like it, except that the Response time for basically any query (even the most simple ones) are very high.

I have a worker which serves as my API layer, and it calls the D1 internally. Every request takes over 2-3 sec to respond.

What is your experience with D1 response times?

Also to mention, the DB is very small ~12kb in total.

If D1 is distributed (read only) why so much diference from just a SELECT from the EU and the US?

Similar Threads

Similar Threads

Similar Threads