Cloudflare Developers•3y ago

You need to built it and use the built folder at .svelte-kit/cloudflare with wrangler pages dev

DahoomOP•8/20/23, 10:20 PM

Make sure you set your d1 bindings in either the wrangler.toml file or within the CLI command

DDahoom You need to built it and use the built folder at .svelte-kit/cloudflare with wra...

jahir9991•8/20/23, 10:20 PM

Is it working for remote d1 ?

Matt Silverlock•8/20/23, 11:25 PM

https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/

Query D1 from SvelteKit · Cloudflare D1 docs

SvelteKit is a full-stack framework that combines the Svelte front-end framework with Vite for server-side capabilities and rendering. You can query …

Matt Silverlock•8/20/23, 11:26 PM

https://github.com/elithrar/svelte-demo-d1

GitHub

GitHub - elithrar/svelte-demo-d1: Cloudflare Pages + SvelteKit + Cl...

Cloudflare Pages + SvelteKit + Cloudflare D1 - https://developers.cloudflare.com/pages/framework-guides/deploy-a-svelte-site/#deploy-with-cloudflare-pages

GitHub - elithrar/svelte-demo-d1: Cloudf...

jahir9991•8/20/23, 11:45 PM

I have seen this repo do we have any way to access the remote d1 ?

jahir9991•8/20/23, 11:49 PM

I have completed 2 task 1: i can point local sqlite with vite dev command by conditionally import. 2: i can access local db with wrangler pages dev .sveltekit/cloudflare command

jahir9991•8/20/23, 11:49 PM

But i need to access the remote db in locally , no luck yet

Jjahir9991 But i need to access the remote db in locally , no luck yet

Cyb3r-Jak3•8/20/23, 11:51 PM

Pages doesn't like you use remote dev. You always use local

Jjahir9991 Its not working either do i need to run the sveltekit with wrangler pages dev

chientrm.com•8/21/23, 1:32 AM

What error shows up?

chientrm.com•8/21/23, 1:33 AM

You need to start a proxy worker and connect it in your

hooks.server.ts

hooks.server.ts

TTraffy is it possible to access(CRUD) d1 without worker? Like from a nodejs backend run...

Max (@rozenmd)•8/21/23, 12:29 PM

you would need a worker in front of it to access the db, such as https://github.com/elithrar/http-api-d1-example

mrwind•8/21/23, 12:32 PM

hey how do i download a backup file .sqlite 3 on the beta D1 . wrangler d1 backupwrangler d1 backup list don't show id like on alpha D1.

NikkitaFTW•8/21/23, 12:33 PM

I am trying to create different databases for users and creating them on demand, is there no way to access d1 without it being binded in the wrangler.toml?

When creating the DB i get back the name and ID

NNikkitaFTW I am trying to create different databases for users and creating them on demand,...

Cyb3r-Jak3•8/21/23, 12:46 PM

You can use the API to add more bindings to the worker however the next time you use wrangler deploy it will overwrite them

NikkitaFTW•8/21/23, 1:00 PM

Are there docs for this API?

NNikkitaFTW I am trying to create different databases for users and creating them on demand,...

Max (@rozenmd)•8/21/23, 1:00 PM

@Matt did we release a way to do this yet?

MMax (@rozenmd)@Matt did we release a way to do this yet?

Matt Silverlock•8/21/23, 1:02 PM

No, something we are looking at later this year. D1 is still in alpha and we are focused on stability & larger DBs first.

NikkitaFTW•8/21/23, 1:12 PM

Okay cool! Thank you!

NNikkitaFTW Are there docs for this API?

ag_dubs•8/21/23, 1:14 PM

there are docs for adding a binding to a worker on the fly

ag_dubs•8/21/23, 1:16 PM

(hrm, the bindings api is deprecated, tho i suspect there's another way)

Aag_dubs there are docs for adding a binding to a worker on the fly

Matt Silverlock•8/21/23, 1:52 PM

There’s ongoing work to make it easier to update env vars & bindings without a redeploy (although keeping in sync with your wrangler config will still be challenging/a risk)

Ssourabh.sashank https://dash.cloudflare.com/862998def1cd610fdb86b8e5c1d6ed4d/workers/d1/database...

Matt Silverlock•8/21/23, 1:53 PM

Can you provide any more detail? What happens if you try to run

wrangler d1 execute --command="PRAGMA table_list"

wrangler d1 execute --command="PRAGMA table_list"

against it? Please provide errors.

MMatt Silverlock There’s ongoing work to make it easier to update env vars & bindings without a r...

Matt Silverlock•8/21/23, 1:54 PM

cc @tanushree who is driving this

MMatt Silverlock There’s ongoing work to make it easier to update env vars & bindings without a r...

ag_dubs•8/21/23, 1:55 PM

assuming there was an endpoint that could "bundle" my worker (e.g. send it a zip and it bundles the way wrangler does) we could completely avoid the wrangler/api dance by using the api exclusively. the build step is the primary issue there (iirc this is maybe addressed by the workers/pages unification project?)

Aag_dubs assuming there was an endpoint that could "bundle" my worker (e.g. send it a zip...

Matt Silverlock•8/21/23, 2:00 PM

Technically this works, but appears to be underdocumented. Chasing internally. The current PUT module / PUT content endpoints should support this. I would test but I’m halfway through a 15 hour flight

MMatt Silverlock Technically this works, but appears to be underdocumented. Chasing internally. T...

Matt Silverlock•8/21/23, 2:01 PM

Then you can PATCH script settings - using your own config / source control as your source of truth

MMatt Silverlock Technically this works, but appears to be underdocumented. Chasing internally. T...

ag_dubs•8/21/23, 2:04 PM

safe flight and if/when you get a chance to follow up i would be very interested to learn more, but no rush

MMatt Silverlock Then you can PATCH script settings - using your own config / source control as y...

ag_dubs•8/21/23, 2:04 PM

nods

ag_dubs•8/21/23, 2:04 PM

i'll poke around. thank you!

Aag_dubs safe flight and if/when you get a chance to follow up i would be very interested...

Matt Silverlock•8/21/23, 2:20 PM

Set the content type to

multipart/form-data

multipart/form-data

applies to both the Upload Module & script content endpoints. I know other folks are using this in prod but wasn’t sure if we had formally published it.

ag_dubs•8/21/23, 2:22 PM

if my module is multiple js files will this handle that?

ag_dubs•8/21/23, 2:22 PM

(this is what i mean by bundling, i realize that that was ambuguous in this context, apologies)

ag_dubs•8/21/23, 2:23 PM

i know this says multiple modules can be present but it's not clear to me if that means js modules that are conceptually a single worker module or multiple worker modules

Aag_dubs if my module is multiple js files will this handle that?

Matt Silverlock•8/21/23, 2:23 PM

Yes. All of this is (only) single Worker.

ag_dubs•8/21/23, 2:24 PM

oh ok awesome, well that rules

Matt Silverlock•8/21/23, 2:30 PM

Gotta fix that content-type drop down / properly default to module worker syntax in those docs

kian•8/21/23, 2:33 PM

Wrangler typically bundles it all into a single file w/ esbuild but added

--no-bundle

--no-bundle

which is basically what you're doing with the API, and allows 'proper' dynamic imports

sultan.xh•8/21/23, 3:15 PM

I am wondering any json function that can be used in where clause to get matched data?

sultan.xh•8/21/23, 3:18 PM

For example, I want to get all the rows where status is 1.

id | data
1 | { "status": 1 }
2 | { "status": 0 }
3 | { "status": 1 }

It will return 1 and 3

sultan.xh•8/21/23, 3:35 PM

SELECT * FROM content WHERE json_extract(data, '$.status') = 1

SELECT * FROM content WHERE json_extract(data, '$.status') = 1

sultan.xh•8/21/23, 3:37 PM

Love these JSON functions. Thanks for the great work!

sultan.xh•8/21/23, 4:40 PM

How to order data like DESC?

RRenato On this beta version, how can I download a copy of the database?

sultan.xh•8/21/23, 4:43 PM

Read this https://developers.cloudflare.com/d1/learning/backups/

Backups (Legacy) · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

landon•8/21/23, 5:02 PM

im getting an odd behavior in my pages project when trying to bind a d1 database. i printed out the env from one of the routes and noticed the variable