a hello @kiannh thanks for your replay , i got the issue , i added transaction in my query !

a hello @kiannh thanks for your replay , i got the issue , i added transaction in my query !!!!!!!!!!!!!, and its become rude ,
any way to use transaction ?

chientrm.com•8/19/23, 12:34 PM

Consider D1 is so superior, what's holding cloudflare

back from pushing the limits over 500MB?

Jjahir9991 a hello @kiannh thanks for your replay , i got the issue , i added ***transact...

Cyb3r-Jak3•8/19/23, 1:37 PM

Not currently. It is planned but no ETA. If you use

.batch()

.batch()

it gets auto transaction

chientrm.com•8/19/23, 4:40 PM

I'm using EXPLAINEXPLAIN statement. The column name is messed up?

Screen_Shot_2023-08-19_at_11.39.44_PM.png

Cchientrm.com Consider D1 is so superior, what's holding <:cloudflare:1026272852900581496> bac...

DebianArch•8/19/23, 7:22 PM

Cloudflare-d1 is very promising, the only thing I'm concerned about as-well is the 500Mb limit

DebianArch•8/19/23, 7:23 PM

Cloudflare D1 is pretty beastly when paired with drizzle orm makes relational queries so easy

DDebianArch Cloudflare D1 is pretty beastly when paired with drizzle orm makes relational qu...

chientrm.com•8/20/23, 2:00 AM

Cchientrm.com I'm using `EXPLAIN` statement. The column name is messed up? 🤔

Matt Silverlock•8/20/23, 11:27 AM

That’s correct.

When the EXPLAIN keyword appears by itself it causes the statement to behave as a query that returns the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present. When the EXPLAIN QUERY PLAN phrase appears, the statement returns high-level information regarding the query plan that would have been used.

https://www.sqlite.org/lang_explain.html

MMatt Silverlock That’s correct. > When the EXPLAIN keyword appears by itself it causes the state...

chientrm.com•8/20/23, 11:30 AM

totally not understand

JJorgeDev Will this be increased in the future? Does anyone know?

Hello, I’m Allie!•8/20/23, 12:40 PM

Many of these limits will increase during D1’s public alpha. Join the #d1-database channel in the Cloudflare Developer Discord to keep up to date with changes.
From the Docs

Limits · Cloudflare D1 docs

Many of these limits will increase during D1’s public alpha. Join the #d1-open-alpha channel in the Cloudflare Developer Discord to keep up to date …

Cyb3r-Jak3•8/20/23, 12:53 PM

They have also said 1 GB for DB sizes in blog posts

chientrm.com•8/20/23, 12:54 PM

also notice that new backend seem to use less space than legacy.

chientrm.com•8/20/23, 2:31 PM

also D1 make me love SQL again

jahir9991OP•8/20/23, 6:50 PM

@Matt is there any way i can access d1 local or remote in sveltekit without build version

jahir9991OP•8/20/23, 6:53 PM

My bad !!!!

Jjahir9991 @Matt is there any way i can access d1 local or remote in sveltekit without bui...

chientrm.com•8/20/23, 7:17 PM

https://www.npmjs.com/package/cf-workers-proxy

npm

cf-workers-proxy

Enable Cloudflare Workers runtime for local development. Latest version: 0.4.0, last published: 10 days ago. Start using cf-workers-proxy in your project by running npm i cf-workers-proxynpm i cf-workers-proxy. There are no other projects in the npm registry using cf-workers-proxy.

Cchientrm.com https://www.npmjs.com/package/cf-workers-proxy

jahir9991OP•8/20/23, 8:57 PM

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

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

Dahoom•8/20/23, 10:19 PM

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

Dahoom•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...

jahir9991OP•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...

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

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

jahir9991OP•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

jahir9991OP•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 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.

a hello @kiannh thanks for your replay , i got the issue , i added ***transaction*** in my query !

Similar Threads

a hello @kiannh thanks for your replay , i got the issue , i added transaction in my query !