Question on db.batch(). Can you run prepared statements on two different tables? If so, can you ge

Question on db.batch(). Can you run prepared statements on two different tables? If so, can you get a result back that has rows from each table? Ideally, I'm looking at inserting rows in two different tables where one table has an Foreign Key relationship with the other. Is this possible with db.batch()?

Jason Hostetter•4/14/23, 11:35 PM

I know there isn’t much pricing info yet, but wonder if anyone knows or has predictions about whether read replicas will cost extra as they do with planet scale? Or will it be included and automatic?

Hhanpolo Question on db.batch(). Can you run prepared statements on two different tables...

Matt Silverlock•4/15/23, 12:58 AM

Yes: https://developers.cloudflare.com/d1/platform/client-api/#dbbatch

returns all results, in order, as an array

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

ZZiga Zajc and save on storage expenses.

Hello, I’m Allie!•4/15/23, 5:13 PM

R2 is too cheap, gotta fill it with something...

ZZiga Zajc and save on storage expenses.

Matt Silverlock•4/15/23, 5:32 PM

We don’t charge you right now for backups, but it’s very likely we reduce the default retention period.

Note that our docs commit to 24 hours (as a heads up).

xeronik•4/16/23, 2:55 PM

Can i use d1 from cloudflare pages?

Xxeronik Can i use d1 from cloudflare pages?

Cyb3r-Jak3•4/16/23, 2:56 PM

Yeah

Cyb3r-Jak3•4/16/23, 2:57 PM

You access it via

env

env

same as workers

CCyb3r-Jak3 You access it via `env` same as workers

xeronik•4/16/23, 3:38 PM

Thats nice, but how would i access bindings at dev time?

kian•4/16/23, 3:47 PM

Same as any other binding - pass it as an arg to

pages dev

pages dev

https://developers.cloudflare.com/workers/wrangler/commands/#dev-1

Cconnor https://github.com/cloudflare/workers-sdk/issues/3046 Unsure if this is a known...

Max (@rozenmd)•4/17/23, 5:53 PM

Thanks for reporting this - should be able to grab the fix in

wrangler@beta

wrangler@beta

or the next wrangler release

Saifulapm•4/18/23, 4:10 AM

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

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

Why this query not working on D1? Any idea ?

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

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()

This works

Saifulapm•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()

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

Question on db.batch(). Can you run prepared statements on two different tables? If so, can you ge

Similar Threads

Similar Threads

Similar Threads