In india you mean @Unsmart | Tech debt ?

Chaika•2/15/24, 6:38 PM

CF has a pretty decent presence in Singapore as well, was one of the first AI supported places, and they've got 10 colos there, so at least a handful of separate Datacenters for failover

SSantosh In india you mean @Unsmart | Tech debt ?

Unsmart•2/15/24, 6:39 PM

yes

SantoshOP•2/15/24, 6:40 PM

I think the landscape will change soon. India's customer base - it is just a matter of time. Massive customer base and proximity will matter over time

SantoshOP•2/15/24, 6:40 PM

What kind of latency did you guys see between India and SG for DO? Any stats?

Chaika•2/15/24, 6:40 PM

on the where durableobjects live site it'll tell you latency

Chaika•2/15/24, 6:41 PM

Chaika•2/15/24, 6:41 PM

left hand side

SantoshOP•2/15/24, 6:41 PM

HYderabad India says 210 ms

SantoshOP•2/15/24, 6:41 PM

Isnt that kind of lot?

Chaika•2/15/24, 6:42 PM

seems a little high but it is going over those international submarine cables which have had issues for a while with being cut/disabled/overloaded/etc. APAC bandwidth/latency in general. Might also be due to the local Indian ISPs are routing things.

Chaika•2/15/24, 6:42 PM

This is probably a topic better fit for #durable-objects or #general-discussions rather then d1-beta though

SantoshOP•2/15/24, 6:42 PM

Glad we dont have pirates in those areas

SantoshOP•2/15/24, 6:44 PM

yes, moving on from this topic

Mrxbox98•2/15/24, 7:07 PM

Do I have to use cloudflare pages to use d1 on a website?

MMrxbox98 Do I have to use cloudflare pages to use d1 on a website?

Hello, I’m Allie!•2/15/24, 7:08 PM

No, you can use Workers too

HHello, I’m Allie!No, you can use Workers too

Mrxbox98•2/15/24, 7:09 PM

Can I use d1 with a website that I host elsewhere?

SShyim what is the best way to export the db? 🤔 The request is malformed: Experiment...

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

https://github.com/nora-soderlund/cloudflare-d1-backups until we build the feature natively

GitHub

GitHub - nora-soderlund/cloudflare-d1-backups: A package to dump a ...

A package to dump a copy of your experimental D1 database through a worker. - nora-soderlund/cloudflare-d1-backups

SantoshOP•2/15/24, 10:19 PM

How come D1 would be so much cheaper as compared to DO from a pricing perspective? I am contrasting DO Transaction storage API (reads) + a DO call with D1 reads. Dont they all use the same tech behind the scenes?

clearwater4227•2/15/24, 10:37 PM

is d1 having any kind of issues? My api is getting rows_read as positive but no results array is returned...

clearwater4227•2/15/24, 10:45 PM

thanks! testing now...

clearwater4227•2/15/24, 10:49 PM

hmm.....still not working...

const db = drizzle(env.user_prefs_database);
var res = await db
.select()
.from(user_preferences)
.where(eq(user_preferences.account_id, account_id))
.all();
if (res.results.length == 0) {

thats the code. It works running locally with wrangler...

clearwater4227•2/15/24, 10:49 PM

actually.... .all() does not work locally.... .run() works locally

Original message was deleted

clearwater4227•2/15/24, 10:57 PM

Any thoughts? it seems like .run() works locally.... .all() does not, locally or deployed...

clearwater4227•2/15/24, 11:00 PM

ah.... using this as compatibiltiy date:

compatibility_date = "2023-08-28"

clearwater4227•2/15/24, 11:00 PM

looking into it ...thank you

clearwater4227•2/15/24, 11:49 PM

hmmm...yeah, dosent look like it....might need to switch off drizzle..

MMax (@rozenmd)if you add caching to your Worker so it doesn't have to wait for the request fro...

SantoshOP•2/16/24, 12:09 AM

Not a D1 issues as is, more with the toolkit around it. I tried using d1-manager. Added all DB_* variables to point settings to my D1 database. Still cant see databases at the top on UI. Anyone else encountered this? What did you do to fix this?

Cyb3r-Jak3•2/16/24, 4:49 AM

Please don’t ping people directly

Cyb3r-Jak3•2/16/24, 4:51 AM

Also, I just checked and my D1 databases are fine

Original message was deleted

Cyb3r-Jak3•2/16/24, 4:51 AM

I know, pinging people and asking to escalate isn’t going to help.

artakiel•2/16/24, 5:04 AM

artakiel•2/16/24, 5:09 AM

Can you speak french community ?

oof2win2•2/16/24, 9:50 AM

is there a way to get the URL to the local d1 database for tools such as prisma?

Ooof2win2 is there a way to get the URL to the local d1 database for tools such as prisma?

Hello, I’m Allie!•2/16/24, 9:51 AM

There isn't one

oof2win2•2/16/24, 9:53 AM

but when you run it with --local it creates the local db

Ooof2win2 but when you run it with --local it creates the local db

Hello, I’m Allie!•2/16/24, 9:58 AM

Oh, if you mean the file path, then you can build it yourself with the database ID

oof2win2•2/16/24, 9:59 AM

okay, thanks

oof2win2•2/16/24, 9:59 AM

the annoying thing for prisma is it can't introspect the db and see if rows would be deleted or not since there isn't a URL

MMatt Silverlock Official change-log and updated documentation for breaking changes to `all()`, `...

Ashkan•2/16/24, 10:53 AM

Hi, wish there was an warning email about the changes in my email inbox. I got shocked why my web application was totally out of service.

ammarriq•2/16/24, 12:40 PM

It is mentioned on Cloudflare d1 page that it supports SQLite triggers.

Anyone here who knows how to create triggers?

Aammarriq It is mentioned on Cloudflare d1 page that it supports SQLite triggers. Anyone ...

Max (@rozenmd)•2/16/24, 1:20 PM

https://www.sqlite.org/lang_createtrigger.html might help

Ɽ

ⱤØ₥₳₦•2/16/24, 1:29 PM

Is there any specific write/read per second limit on D1? Docs says nothing like that

MMatt Silverlock Changelog going out soon, but for those here: * D1's `.raw()`, `.all()` and `.r...

Isaac McFadyen•2/16/24, 1:31 PM

Is there a reason this couldn't have been a compat-date gated change? Seems quite a few people are running into this breaking change, and having a Worker in prod break when not expected is exactly what compat dates were designed to solve...

ⱤⱤØ₥₳₦Is there any specific write/read per second limit on D1? Docs says nothing like ...

Max (@rozenmd)•2/16/24, 2:02 PM

It's not a "limit" we set, as much as a beta architectural limitation - your D1 database currently runs from a single durable object instance, and there's only so much work a single thread can do per second before overloading

IIsaac McFadyen Is there a reason this couldn't have been a compat-date gated change? Seems quit...

James•2/16/24, 2:12 PM

Agreed, R2 and Vectorize had similar changes to their data structures and things and just introduced those with a compat date/flag. Feels weird for a product like D1 that’s even further along to not have done that.

IIsaac McFadyen Is there a reason this couldn't have been a compat-date gated change? Seems quit...

Max (@rozenmd)•2/16/24, 2:25 PM

We saw it as a bug fix - the correct behaviour was documented, and .run().run() used to work as documented

MMax (@rozenmd)We saw it as a bug fix - the correct behaviour was documented, and `.run()` used...

James•2/16/24, 2:30 PM

It still broke people’s workers though unfortunately, and especially if they’re not in discord or don’t know to manually check changelogs, they’re left confused and frustrated that code that they previously had working, no longer does, with no change of their own. Unless there were alerts sent to people impacted outside of that?

JJames It still broke people’s workers though unfortunately, and especially if they’re ...

Vy•2/16/24, 2:56 PM

We're looking into a resolution here to restore the previous .run.run behvaior and I'll report back. Apologies and yes we should/will be applying compatibility dates to D1 breaking chnages

In india you mean @Unsmart | Tech debt ?

Similar Threads