const arr = [1, 2, 3] … stmt.bind(…arr).run()

const arr = [1, 2, 3]
…
stmt.bind(…arr).run()

Mmuslax const arr = [1, 2, 3] … stmt.bind(…arr).run()

Saifulapm•4/18/23, 10:19 PM

So If I spreading, with one placeholder will work ? I mean

const stmt = context.env.DTB.prepare('DELETE FROM Discounts WHERE id IN ?1')
const response = await stmt.bind(…arr).run()

const stmt = context.env.DTB.prepare('DELETE FROM Discounts WHERE id IN ?1')
const response = await stmt.bind(…arr).run()

This will work ? Anyway, I will test it ..

Saifulapm•4/18/23, 10:22 PM

Any appropriate date when D1 will be stable ? Can I use D1 for high traffic app now ??

Walshy•4/18/23, 10:34 PM

No and it should not be used for production

Aagarcia_me I don't have much d1-specific experience, but here's a typical pattern for passi...

Saifulapm•4/19/23, 1:18 PM

This is not working

WWalshy No and it should not be used for production

Saifulapm•4/19/23, 1:18 PM

Any appropriate date when it will stable ?

Walshy•4/19/23, 1:19 PM

Walshy•4/19/23, 1:19 PM

No date outside of that

Max (@rozenmd)•4/19/23, 4:02 PM

We don't give expectations or timelines for releases, but we'll announce it extremely loudly across the Internet when it's ready.

Max (@rozenmd)•4/20/23, 8:36 AM

tbh I have a bunch of durable object code that I'm going to refactor to just use D1 once we go GA

Max (@rozenmd)•4/20/23, 8:52 AM

in other news, the D1 dashboard now lets you set fields to

null

null

AAndreas Dahlström Noob question: Can I access D1 directly from the browser or do I always have to ...

Max (@rozenmd)•4/20/23, 1:01 PM

Depends what you mean by access D1 from the browser - like edit your data?

Max (@rozenmd)•4/20/23, 1:02 PM

Oh, no you can't do that - your frontend has to talk to a Worker

AAndreas Dahlström ok. Thanks. Unfortunate. Was hoping I would finally find a SQL DB with HTTP inte...

Max (@rozenmd)•4/20/23, 1:06 PM

but like, your worker could just be a dumb pass-through for all queries from the frontend if you wanted to. i'm using that atm to build a REPL:

Max (@rozenmd)•4/20/23, 1:06 PM

JWT between your Worker and the frontend

AAndreas Dahlström or do D1 have any features I can use to simplify the process?

Max (@rozenmd)•4/20/23, 1:14 PM

At the moment (it's still in alpha after all) - it's just a single database on the edge

MMax (@rozenmd)At the moment (it's still in alpha after all) - it's just a single database on t...

MetalGear•4/21/23, 2:28 PM

When is d1 going GA

MMetalGear When is d1 going GA

Max (@rozenmd)•4/21/23, 2:29 PM

when it's ready

MMax (@rozenmd)when it's ready

MetalGear•4/21/23, 2:29 PM

Lol any plans for it being ready soon?

MMetalGear Lol any plans for it being ready soon?

Max (@rozenmd)•4/21/23, 2:30 PM

we'll announce it when it's ready

MetalGear•4/21/23, 2:30 PM

I’m building a large project and getting to database design. I really want to use it but can’t wait too long

MetalGear•4/21/23, 2:30 PM

So I just wanted an idea if it’s going to be 1-3 months or 3-9

Max (@rozenmd)•4/21/23, 2:31 PM

it's in alpha atm, and still needs a beta before GA

MetalGear•4/21/23, 2:32 PM

Would it be a terrible choice to go with it in alpha if I’m growing really slowly?

MetalGear•4/21/23, 2:32 PM

Or is alpha like not reliable

MetalGear•4/21/23, 2:32 PM

Also do you guys think d1 will get prisma support ?

MMetalGear Also do you guys think d1 will get prisma support ?

JustinNoel•4/21/23, 2:43 PM

if it's an important project, which "large project" sounds like, then no it's not a good choice.

In the meantime, I suggest you use another database service. For example I'm very excited about D1, but I'm watching my project with planetscale. I'll migrate as soon as I can.

Cloudflare will never give a release date for any product or fix or service. The canned response is always soontm

JJustinNoel if it's an important project, which "large project" sounds like, then no it's no...

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

Okay. Thank you. Would a specific database be similar enough where transition later can be much easier? Would planet scale be the next best option?

MMetalGear Okay. Thank you. Would a specific database be similar enough where transition la...

JustinNoel•4/21/23, 8:54 PM

I didn't put a lot of effort into research. I just knew that planetscale would meet my needs and had a serverless driver.

you might also want to check out:

• Turso https://chiselstrike.com
• xata.io

Turso | SQLite Developer Experience in an Edge Database

Eliminate application bottlenecks by bringing the performance and data portability of open source, lightweight SQL close to your users with low overhead

Aagarcia_me I don't have much d1-specific experience, but here's a typical pattern for passi...

Saifulapm•4/21/23, 11:17 PM

This is working good

Uuser6251 We are currently evaluating DO, which seem to check all the boxes for us, when w...

Max (@rozenmd)•4/22/23, 1:20 PM

@elithrar ^

Uuser6251 We are currently evaluating DO, which seem to check all the boxes for us, when w...

Matt Silverlock•4/22/23, 2:19 PM

We’ll be announcing (just announcing: not enabling) pricing in a few weeks, but it’s very much an “it depends” case. DO is key-value based, whereas D1 is a queryable database. If you have a lot of small reads, then D1 is likely to be much cheaper. DO charges on 4KB boundaries. I’d need to know a LOT more about your query patterns here.

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

What are the limits of d1

const arr = [1, 2, 3] … stmt.bind(…arr).run()

Similar Threads

Similar Threads

Similar Threads