Use advanced mode, or copy-paste, or compile into /functions

I was trying out the D1Database service from Cloudflare and by doing so I created a worker which accomplishes simple tasks involving a database. I then wanted to also try out D1 on pages as that's more where I personally would use it (for full stack apps). But even though I created the database by executing:

wrangler d1 create pages-test

and filled it with data by executing:

wrangler d1 execute pages-test --file=schema.sql

with the following schema file:

sql
CREATE TABLE IF NOT EXISTS users(
  id INTEGER PRIMARY KEY,
  username TEXT NOT NULL UNIQUE,
  email TEXT NOT NULL UNIQUE,
  password TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS posts(
  id INTEGER PRIMARY KEY,
  user_id INTEGER NOT NULL,
  title TEXT NOT NULL,
  content TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS comments(
  id INTEGER PRIMARY KEY,
  post_id INTEGER NOT NULL,
  user_id INTEGER NOT NULL,
  content TEXT NOT NULL
);

which created the database in the dashboard as I expected. I discovered that after I linked the database to my Cloudflare Pages project which I built with my favorite Framework SvelteKit I wasn't able to access the database. While I tried to find the reason for this I saw that my ``env`` exposes a

__D1_BETA__DB

variable which isn't what I called my binding (it's called

DB

) although I tryed using that one but it seems like there is nothing on that Object

{"__D1_BETA__DB": {}}

. The bindng

DB

is entirely not existent on the ``env`` even when it's shown in the dashboard.

Can anyone give me any guidance on that or is that a known issue with Cloudflare Page Functions and D1 and for now we can only use D1 in workers?

What's your wrangler version?

2.19.0

Do you have a repo to look at?

Not directly but I can push my test code to github just give me a second

Page Functions doesn't have a wrangler toml file, did you set up the binding in your Pages dashboard?

They said that in the steps, yes

Yes

Correct production/preview environment?

So here is my code: I also added screenshots showing how it looks on my dashboard.

This is the output I get:

How are you uploading to pages?

Which adapter are you using?

Did you only add the binding after making a deployment?

I did firstly deploy the project to create it then added the binding but I deployed after adding the binding too and it didn't work

But now I redeployed and it seems to work

the old deployment still returns

while the new one now gives

It should be available on all future deployments as soon as you save it 🤔

Either way, it's there now 🤷‍♀️

Oh the joys of the D1 shim DX 😅

yeah, now it seems to work. The DX is not the greatest currently but I'm certain it will become way better when D1 actually is a real product and out of beta. As currently there also only seems to be the way of redeploying it to test new stuff with the db (when using a Framework [I know you can use wrangler dev on a functions directory but currently doesn't work on svelte projects ^^]).

I believe so

Having a problem streaming data from a node backend through a cloudflare function to a pages FE - the

Accept-Encoding: identity

header is being completely clobbered by CloudFlare and gets re-written to

gzip, br, deflate

-- has anyone encountered this problem?

nvm, was able to resolve by setting

Cache-Control: no-transform

Is it possible to get the current deployment # in a request, or maybe set it during build?