Yep, "how you want to consume that information" If I want to stay in the Cloudflare ecosystem, the

Yep, "how you want to consume that information"

If I want to stay in the Cloudflare ecosystem, the only option that includes append is D1, right? I could write to an external service, but would prefer to keep it all in one place.

PPaul Shriner Yep, "how you want to consume that information" If I want to stay in the Cloudf...

Matt Silverlock•11/10/23, 1:46 PM

You can write objects to R2, append to a D1 table, add to an ordered KV list… again, it will highly depend on how you want to access that information. If you just want to run SQL queries, then D1 is a great fit.

PPaul Shriner Yep, "how you want to consume that information" If I want to stay in the Cloudf...

Matt Silverlock•11/10/23, 1:46 PM

I would think less about “append” and more about accessing/query patterns.

Paul ShrinerOP•11/10/23, 1:48 PM

Right, but to write an entry to R2, or KV, I would have to pull the entire value, write to it, and then store it back in the store. With log data, which can grow very quickly, it seems that introducing that much data to the mix would hit a memory ceilng at some point.

PPaul Shriner Right, but to write an entry to R2, or KV, I would have to pull the entire value...

GuillaumeLakano•11/10/23, 1:48 PM

May be Logs Engine could help for that ? https://developers.cloudflare.com/logs/r2-log-retrieval/

Logs Engine · Cloudflare Logs docs

Logs Engine gives you the ability to store your logs in R2 and query them directly.

Paul ShrinerOP•11/10/23, 1:49 PM

Ooh, I didn't know about that.

PPaul Shriner Right, but to write an entry to R2, or KV, I would have to pull the entire value...

Matt Silverlock•11/10/23, 1:49 PM

Step back a second: how do you want to query it or access it? Many tools can read multiple R2 objects. I don’t think “append to a single object” is the problem here.

Paul ShrinerOP•11/10/23, 1:54 PM

So it is engagement data, a user would interact with a product, or a post and I want to capture that for the person that owns that user. Once that data is caputred, I will want to aggregate the values into consumable insights:

Most active
Least active
Average Order Volume
Total purchases
Lapsed buyers
Lapsed viewers
Most active by chanel
Channel volume

The kind of thing that Elastic Search is good at. I am not ready for that technology bite yet, so in the interem, counts and sums is what I am looking for.

Durable objects don't have a ceiling in terms of storage per class so... I could write to a node there and then if I ever get to the ElasticSearch plan I could do a direct import from JSON.

Paul ShrinerOP•11/10/23, 2:02 PM

I think I am considering memory because I have burned in the past by not considering it. (not at cloudflare).

Logs looks awesome and maybe exactly what I am looking for.

Paul ShrinerOP•11/10/23, 2:03 PM

This has been a helpful exchange this morning, thank you.

Paul ShrinerOP•11/10/23, 2:04 PM

It could eventually write directly to Elastic

Paul ShrinerOP•11/10/23, 2:05 PM

And by that time, CloudFlare will have already implmented Elastic for me under my workers plan.

Foreignity•11/10/23, 3:15 PM

Hello! I've checking on the doc for the best way to add a new column in a table of my database, but I don't seem to find anything. My table already contains data, and I would like to add two new columns without altering the data already in my table, is there a place where I can find how to do this?

johnswarbrick•11/10/23, 11:18 PM

Hi - is it normal for the very first SELECT from a cold started worker to take ~300ms to return a single row from a D1 table with just one row and two columns? Subsequent SELECT queries are ~25ms. This timing is specifically just the D1 query, not the total worker run time.

Rabid•11/11/23, 2:42 PM

Is there some kind of alert when we are approaching the max DB size for D1? I launched a link shortener for my https://d4planner.io site, and I'm basically prepending shortened links with 1-1- to denote which DB it hits, so I can rotate through if I hit the max size.