Cloudflare Developers•2y ago

Cart API for us... starting to be a bit stressed

Original message was deleted

YokoWasis•5/29/24, 3:43 AM

Me too. My clients complaining non stop. I am losing millions

SSébastien Morel Cart API for us... starting to be a bit stressed

Bọc Link VN•5/29/24, 3:43 AM

me too, our customer a bit angry ,

Original message was deleted

YokoWasis•5/29/24, 3:46 AM

about 200 schools, each of them paid at least 1 million per year.

jLynx•5/29/24, 3:47 AM

Im sure the team is going as fast as they can as Cloudflare will also be losing millions while this is happening

Original message was deleted

YokoWasis•5/29/24, 3:48 AM

In emotional damage. Actually it has been 120 minutes. In my timezone it's currently work hours.

Bọc Link VN•5/29/24, 3:50 AM

yess, me too, it's up

Sébastien MorelOP•5/29/24, 3:50 AM

houhou back here too it seems

jLynx•5/29/24, 3:51 AM

Awesome both D1 and AI Gateway are back for me too @Daniel Ray

Wesley•5/29/24, 3:53 AM

seems working now

YokoWasis•5/29/24, 3:57 AM

Finally.

Daniel Ray•5/29/24, 3:58 AM

Hello Guys, as you've noticed the issue should now be resolved. Our engineering team are going to continue monitoring before officially declaring it resolved. But our status page will be updated once they are confident enough time has passed to be confident in setting the status to solved.

Daniel Ray•5/29/24, 3:59 AM

Earlier on it was asked if there would be a write-up about what happened. I can not officially commit to anything myself. However, I think there will likely be a public write-up for this at some point. If it does happen, most likely you will see it here: https://blog.cloudflare.com/

The Cloudflare Blog

Get the latest news on how products at Cloudflare are built, technologies used, and join the teams helping to build a better Internet.

Daniel Ray•5/29/24, 4:00 AM

If you are an enterprise customer and you need something sooner, you should be able to contact your CSM to get a RCA for this once it's available.

DDaniel Ray Earlier on it was asked if there would be a write-up about what happened. I can...

jLynx•5/29/24, 4:00 AM

If/when this happens, if someone could also share the link here, that would be awesome

JjLynx If/when this happens, if someone could also share the link here, that would be a...

Daniel Ray•5/29/24, 4:05 AM

I'll try to keep a look-out for it and post it here if I see it first (assuming it happens). Chances are it'll be posted up outside my timezone and somebody else will beat me to it!

DDaniel Ray I'll try to keep a look-out for it and post it here if I see it first (assuming ...

Chaika•5/29/24, 4:05 AM

challenge accepted

DDaniel Ray I'll try to keep a look-out for it and post it here if I see it first (assuming ...

jLynx•5/29/24, 4:05 AM

So if it happens, are you saying it will be posted withing the next 48 hours or so?

JjLynx So if it happens, are you saying it will be posted withing the next 48 hours or ...

Daniel Ray•5/29/24, 4:08 AM

I do not know sorry. It might happen within 48 hours, it might take longer.

jLynx•5/29/24, 4:09 AM

All good

jLynx•5/29/24, 4:09 AM

Thanks for all the help

Sébastien MorelOP•5/29/24, 4:09 AM

thanks guys!

Daniel Ray•5/29/24, 4:10 AM

You are welcome, thank you for all the feedback.

francesco.zuppichini#66•5/29/24, 8:29 AM

Hi there, how is everyone doing?

Is there a way to use the normal next run devnext run dev with cloudfare

d1

d1

? The bindings not always work and I'd like to avoid compiling the whole thing at every change

Thanks a lot

Koosh•5/29/24, 10:38 AM

anyone have a good GUI for D1, TablePlus (Mac) doesn't seem to work properly with a table of only 450 rows, crashes on latest version - the cloudflare console is very basic and too slow to use really

KKoosh anyone have a good GUI for D1, TablePlus (Mac) doesn't seem to work properly wit...

Hello, I’m Allie!•5/29/24, 10:39 AM

https://orm.drizzle.team/drizzle-studio/overview ?

Drizzle ORM - Meet Drizzle Studio

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Vlady•5/29/24, 3:29 PM

Y'all, is there a gui that doesn't require Drizzle? I tried https://github.com/JacobLinCool/d1-manager but that doesn't work if you want to connect to a local db in another project. I just want to preview some tables locally in a visual manner.

VVlady Y'all, is there a gui that doesn't require Drizzle? I tried https://github.com/J...

Hello, I’m Allie!•5/29/24, 3:49 PM

I use https://marketplace.visualstudio.com/items?itemName=qwtel.sqlite-viewer from VSCode

SQLite Viewer - Visual Studio Marketplace

Extension for Visual Studio Code - SQLite Viewer for VSCode

VVlady Y'all, is there a gui that doesn't require Drizzle? I tried https://github.com/J...

kraustifer•5/29/24, 4:31 PM

https://x.com/tableplus/status/1776611556509253687?s=46&t=KvGal2nXGgMSIuYjfJ6YGQ

TablePlus (@TablePlus) on X

TablePlus will support Cloudflare D1 in the next update!

Twitter

•

4/6/24, 2:02 PM

Ppeshakoo what are the cons of making a DB per "user", instead of sharding; as the amount ...

Hello, I’m Allie!•5/29/24, 7:32 PM

Queries across multiple users become hard, if not impossible. For example, if you have a system for posts made by a user, counting the total number of posts on your platform will be difficult

Ppeshakoo I see...

Hello, I’m Allie!•5/29/24, 7:34 PM

Also, applying migrations would be very difficult too

Hello, I’m Allie!•5/29/24, 7:35 PM

Since you would need to store a reference to every DB you have, apply the migration to each, track which DBs are on what migration, etc. And what do you do if the migration breaks a DB halfway through a rollout?

KKoosh anyone have a good GUI for D1, TablePlus (Mac) doesn't seem to work properly wit...

Lane C•5/29/24, 8:19 PM

I'm the author of https://sonicjs.com/, might be a good fit depending on your requirements. Has a full web based GUI for your D1 based schema. @Vlady per your questions above as well

HHello, I’m Allie!Since you would need to store a reference to every DB you have, apply the migrat...

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

those are problems that we're looking at fixing with dynamic bindings, and change-data-capture

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

wouldn't make sense to let folks migrate a million dbs in one go imo

MMax (@rozenmd)those are problems that we're looking at fixing with dynamic bindings, and chang...

Hello, I’m Allie!•5/29/24, 8:21 PM

Would the dynamic bindings system support listing all existing DBs? I know that is an issue with DOs where you have to store their IDs somewhere

Hello, I’m Allie!•5/29/24, 8:21 PM

Or have a list of names stored somewhere

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

still speccing it out - DO not listing instances is also a pain I personally want fixed

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

we released the

.raw()

.raw()

API as an HTTP endpoint: https://developers.cloudflare.com/api/operations/cloudflare-d1-raw-database-query

It fixes the issue where you couldn't JOIN two tables containing columns with the same name

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

MMax (@rozenmd)we released the `.raw()` API as an HTTP endpoint: https://developers.cloudflare....

Isaac McFadyen•5/29/24, 8:43 PM

Ohhhh this is so helpful!

Isaac McFadyen•5/29/24, 8:44 PM

The column names in particular.

Isaac McFadyen•5/29/24, 8:44 PM

Right now I'm doing 2 queries in d1-jdbc-driver (query + get the column schema), this way I can do a query once to get the schema and then match with the cached schema.

Isaac McFadyen•5/29/24, 8:44 PM

I guess I could do that before with the keys... but still handy here.

Kkraustifer https://x.com/tableplus/status/1776611556509253687?s=46&t=KvGal2nXGgMSIuYjfJ6YGQ

Koosh•5/29/24, 10:40 PM

I’ve got table plus, it doesn’t seem to work for one of my tables, program locks up and gives some error that goes off the screen so you need to force close

Avi•5/30/24, 3:35 AM

hey! am i remembering correctly that D1 is internally implemented on top of Durable Objects?

AAvi hey! am i remembering correctly that D1 is internally implemented on top of Dura...

Isaac McFadyen•5/30/24, 3:40 AM

So it used to be, and still is, partially. There were two backends:
Alpha: implemented on Durable Objects using the Durable Objects Storage API. This was quite slow and eventually deprecated and will no longer receive updates.
Beta and Production (what we have now): a whole new SQLite storage engine was implemented on top of Durable Objects, meaning it still uses DOs but the new engine. The SQLite engine is not yet exposed to users but they've said they eventually want to allow DOs to directly access it.

A Twitter thread by the Workers lead engineer on this topic: https://x.com/KentonVarda/status/1659551757796515846

Original message was deleted

Bọc Link VN•5/30/24, 8:22 AM

thank you for sharing

Cart API for us... starting to be a bit stressed

Similar Threads

Similar Threads

Similar Threads