You access it via `env` same as workers

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

X

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

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

K

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

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

pages dev

pages dev

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

M

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

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

wrangler@beta

wrangler@beta

wrangler@beta

wrangler@beta or the next wrangler release

S

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

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 ?

S

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

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

S

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

J

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

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

M

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

You can do by spreading var insinde bind.

M

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

S

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

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

S

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

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

W

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

S

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

This is not working

WWalshy No and it should not be used for production

S

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

Any appropriate date when it will stable ?

W

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

W

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

No date outside of that

M

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.

M

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

M

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

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

null

null

null

null:

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

M

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

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

M

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

M

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:

M

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?

M

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

You access it via `env` same as workers

Similar Threads

Similar Threads

Similar Threads