Cloudflare Developers•3y ago

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 backup

wrangler 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

__D1_BETA__D1_DB

__D1_BETA__D1_DB

rather than

D1_DB

D1_DB

that i have specified as the binding in the settings. what could be causing this?

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

could this be a symptom of using wrangler

3.4.0

3.4.0

rather than

3.5.1

3.5.1

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

Cyb3r-Jak3•8/21/23, 5:06 PM

The beta backend doesn’t allow for you to export a copy

Llandon could this be a symptom of using wrangler `3.4.0` rather than `3.5.1`?

Cyb3r-Jak3•8/21/23, 5:08 PM

Correct. They removed the D1 shim in wrangler 3.5.0

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

so upgrade wrangler and maybe thats the win?

sultan.xh•8/21/23, 5:09 PM

Anyone can help me figure out the ORDER BY option?

Ssultan.xh Anyone can help me figure out the ORDER BY option?

chientrm.com•8/21/23, 5:15 PM

say it

Cchientrm.com say it

sultan.xh•8/21/23, 5:30 PM

How can I sort data by id? Something like

order by id desc

order by id desc

Ssultan.xh How can I sort data by id? Something like `order by id desc`?

chientrm.com•8/21/23, 5:32 PM

that's it

Cchientrm.com that's it

sultan.xh•8/21/23, 5:36 PM

Ahh thanks! I was checking this query

'SELECT * FROM content WHERE json_extract(data, "$.s") IN (0,1) AND json_extract(data, "$.t") IN (0) ORDER BY id DESC LIMIT 10 OFFSET 10'

'SELECT * FROM content WHERE json_extract(data, "$.s") IN (0,1) AND json_extract(data, "$.t") IN (0) ORDER BY id DESC LIMIT 10 OFFSET 10'

and it worked.

But if you add

order by

order by

end of the query, it does not work. Anyways, thanks again.

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

ive upgraded to 3.5.1, removed bindings, re-added, re-deployed still getting the same behavior:

__D1_BETA_

__D1_BETA_

is being added as a prefix in the environment, but not binding named

DB

DB

binding name: DB
env contains: __D1_BETA_DB

binding name: DB
env contains: __D1_BETA_DB

I tried to reference that variable

__D1_BETA_DB

__D1_BETA_DB

, but it tells me that there is no function

prepare

prepare

on it.

im expecting (and this was previous behavior) that a

DB

DB

variable is hanging on the env that i can call prepare on. any ideas?

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

Similar Threads

Similar Threads

Similar Threads