It looks like array not working. If I do like this: ``` const stmt = context.env.DTB.prepare('DELE

It looks like array not working. If I do like this:

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

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

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

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

This works

SaifulapmOP•4/18/23, 4:12 AM

Also any approximate date when D1 will be stable ??

Mmacvim Any clever way to seamlessly change the DB binding when running `npm run dev` an...

James•4/18/23, 6:06 PM

Hello, as an alternative, have you considered using the following in two terminal windows to watch changes locally? It will of course mean that viewing changes will be a little slower than using the default dev server, but it does mean that you should be able to use your bindings.

npx @cloudflare/next-on-pages --watch
npx wrangler pages dev .vercel/output/static --compatibility-flag=nodejs_compat

npx @cloudflare/next-on-pages --watch
npx wrangler pages dev .vercel/output/static --compatibility-flag=nodejs_compat

SSaifulapm It looks like array not working. If I do like this: ``` const stmt = context.e...

muslax•4/18/23, 6:07 PM

You can do by spreading var insinde bind.

muslax•4/18/23, 6:08 PM

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

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

SaifulapmOP•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 ..

SaifulapmOP•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...

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

This is not working

WWalshy No and it should not be used for production

SaifulapmOP•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

It looks like array not working. If I do like this: ``` const stmt = context.env.DTB.prepare('DELE

Similar Threads