[D1] Deploying SveltKit on Cloudflare Pages using a D1 is unclear

[ocolot]

Which Cloudflare product does this pertain to?

D1

Existing documentation URL(s)

• https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/
• https://developers.cloudflare.com/pages/functions/bindings/#d1-databases

What changes are you suggesting?

Provide a working example. The deployment works fine, but I can't get the local database binding to be accessible on platform.env.DB. Especially, the --d1 NORTHWIND_DB=xxxx-xxxx-xxxx-xxxx-xxxx that does not appear in the command line doc if I am not mistaken.

How the D1 database is deployed locally should be clarified, the differences between wrangler and wrangler pages in local, what DB is used (confusing flags with opposite defaults, sometimes --remote, sometimes --local).

Additional information

No response

[Maddy-Cloudflare]

Will look into this, thanks!

[johnrcui]

Hi. I'm currently using hooks and a custom Vite plugin to shim Cloudflare KV, D1, and R2 on SvelteKit projects for local development. It lets me simulate the production Cloudflare environment without having to go through extra steps to perform a production build and bind the services locally via wrangler.

I've created a demo project here which anyone can use. I hope someone else might find it useful as it has made the development experience with my teams so much easier.

This solution utilizes the same submodules Miniflare uses directly and the local counterparts of each service is accessible to the developer. For example, the D1 (SQlite3) local counterpart is an actual SQLite3 database you can open with any DBMS. The same goes for KV and R2 in which they're just subdirectories of the project that the developer can access and inspect directly.

[Oxyjun]

Hey @vy-ton could you take a look at this issue?

Action points as I've understood:

1. Need someone to create a properly working example for SveltKit/D1/Pages (could you assign?)
2. Clarify any differences between using D1 via --local vs --remote. I think @lambrospetrou mentioned this before, i.e. not all functionality is identical for these two options. For this, we should either fix (if it's fixable), or document. I don't know the full extent of the differences though. Could you help?
3. Clarify the default behaviour when neither --local / --remote flag is specified. I can see that by default D1 uses local, so I'll add that via a separate PR.

[Oxyjun]

This issue seems to have gone stale - closing for now.