<https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database> Is this Responses d

https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database

Is this Responses documentation wrong?
I'd expect it to return an array of rows

AAshish Rawat How this will work for 1000s of users if the database limit will be in GB (assum...

Matt Silverlock•9/28/23, 2:20 PM

Per database

Adi•9/28/23, 2:22 PM

Seriously a huge congratulations to the D1 team for hitting beta status

I can't wait to see everything you do in the future

MMozzy <https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database> ...

Max (@rozenmd)•9/28/23, 2:40 PM

My mistake, will fix

Rryoppippi hi is d1 production ready?

Max (@rozenmd)•9/28/23, 3:10 PM

D1 is in public beta. While we expect breaking changes and issues to be minimal, they may still occur. We generally do not recommend running large production workloads on beta products.

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

MMax (@rozenmd)My mistake, will fix

Max (@rozenmd)•9/28/23, 3:54 PM

fixed

PizzaConsole•9/28/23, 4:28 PM

I see that D1 does not support Transactions or save points. However when using a transaction and running locally it does not throw an error. Is that a change that needs to happen in Miniflare?

LLogan Grasby Exciting updates! If you have a D1 database already is there anything we need to...

Max (@rozenmd)•9/28/23, 4:31 PM

nope, as long as your db says "beta" when you run wrangler d1 info, you're all set

Jacob Wright•9/28/23, 5:26 PM

Can I update my alpha database to become beta, or do I need to create a new database? And if the latter, will I need to do the same for general release?

JJacob Wright Can I update my alpha database to become beta, or do I need to create a new data...

Isaac McFadyen•9/28/23, 5:32 PM

You'll need to dump the database to a SQLite file and then re-import to a new (beta) database.

IIsaac McFadyen You'll need to dump the database to a SQLite file and then re-import to a new (b...

Jacob Wright•9/28/23, 5:34 PM

Will we need to do the same at general release?

JJacob Wright Will we need to do the same at general release?

Isaac McFadyen•9/28/23, 5:37 PM

I'm unsure, and I doubt anyone will be able to tell you since nothing is concrete until GA.

abdellah•9/28/23, 5:51 PM

Cool
Is time travel built on ZFS?

IIsaac McFadyen I'm unsure, and I doubt anyone will be able to tell you since nothing is concret...

Jacob Wright•9/28/23, 6:14 PM

Good point.

JJacob Wright Will we need to do the same at general release?

Matt Silverlock•9/28/23, 7:13 PM

Not if you are on the beta backend.

Aabdellah Cool Is time travel built on ZFS?

Matt Silverlock•9/28/23, 7:14 PM

No. ZFS snapshots don’t work like that (and way too low level). D1 has its own storage subsystem that allows this to work.

MMatt Silverlock At "100k databases" there are other things that make you want to use WfP in term...

nclevenger•9/28/23, 7:27 PM

Is there a technical limit to the number of bindings that a worker can have? I'm assuming at some point there is significant performance overhead to add all of the bindings to the

env

env

object, but what order of magnitude are we talking about here?

Nnclevenger Is there a technical limit to the number of bindings that a worker can have? I'...

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

IIRC it comes down to the metadata limit, which iirc is 1 MB

Hello, I’m Allie!•9/28/23, 7:29 PM

So however many bindings you can cram into that

nclevenger•9/28/23, 7:29 PM

ahh - makes sense

nclevenger•9/28/23, 7:29 PM

I was reading the blog post today and I hadn't realized until then there was a

patch

patch

method to incrementally add a binding ... that was really interesting to see ...

Original message was deleted

Hello, I’m Allie!•9/28/23, 7:30 PM

Is that the imposed limit or technical limit?

nclevenger•9/28/23, 7:31 PM

yah - I had been using WfP as a bridge for dynamic user-specific D1 ... but one use case, I was creating the same script over and over again and I thought it would be much simpler if there was a dynamic dispatch for resources like D1

Chaika•9/28/23, 7:31 PM

The env variable limit is mentioned on https://developers.cloudflare.com/workers/platform/limits/#environment-variables, 128 for paid, 64 for free. no mention of bindings limits though, who's going to be the one to find out?

nclevenger•9/28/23, 7:32 PM

because the other issue I was running into, is as the WfP proxy was evolving, then I had to redeploy every single one of the WfP scripts, every single time it was updated

nclevenger•9/28/23, 7:32 PM

and that was turning into a technical nightmare

Nnclevenger Is there a technical limit to the number of bindings that a worker can have? I'...

Matt Silverlock•9/28/23, 7:52 PM

Each binding is (rounding up a lot) about 100-150 bytes. You can have 1MB. Includes all bindings, vars, secrets. So ballpark 5,000 (rounding down significantly).

MMatt Silverlock Each binding is (rounding up a lot) about 100-150 bytes. You can have 1MB. Inclu...

nclevenger•9/28/23, 8:27 PM

Is there added cold-start latency with a very large binding like there is with a large worker?

Nnclevenger Is there added cold-start latency with a very large binding like there is with a...

Hello, I’m Allie!•9/28/23, 8:38 PM

IIRC metadata for Workers is stored in Quicksilver, just like <1 MB Workers, so it should be fast no matter how many bindings you add

Hello, I’m Allie!•9/28/23, 8:38 PM

It’s also why Workers can be slower above 1 MB

ajgeiss0702•9/28/23, 9:09 PM

Once d1 has read replication, any idea on how consistent it would be? I’m currently planning a feature that would require semi-strong consistency

ajgeiss0702•9/28/23, 9:12 PM

(Please ping me if you reply)

Ddigeratidave what is the best practice for adding a column to an existing D1? Is the Alter co...

digeratidave•9/28/23, 10:07 PM

found I can run the alter command right from the D1 dashboard.

DDanTheGoodman I'm getting this error when using hono on a durable object that has d1 bound. No...

joel•9/28/23, 11:20 PM

Have you been able to fix it? I have the same error but im not using D1, just trying to get websockets working

Jjoel Have you been able to fix it? I have the same error but im not using D1, just tr...

DanTheGoodman•9/28/23, 11:20 PM

Haven’t touched it since

joel•9/28/23, 11:21 PM

okay :/

Adi•9/29/23, 1:19 AM

One of the biggest impediments to double-digit-gigabyte databases is performance

This line in the blog really got me thinking. I've always been using D1 with the assumption that one day this could be the primary database for the various products I'm building on Cloudflare. Reading the latest blog I somehow got the feeling that the aim is to scale D1 horizontally (aka number of databases as opposed to size of each individual database).

(Question for Matt probably) How do you envision D1 as a product? Are you aiming to build it to a point where it can be the primary database for an org? Or is D1 positioned to be on the smaller side (say up to 50GB) and powering smaller microservices in a larger architecture?

Adi•9/29/23, 1:23 AM

I suppose one way to build a primary database on D1 (assuming it scales on number of DBs as opposed to size) is some kind of sharding logic that splits the data between multiple instances. But my guess is that this kind of logic would have to come from Cloudflare, since it would be non-trivial for us to build it ourselves.

bret_pat•9/29/23, 2:49 AM

The docs say that D1 is currently in alpha

https://developers.cloudflare.com/workers/learning/storage-options/#d1

Storage options guide · Cloudflare Workers docs

The Cloudflare Workers platform provides multiple storage options. This guide will inform you on which storage option is appropriate based on your …

bret_pat•9/29/23, 3:16 AM

What RDBMS does R1 use underneath? Does R1 use clustered indexes or does it use something similar to Postgres?

Wondering about UUIDs as PK for R1

Bbret_pat The docs say that D1 is currently in alpha https://developers.cloudflare.com/wo...

Max (@rozenmd)•9/29/23, 7:01 AM

fixing that

Bbret_pat What RDBMS does R1 use underneath? Does R1 use clustered indexes or does it use...

Max (@rozenmd)•9/29/23, 7:07 AM

assuming you mean D1, it's sqlite

DDanTheGoodman I'm getting this error when using hono on a durable object that has d1 bound. No...

Matt Silverlock•9/29/23, 8:27 AM

Inside a DO? Is Hono looking for the Env in the right place? I would file a bug against Hono.

Bbret_pat The docs say that D1 is currently in alpha https://developers.cloudflare.com/wo...

Matt Silverlock•9/29/23, 8:28 AM

It’s in beta. Just missed that one page in the update.

joel•9/29/23, 8:29 AM

I somehow fixed it but have no clue how.

Steps:

Install Hono-do and add the bindings
Copy paste the example
For some reason it worked
I renamed the example class and added my code to it
I removed Hono-do again

I do not what is different than before now since it looks 1:1 the same, maybe that helps someone

joel•9/29/23, 8:29 AM

https://github.com/sor4chi/hono-do

GitHub

GitHub - sor4chi/hono-do: A wrapper of Cloudflare Workers's Durable...

A wrapper of Cloudflare Workers's Durable Object for Hono. - GitHub - sor4chi/hono-do: A wrapper of Cloudflare Workers's Durable Object for Hono.

AAdi > One of the biggest impediments to double-digit-gigabyte databases is performan...

Matt Silverlock•9/29/23, 8:56 AM

Double digits makes sense. 100GB per database is just a very different thing. But that’s also the point: orgs are used to large, monolithic databases, which makes changes and management risky. Many of us know what it’s like to have a database related incident caused by another team’s work or load.

A dominant reason everyone has big 100GB+ databases is because the cost of managing multiple database instances - the cost in operations AND dollars - is very high. You still pay by the hour. They take time to spin up. Managing backups is harder.

We think it’s going to be better for a lot of folks building new infrastructure to have 10+ 10GB D1 databases vs 1x 100GB database. And if you have legacy infrastructure, use Hyperdrive.

<https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database> Is this Responses d

Similar Threads