Same thing if you hit 50GB? It takes a lot of traditional relational data to add up, and you will be

Same thing if you hit 50GB? It takes a lot of traditional relational data to add up, and you will be able to create many databases. Each DB will have its own limits.

MMatt Silverlock Same thing if you hit 50GB? It takes a lot of traditional relational data to add...

MetalGear•4/22/23, 2:37 PM

So we would just create a new database to store the orders after the first one adds up you’re saying?

MetalGear•4/22/23, 2:38 PM

Sorry if I’m not understanding this correctly as I have mostly worked with DO. Like planet scale I’m pretty sure if you reach your plan limit you just upgrade and get more storage. So with d1 I’m trying to understand what efforts will be required

MetalGear•4/22/23, 2:39 PM

I’m building a e-commerce saas. The order data will add up very quickly

MMetalGear So we would just create a new database to store the orders after the first one a...

Matt SilverlockOP•4/22/23, 2:39 PM

I think it’s worth stepping back a second. I understand that hitting a storage limit sounds concerning, but… if you have 500 bytes per row, and 10M order rows: that’s just 5GB.

MMatt Silverlock I think it’s worth stepping back a second. I understand that hitting a storage l...

MetalGear•4/22/23, 2:40 PM

So let’s say I reach that In a year with 100 tenants

Original message was deleted

Erisa•4/22/23, 2:41 PM

From https://developers.cloudflare.com/d1/

While in the Alpha period, there is a possibility of breaking changes. The Alpha is meant for testing purposes and using it for Production traffic is not recommended.

MMetalGear So let’s say I reach that In a year with 100 tenants

Matt SilverlockOP•4/22/23, 2:41 PM

I’m just going to restate here: D1 is in alpha. A lot will change. I’d love to share more, but much of this is subject to change. Storage limits included.

MMatt Silverlock I’m just going to restate here: D1 is in alpha. A lot will change. I’d love to s...

MetalGear•4/22/23, 2:42 PM

Yeah my concern is not that it’s in alpha and only 100mb but rather if we can’t expand storage what do we do when we reach limits. Sorry if I’m going in circles I’m new to data storage and just trying to learn. I love CF and a fanboy of all services. Trying to do everything within the ecosystem

MMetalGear Yeah my concern is not that it’s in alpha and only 100mb but rather if we can’t ...

Matt SilverlockOP•4/22/23, 2:44 PM

As with any DB - you end up potentially splitting/sharding it out - by date or user ID or order ID. Even if you can scale AWS RDS up to 1TB, you often don’t want to do that as it ultimately has performance and risk trade-offs. Same with PlanetScale.

MMatt Silverlock As with any DB - you end up potentially splitting/sharding it out - by date or u...

MetalGear•4/22/23, 2:45 PM

What about with something like planet scale?

MMetalGear Yeah my concern is not that it’s in alpha and only 100mb but rather if we can’t ...

Matt SilverlockOP•4/22/23, 2:45 PM

I’m just going to reiterate the need to hold tight: I haven’t said anything concrete about per-DB limits, and we’re not quite ready to share those.

MMatt Silverlock I’m just going to reiterate the need to hold tight: I haven’t said anything conc...

MetalGear•4/22/23, 2:46 PM

Okay. Tysm Very excited.

kw•4/23/23, 3:27 PM

my project is also in alpha, so I'll go beta once D1 goes into beta lol

MMatt Silverlock (Remembering that D1 is an alpha: a true alpha, not a marketing alpha!) 😉

aarhus•4/23/23, 10:39 PM

Hi @elithrar, can you give us a steer around how we can expect to handle breaking changes? Is there going to be a compatibility flag/date or will it just stop working?

Gguoyk93 Hi, I've been thinking, may be database with native HTTP api matches cloudflare ...

Max (@rozenmd)•4/24/23, 9:10 AM

have you tried KV? https://www.cloudflare.com/products/workers-kv/

Cloudflare

Cloudflare Workers KV | Serverless Computing | Cloudflare

Cloudflare Workers KV is low-latency key-value storage at the edge. Leverage serverless computing and build serverless architecture with key-value storage.

Unsmart•4/24/23, 9:21 AM

Or #durable-objects

Dahoom•4/24/23, 9:44 AM

Hello, I'm confused as to how im supposed to upload sql files to d1.
When using wrangler d1 excecute <db> --file=file.sql
i get this error:

kian•4/24/23, 9:45 AM

You've typo'd

execute

execute

Dahoom•4/24/23, 9:46 AM

okay this never happened

Dahoom•4/24/23, 9:46 AM

thank you

Max (@rozenmd)•4/24/23, 9:57 AM

if you want to try something super bleeding edge, you can also paste sql files into the console:

Dahoom•4/24/23, 10:33 AM

query is too long for that

TTumas2 I have an feature request/idea that I'm unsure how useful it is (or if it's even...

Max (@rozenmd)•4/24/23, 10:48 AM

yep

DDahoom query is too long for that 😄

Max (@rozenmd)•4/24/23, 10:48 AM

I've pasted a 500KB query in there, 2200 rows inserted no worries

Max (@rozenmd)•4/24/23, 10:48 AM

might lag tho

Dahoom•4/24/23, 10:48 AM

140k here

MMax (@rozenmd)I've pasted a 500KB query in there, 2200 rows inserted no worries

Dahoom•4/24/23, 6:00 PM

good news, the console seems to be better than wrangler. Inserted 140k rows in about 15s no problem.

Thank you for the suggestion, props to whoever worked on this feature its amazing

DDahoom good news, the console seems to be better than wrangler. Inserted 140k rows in a...

Max (@rozenmd)•4/24/23, 6:06 PM

thanks

justaname•4/24/23, 11:30 PM

Is there a timeline of when things are announced like pricing announced with beta. not like eta but what features will be shipped

Vvaltyr Otherwise I'd be super interested to hear how you guys are handling staging/prev...

Max (@rozenmd)•4/25/23, 8:18 AM

it's super gross but

wrangler d1 create <db-preview>

wrangler d1 create <db-preview>

wrangler d1 delete <db-preview>

wrangler d1 delete <db-preview>

might do the trick?

Max (@rozenmd)•4/25/23, 8:19 AM

(that's how i handle previews for Workers personally)

Max (@rozenmd)•4/25/23, 10:13 AM

ah yep. forgot about that

Max (@rozenmd)•4/25/23, 10:14 AM

probably easier to do in json mode

Jjustaname Is there a timeline of when things are announced like pricing announced with bet...

Epailes•4/25/23, 11:39 AM

This is the closest comment so far: d1-database
So soontm

rather than soonsoontm

DDr. Koti Reddy . Saripalli Hello There, Is D1 Replication inplace already ?

Max (@rozenmd)•4/26/23, 4:58 AM

nope, not yet

DDr. Koti Reddy . Saripalli https://www.pinnacleblooms.rg - #1 Autism Therapy Centres Network provided 3Mill...

Epailes•4/26/23, 10:09 AM

The best you'll get is soontm

, although bear in mind it's still alpha, if we're lucky possibly near the end of the year but personally I wouldn't put a large bet on that
For comparison:
R2 entered open beta in May 22, went GA Sept 22
Pages functions entered open beta in Nov 21, went GA in Nov 22
DO entered open beta in Mar 21, went GA Nov 21

Same thing if you hit 50GB? It takes a lot of traditional relational data to add up, and you will be

Similar Threads

Similar Threads

Similar Threads