Can i use d1 from cloudflare pages? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

xeronik

Xxeronik Can i use d1 from cloudflare pages?

Cyb3r-Jak3

C

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

Yeah

Cyb3r-Jak3

C

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

You access it via envenv same as workers

Cyb3r-Jak3

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

xeronik

X

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

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

kian

K

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

Same as any other binding - pass it as an arg to pages devpages dev https://developers.cloudflare.com/workers/wrangler/commands/#dev-1

connor

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

Max (@rozenmd)

M

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

Thanks for reporting this - should be able to grab the fix in wrangler@betawrangler@beta or the next wrangler release

Saifulapm

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

Why this query not working on D1? Any idea ?

Saifulapm

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

This works

Saifulapm

S

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

Also any approximate date when D1 will be stable ??

macvim

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

James

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

Saifulapm

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

muslax

M

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

You can do by spreading var insinde bind.

muslax

M

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

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

muslax

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

Saifulapm

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

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

Saifulapm

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

Walshy

W

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

No and it should not be used for production

agarcia_me

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

Saifulapm

S

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

This is not working

Walshy

WWalshy No and it should not be used for production

Saifulapm

S

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

Any appropriate date when it will stable ?

Walshy

W

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

soontm

Walshy

W

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

No date outside of that

Max (@rozenmd)

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.

Max (@rozenmd)

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

Max (@rozenmd)

M

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

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

null

null

:

Andreas Dahlström

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

Max (@rozenmd)

M

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

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

Max (@rozenmd)

M

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

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

Andreas Dahlström

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

Max (@rozenmd)

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:

Max (@rozenmd)

M

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

JWT between your Worker and the frontend