I would have a database per customer but creating a D1 on the fly seems awful as does applying migra

I would have a database per customer but creating a D1 on the fly seems awful as does applying migrations to all of them

NNick I would have a database per customer but creating a D1 on the fly seems awful as...

bret_pat•4/27/24, 11:16 AM

From my understanding, D1 has a very narrow scope where it's beneificial and the drawbacks that you mentioned are not minor.

NickOP•4/27/24, 11:41 AM

Hmm, my use case is I need to check metadata on every request, and there will be 10s-100s of millions of metadata rows. Need it to be fast and cheap. KV better suited I guess?

NickOP•4/27/24, 11:42 AM

Having a SQL like Interface would be ideal though

Aandrewitsover errr... you can do the same with d1, but it must only be per request, not betwee...

kian•4/27/24, 12:18 PM

It's been explained several times correctly. The object you get back from env.DB.prepare(...)env.DB.prepare(...) is just an object, it has almost nothing to do with SQLite. It is sent to your database, which makes a prepared statement with the SQL text and binds it with your parameters.

By re-using the same SQL text, you will re-use the prepared statement. (when using prepareprepare both times, of course)

NNick Hmm, my use case is I need to check metadata on every request, and there will be...

bret_pat•4/27/24, 12:36 PM

From what you've said, you haven't excluded using D1 yet.

Things like knowing how performant it needs to be (remember, it's just a single DO doing all the work), and space limitations. Also how big per row you're expecting

NNick Hmm, my use case is I need to check metadata on every request, and there will be...

bret_pat•4/27/24, 12:36 PM

Row limits are 1MB, and then of course, the 10GB limit per db

NNick Hmm, my use case is I need to check metadata on every request, and there will be...

bret_pat•4/27/24, 12:37 PM

100s of millions of rows probably means you need multiple D1 and so D1 is a lot harder to use then

kamama•4/28/24, 11:20 AM

Sharding is your best friend ever

Rubi•4/29/24, 12:27 AM

I'm doing D1 load test 1 INSERT/hit

Ccopper super nice, so d1 maxes out at -300 inserts rpm?!

Rubi•4/29/24, 5:40 AM

not really a maxes out, it can go more depends on the Locust setting

also I'm doing the benchmark from my home PC to Cloudflare Pages with D1 binding, GET / without client payload, so my connection quality take a part there

Ccopper ah ok but still nice

Rubi•4/29/24, 5:41 AM

absolutely

Ccopper wondeirng for weeks if sqlite (d1 or turso) is enough re insert perf or i just s...

Rubi•4/29/24, 5:43 AM

this is exactly what I wondering about in #kv , and I decide to stay with D1 for my startup

Rubi•4/29/24, 5:47 AM

I just can't handle the stress managing VPS's, or even, DB on VPS

Ccopper what's your guess and could you just shotgun the requests from a vps connected t...

Rubi•4/29/24, 5:48 AM

I cant promise, but this is interesting to try

Rubi•4/29/24, 5:51 AM

yes, I undserstood, I migbt be using locust on vps, but I cant promise this

Rubi•4/29/24, 5:53 AM

nope, it was just a basic .prepare insert

Rubi•4/29/24, 5:53 AM

I havent take a look the tx session feature

Kimitri•4/29/24, 7:06 AM

Hellow, I have a Node.JS Express API runing in a docker in a VPS with a mysql db. I wanna try D1 for the first time, the problem is, to migrate my current API and DB for D1 will I need to rewrite the entire api to workers ?

KKimitri Hellow, I have a Node.JS Express API runing in a docker in a VPS with a mysql db...

Rubi•4/29/24, 8:32 AM

yes, but are you still gonna deploy in vps? you gonna use the http api version

RRubi yes, but are you still gonna deploy in vps? you gonna use the http api version

Kimitri•4/29/24, 8:33 AM

I'm thinking about it, maybe not if workers work like lambda functions

RRubi yes, but are you still gonna deploy in vps? you gonna use the http api version

Kimitri•4/29/24, 8:35 AM

The problem is, I use an Orm (typeOrm) and I don't know if I can connect D1 with typeorm

KKimitri The problem is, I use an Orm (typeOrm) and I don't know if I can connect D1 with...

Rubi•4/29/24, 8:38 AM

yeah, right now, using the http api, i dont think so

KKimitri I'm thinking about it, maybe not if workers work like lambda functions

Rubi•4/29/24, 8:52 AM

worker node support is more limited than lambda function

Ccopper not really, just take something like hono which runs on workers (and pages?) and...

Kimitri•4/29/24, 8:55 AM

Yeah, I'm new with cf workers and d1, but I really interesting in it because looks so much faster than VPS in one region.

RRubi worker node support is more limited than lambda function

Kimitri•4/29/24, 8:57 AM

for checkout, files compress, and ecommerce is workers recommended?

KKimitri for checkout, files compress, and ecommerce is workers recommended?

Rubi•4/29/24, 8:59 AM

if my orientation is deploying on pages/worker, I would choose any library that support edge environment, if not, I'll figure it out outside pages/worker

I would have a database per customer but creating a D1 on the fly seems awful as does applying migra

Similar Threads

Similar Threads

Similar Threads