Thanks for the response! Just out of curiosity, how is that mechanism working? Does D1 create a read

Thanks for the response! Just out of curiosity, how is that mechanism working? Does D1 create a read only replica on the edge, and all writes goto a centralized DB, with eventual consistency?

LLeif Thanks for the response! Just out of curiosity, how is that mechanism working? D...

Max (@rozenmd)•8/24/24, 1:34 PM

the D1 binding lets us skip the db

LeifOP•8/24/24, 1:43 PM

So there's just some cloudflare proprietary magic keeping the edge sqlite files in sync, and I can just use the D1 binding like I'm talking to a single database? If so thats pretty awesome.

Max (@rozenmd)•8/24/24, 2:41 PM

D1 dbs are on the edge

James•8/24/24, 3:54 PM

Yeah I think the biggest confusion here is around what most people associate the ‘edge’ with - which for most people means being close to all of your users, all the time, all at once, like Workers. With D1, that’s simply not the case with the DB in a single location.
Marketing and terminology is hard

James•8/24/24, 3:55 PM

‘Core’ also has a very specific cf meaning so probably isn’t that helpful in describing stuff to end-users honestly

JJames Yeah I think the biggest confusion here is around what most people associate the...

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

ah right, for now

MMax (@rozenmd)ah right, for now

Dean•8/25/24, 5:47 AM

birthday week announcements hopefully

Max (@rozenmd)•8/25/24, 12:32 PM

personally I'm in raw SQL gang

boop•8/25/24, 1:07 PM

At a young age my parents taught me the importance of always using protection, and this is why I use Drizzle

HHello, I’m Allie!Preview runs against a real D1 DB

0xwei_hup•8/25/24, 3:14 PM

totally missed this. but thanksss

Ashish Rawat•8/26/24, 7:55 AM

Seems like D1 doesn't support

ATTACH DATABASE

ATTACH DATABASE

command to aggregate from multiple D1.

AAshish Rawat Seems like D1 doesn't support `ATTACH DATABASE` command to aggregate from multip...

Max (@rozenmd)•8/26/24, 9:07 AM

correct

Yo•8/26/24, 2:08 PM

Yo•8/26/24, 2:12 PM

When i insert data "row_written": 3

YYo When i insert data "row_written": 3

Matt Silverlock•8/26/24, 2:14 PM

https://developers.cloudflare.com/d1/platform/pricing/#definitions

Indexes will add an additional written row when writes include the indexed column, as there are two rows written: one to the table itself, and one to the index. The performance benefit of an index and reduction in rows read will, in nearly all cases, offset this additional write.

MMatt Silverlock https://developers.cloudflare.com/d1/platform/pricing/#definitions > Indexes wi...

Yo•8/26/24, 9:25 PM

Thank

Yo•8/26/24, 9:26 PM

What is your cpu time limit for cloudflare page?

YYo What is your cpu time limit for cloudflare page?

boop•8/26/24, 9:51 PM

D1 query duration? 30 seconds
Pages functions duration? Free: 10ms, Paid: 30 seconds

Bboop D1 query duration? 30 seconds Pages functions duration? Free: 10ms, Paid: 30 sec...

Yo•8/26/24, 9:58 PM

I use free plan for test it show cpu time over 10ms but But it can still be used normally

YYo I use free plan for test it show cpu time over 10ms but But it can still be used...

boop•8/26/24, 10:03 PM

https://developers.cloudflare.com/workers/platform/limits/#cpu-time

"Each isolate has some built-in flexibility to allow for cases where your Worker infrequently runs over the configured limit. If your Worker starts hitting the limit consistently, its execution will be terminated according to the limit configured."

Cloudflare Docs

Limits | Cloudflare Workers docs

Cloudflare Workers plan and platform limits.

Chaika•8/26/24, 10:08 PM

there's a more in-depth explanation of it here: How are CPU limits enforced in the free tier?

Bboop https://developers.cloudflare.com/workers/platform/limits/#cpu-time "Each isola...

Yo•8/26/24, 10:28 PM

I use Page but I dont sure limit cpu time for Page

YYo I use Page but I dont sure limit cpu time for Page

boop•8/26/24, 10:29 PM

Any functions you perform on your Pages project is just a worker, so the same limits apply

Bboop Any functions you perform on your Pages project is just a worker, so the same li...

Yo•8/26/24, 10:31 PM

I use nuxt3 for SPA but i dont use server on nuxt. I'm not sure which part is calling the function

boop•8/26/24, 10:32 PM

This isn't the channel for that, try coding-help

louiek22•8/27/24, 12:28 AM

Is it possible to use the results of a previous query in a

d1.batch

d1.batch

call in the next query? I'm worried that sending a read query to find a specific row, waiting for the results in JS, and then sending a write query may end up with 2 workers trying to edit the same row.

Llouiek22 Is it possible to use the results of a previous query in a `d1.batch` call in th...

louiek22•8/27/24, 12:53 AM

Solved this by combing my

SELECT

SELECT

query into my

UPDATE

UPDATE

query and using

LIMIT 1

LIMIT 1

so I can do everything in a single query.

tester123•8/27/24, 11:49 AM

hey guys

tester123•8/27/24, 11:49 AM

d1 or neondb is better overall for cloudflare workers?

minwoo•8/27/24, 5:44 PM

hey,
Are you having issues with your current D1 database?

zorous•8/27/24, 6:13 PM

how do i pull the data that is on my dashboard into my local project?

discondition•8/27/24, 9:34 PM

What latency are you guys getting?

I don’t what to expect but my Remix worker that calls out to my DB is taking 300-400 ms for really simple queries. This ain’t good enough for what I want really, hopefully there are ways to speed it up. I have the smart location switched on.

Ttester123 d1 or neondb is better overall for cloudflare workers?

James•8/27/24, 10:34 PM

Neon is Postgres which is much more versatile than SQLite in my opinion and what I’d generally recommend personally

James•8/27/24, 10:35 PM

We use neon + workers, with Postgres.js very successfully. What are you building though? Maybe SQLite makes more sense?

Ddiscondition What latency are you guys getting? I don’t what to expect but my Remix worker t...

o7•8/28/24, 1:48 AM

right under 100ms and I am not near a D1/DO colo

Ddiscondition What latency are you guys getting? I don’t what to expect but my Remix worker t...

toadfans•8/28/24, 2:06 AM

200-300ms

JJames We use neon + workers, with Postgres.js very successfully. What are you building...

discondition•8/28/24, 2:11 AM

Just a basic crud kind of app

Separated user data

Oo7 right under 100ms and I am not near a D1/DO colo

discondition•8/28/24, 2:11 AM

What’s the secret?

o7•8/28/24, 2:12 AM

ermmm I guess I am just doing a simple select on a primary key

discondition•8/28/24, 2:12 AM

So am I

Ddiscondition So am I 🥲

o7•8/28/24, 2:13 AM

This isn't a map of D1, but it's a map of DO and D1 is based on DO so it might give u a little bit of an idea where your DB is

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

o7•8/28/24, 2:16 AM

I may or may not be 800km away from my DB, getting under 100ms with the smart placement being local. Sometimes when the smart placement works (enough traffic) I get around 70ms

discondition•8/28/24, 2:20 AM

Thanks, I guess I gotta look into optimistic UI

Ttoadfans 200-300ms

Max (@rozenmd)•8/28/24, 5:41 AM

where are you based? D1 is still subject to the speed of light, so 200ms round-trips between australia and usa are a thing

bennycondon•8/28/24, 6:34 AM

Is there a way to lift the "Maximum Length Of A LIKE Or GLOB Pattern"? I'm running into "Error: LIKE or GLOB pattern too complex: SQLITE_ERROR" when the pattern exceeds 50 characters.

Jorge•8/28/24, 7:52 AM

the 10GB limit worries me, well thats a problem for future me anyways

神

神龙出海•8/28/24, 8:42 AM

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

神

神龙出海•8/28/24, 8:43 AM

Does anyone know what is going on? It has been more than 2 hours since my production environment database suddenly became unavailable. The test environment is fine.

Thanks for the response! Just out of curiosity, how is that mechanism working? Does D1 create a read

Similar Threads

Similar Threads

Similar Threads