Cloudflare Developers•3y ago

How long? https://developers.cloudflare.com/d1/platform/limits/ - I bet you hit the max row length w

How long? https://developers.cloudflare.com/d1/platform/limits/

I bet you hit the max row length with a big blob. Would be helpful to know so we can think about adjusting over time.

MMatt Silverlock How long? https://developers.cloudflare.com/d1/platform/limits/ - I bet you hit ...

Jason Hostetter•5/19/23, 8:14 PM

267k characters

Jason Hostetter•5/19/23, 8:16 PM

oh yeah i see the max statement length is 100kb

Jason Hostetter•5/19/23, 8:17 PM

It's interesting that it let me insert that row initially from within the worker, but not via wrangler or the console

Original message was deleted

Matt SilverlockOP•5/19/23, 8:52 PM

Right now, deletes are treated as writes. Subject to change. Unless you're deleting a LOT of data, all the time, I'd be very surprised if your write+delete costs on D1 exceeded DO.
No limit on tables, but any table is non-zero bytes (to store the schema and allocate storage for an empty table). If an empty table is ~4KB or so you could have thousands of empty tables with no data, if you really desired to do so

Mozzy•5/19/23, 9:17 PM

Damn, I'm not even able to return a single column now :(

SELECT date FROM outputs

SELECT date FROM outputs

MMozzy Damn, I'm not even able to return a single column now :( `SELECT date FROM outpu...

Mozzy•5/19/23, 11:30 PM

Did the sensible thing and stopped relying on the bigger endpoints and instead created a few more specialized ones

Unsmart•5/20/23, 1:35 AM

There will be some limit which right now is on the lower end but they are working on increasing it... which I assume the new backend has increased that a good amount given what I read from the blog

Uuser6251 Thanks for the clarification! I am indeed surprised how competitive it is priced...

Isaac McFadyen•5/20/23, 2:18 AM

DO has somewhat different goals than D1 so I expect they will continue to exist.

Isaac McFadyen•5/20/23, 2:19 AM

DO = global "actor" model, there will always be one unique actor per ID/name in the world, that actor has access to key-value state
D1 = a "database", with tables/rows/columns etc.

Unsmart•5/20/23, 4:17 AM

Its friday night and this is an alpha product so I doubt anything will be done until monday when they are back at work.

Mozzy•5/20/23, 10:14 AM

Technically, Wrangler calls the new D1 a Beta

Mozzy•5/20/23, 10:14 AM

TTed Marozzi Hi, I am having trouble connecting to my D1 database from cloudflare/next-on-pag...

Hello, I’m Allie!•5/20/23, 11:34 AM

That isn’t the right type for a D1 DB stub(let me check for it). Bindings usually can’t be logged to the console. And to check, have you added the D1 binding to the Cloudflare Dashboard? Pages doesn’t respect

wrangler.toml

wrangler.toml

TTed Marozzi Yeah I know the right type, was just for quick demo but have the correct one now...

Hello, I’m Allie!•5/20/23, 11:36 AM

The type is

D1Database

D1Database

, for future reference

TTom Sherman D1 allows you to do both you can have DO-like consistency by making reads to yo...

Isaac McFadyen•5/20/23, 2:29 PM

I'm uncertain whether you can force reads to go to the primary (well replicas aren't even out yet haha) but that would be cool.

Isaac McFadyen•5/20/23, 2:30 PM

Oh cool, that will be good then.

Unsmart•5/20/23, 3:55 PM

DOs can act like KV as well if you just add cache in front of it

Unsmart•5/20/23, 4:21 PM

This is how I decide:
large blobs?: R2
key value?: DOs
SQL?: D1
KV: almost never LUL

UUnsmart This is how I decide: large blobs?: R2 key value?: DOs SQL?: D1 KV: almost never...

Hello, I’m Allie!•5/20/23, 4:35 PM

KV: Large-Scale Key-Value(100+ rps)

Hello, I’m Allie!•5/20/23, 4:35 PM

Especially if requests come from different colos

Unsmart•5/20/23, 4:36 PM

I would still use DOs for 100+ rps just with cache in front. Pretty much the only case I would use KV atm is a session store instead of creating a DO and using cache for that

How long? https://developers.cloudflare.com/d1/platform/limits/ - I bet you hit the max row length w

Similar Threads