No data will be wiped from alpha to beta/GA

tobias-•9/20/23, 10:40 AM

I'm trying to implement a simple optimistic lock, but I can't find any method where I get the number of affected lines for an update, while still allowing binding of values. The D1Database has

exec(): D1ExecResult

exec(): D1ExecResult

(which does include count), but if I want to perform something similar on

D1PreparedStatement

D1PreparedStatement

, I'm lost. What am I missing?

Ttobias-I'm trying to implement a simple optimistic lock, but I can't find any method wh...

Matt SilverlockOP•9/20/23, 11:01 AM

It’s not implemented. Open an issue on GitHub?

MMatt Silverlock It’s not implemented. Open an issue on GitHub?

tobias-•9/20/23, 11:02 AM

Haha, I'm still struggling with the concept of "open alpha" apparently

I thought everything was more or less done and now it was just bug-squashing, tooling and possibly backend stuff. I'll make a feature request. Thanks

Ttobias-Haha, I'm still struggling with the concept of "open alpha" apparently 🙂 I thou...

Matt SilverlockOP•9/20/23, 11:11 AM

I would never say features are “complete”, even at GA. There’s a near infinite list of things to build.

JJeff hey Matt what was the issue of the DB's failing?

Matt SilverlockOP•9/20/23, 12:32 PM

We’re still debugging. It’s deep in our storage layer which is why it only affected so few. There’s nothing unique about any of the DBs here or access patterns.

KKev yeah now my issues seem intermittent, feeling anecdotally like the issue is on "...

Matt SilverlockOP•9/20/23, 2:06 PM

You are still seeing it not respond? Remind me the DB ID?

KKev 48f19693-ce7b-4869-95df-f1b1fe1e411c it's hard to pin down, so i'm sorry if it's...

Matt SilverlockOP•9/20/23, 2:21 PM

Can you specify the error exactly here? I want to avoid conflating this with other issues (given you're now the only one reporting continued errors)

KKev 48f19693-ce7b-4869-95df-f1b1fe1e411c it's hard to pin down, so i'm sorry if it's...

Matt SilverlockOP•9/20/23, 2:30 PM

I see one occurrence of what appears to be the same error in the last 6 hours

KKev @Matt this is the behaviour we see. I cannot replicate the issue other than user...

Matt SilverlockOP•9/20/23, 2:34 PM

No, no problems at all. We want zero errors like this

MMatt Silverlock No data will be wiped from alpha to beta/GA

MetalGear•9/21/23, 1:23 PM

What is something that could happen so we know if it’s suitable for our apps to use today

MMetalGear What is something that could happen so we know if it’s suitable for our apps to ...

Matt SilverlockOP•9/21/23, 1:38 PM

Can you expand? We have no intention of actively deleting databases users have created, including those on the old backend (we will ask users to migrate more directly closer to GA).

MetalGear•9/21/23, 1:39 PM

For example I have a hotel reservation system. What kind of interruptions can I experience while using d1 right now. Not asking for promises because I get it’s open alpha for a reason just kind of trying to understand the usual problems one can experience in open alpha

MMetalGear For example I have a hotel reservation system. What kind of interruptions can I ...

Matt SilverlockOP•9/21/23, 1:41 PM

I think the best thing you can do is scan this Discord. We see very, very few issues, but not zero. There's no way for me to quantify that for you beyond that.

MMatt Silverlock I think the best thing you can do is scan this Discord. We see very, very few is...

MetalGear•9/21/23, 1:42 PM

That’s fair Ty for all you’re amazing work. Man I love cloudflare I just really wish there was more guidance on architecture and design of productions built using services on your platform for newer engineers without much production experience.

MMatt Silverlock No data will be wiped from alpha to beta/GA

dave•9/21/23, 3:27 PM

Aren’t we beta now?

Unsmart•9/21/23, 3:31 PM

nope its still alpha I just think the new storage engine got called beta in the api or whatever

UUnsmart nope its still alpha I just think the new storage engine got called beta in the ...

enfipy•9/21/23, 5:19 PM

what about D1 Limits? will the D1 database scale more than 5 GB (as mentioned in Pricing Page with $0.75 / GB-mo), or be limited to 500 MB as mentioned in D1 Limits?

Eenfipy what about D1 Limits? will the D1 database scale more than 5 GB (as mentioned in...

Cyb3r-Jak3•9/21/23, 5:20 PM

It will be the 5 GB as they is what they announced. The team has not increased that that amount yet

enfipy•9/21/23, 5:22 PM

Thanks for this info! It was confusing for me as the docs mention Alpha to limit 500 MB but Pricing 5 GB.
P.S: Great job with D1, feels like magic

enfipy•9/21/23, 5:24 PM

oh, no...

Original message was deleted

Matt SilverlockOP•9/21/23, 6:14 PM

500mb per database * 10 databases does add up to 5gb admittedly

This one ^

MMatt Silverlock Keep in mind D1 won’t charge extra for replication (and it won’t multiply storag...

Dahoom•9/21/23, 11:09 PM

I'm sorry for asking this since you heard it so many times, is there any estimated arrival time for replication? I'm talking less than 6 months / more than 6 months. I don't mind if its wrong I just need a clearer picture to plan ahead!

DDahoom I'm sorry for asking this since you heard it so many times, is there any estimat...

Matt SilverlockOP•9/22/23, 12:50 PM

We’ll share more news soon.

Dahoom•9/22/23, 12:51 PM

UUnsmart nope its still alpha I just think the new storage engine got called beta in the ...

dave•9/22/23, 2:06 PM

oh, that's kinda a confusing naming system.

Thanks!

Ddave oh, that's kinda a confusing naming system. 😅 Thanks!

forslunds•9/22/23, 2:23 PM

But maybe a hint that D1 beta is ”soon”

Fforslunds But maybe a hint that D1 beta is ”soon” 🤣

Hello, I’m Allie!•9/22/23, 7:39 PM

Of course! It will always be soon, as it always has been... /s

MMatt Silverlock I think the best thing you can do is scan this Discord. We see very, very few is...

captain•9/22/23, 9:32 PM

is there a known open issues area? For me it's seems rock solid, but would love to know if I am missing anything

kian•9/22/23, 11:40 PM

https://github.com/cloudflare/workers-sdk/issues?q=is%3Aopen+is%3Aissue+d1+label%3Ad1%3Aalpha

kian•9/22/23, 11:41 PM

Not all bugs, some are feature requests - but it'll give you an idea of what people are hitting.

Kkian <https://github.com/cloudflare/workers-sdk/issues?q=is%3Aopen+is%3Aissue+d1+labe...

captain•9/22/23, 11:47 PM

thanks! I'm using wrangler 3.6... guess I'll stick to 3.6 because this issue scares me: https://github.com/cloudflare/workers-sdk/issues/3922

GitHub

🐛 BUG: MacOS Wrangler & D1 experiencing internal error · Issue #392...

Which Cloudflare product(s) does this pertain to? D1 What version(s) of the tool(s) are you using? 3.7.0 What version of Node are you using? 18.16.0 What operating system are you using? Mac Ventura...

benthecarman•9/23/23, 3:51 AM

Hey, our database keeps going down, are we able to get any status updates on when this will be fixed?

benthecarman•9/23/23, 3:51 AM

This product is basically becoming unusable for us, it goes down for hours every couple of days

meyer•9/23/23, 4:03 AM

Bbenthecarman Hey, our database keeps going down, are we able to get any status updates on whe...

Unsmart•9/23/23, 4:11 AM

As pointed out above it’s an alpha product and you should not be using it for production. But haven’t heard of much issues recently beyond a little bit of issues 3 days ago from a migration… so might be helpful if you can actually explain the issues you are having

UUnsmart As pointed out above it’s an alpha product and you should not be using it for pr...

benthecarman•9/23/23, 4:18 AM

The entire database is unreachable

Unsmart•9/23/23, 4:18 AM

What error are you getting?

benthecarman•9/23/23, 4:27 AM

it just times out, database wont even show in the UI

mrwind•9/23/23, 9:49 AM

Hi I am write a package to combine kysely and zod for working with json on D1 https://github.com/windwp/kysely-zod-sqlite

GitHub

GitHub - windwp/kysely-zod-sqlite: An flexible api for Cloudflare D...

An flexible api for Cloudflare D1 and sqlite. It has an simple api of Prisma and a powerful query with Kysely. - GitHub - windwp/kysely-zod-sqlite: An flexible api for Cloudflare D1 and sqlite. It ...

Ccaptain thanks! I'm using wrangler 3.6... guess I'll stick to 3.6 because this issue sca...

Matt SilverlockOP•9/23/23, 11:46 AM

That issue only impacts local mode for that user:

wrangler 3.9.0

wrangler 3.9.0

is the latest as well.

Bbenthecarman Hey, our database keeps going down, are we able to get any status updates on whe...

Matt SilverlockOP•9/23/23, 11:47 AM

Can you provide your database ID?

MMatt Silverlock That issue only impacts local mode for that user: `wrangler 3.9.0` is the latest...

captain•9/23/23, 4:45 PM

got it, so issue is addressed in 3.9?

captain•9/23/23, 4:47 PM

@Matt also seperate question. I have a digital ocean hosted non static django sqlite project that I have been meaning to give some attention to...do you think running it with D1 is possble now on cloudflare, or what would be some of the roadblocks still and do think the roadblocks would overcome in the future?

Ccaptain @Matt also seperate question. I have a digital ocean hosted non static django sq...

Matt SilverlockOP•9/23/23, 4:59 PM

Which specific roadblocks? It's up to each user to determine how comfortable they are with a beta product. We have teams at Cloudflare using D1 for production apps but it entirely depends on your use-case and the criticality of your application.

No data will be wiped from alpha to beta/GA

Similar Threads

Similar Threads

Similar Threads