Cloudflare Developers•17mo ago

sorry for bothering you due to my stupidity

Hello, I’m Allie!•8/17/24, 11:39 AM

Though forgot that was exposed, tbh

Vveeque sorry for bothering you due to my stupidity

Hello, I’m Allie!•8/17/24, 11:39 AM

All good, you definitely aren’t alone on that front

veequeOP•8/17/24, 11:40 AM

just a question though, is it safe to put my wrangler.toml's config containing the database_id in the git history? is it kind of like an api token?

Vveeque just a question though, is it safe to put my wrangler.toml's config containing t...

Hello, I’m Allie!•8/17/24, 11:44 AM

Nope. Unless I have access to your account, then the ID is useless. In fact, everything in your

wrangler.toml

wrangler.toml

is safe to commit, assuming you are using secrets where appropriate

veequeOP•8/17/24, 11:44 AM

oh ok, that's nice

veequeOP•8/17/24, 11:44 AM

veequeOP•8/17/24, 12:15 PM

@HardlyWorkin' how would i go about using the database outside of platform.env? (eg use drizzle) i tried looking everywhere but i just can't wrap my head around it

Vveeque @HardlyWorkin' how would i go about using the database outside of platform.env? ...

Hello, I’m Allie!•8/17/24, 12:20 PM

You construct the

drizzle

drizzle

instance with platform.env.DBplatform.env.DB

veequeOP•8/17/24, 12:20 PM

but i have to do that for each api route?

veequeOP•8/17/24, 12:21 PM

don't i need to make one instance for the whole thing?

Vveeque but i have to do that for each api route?

Hello, I’m Allie!•8/17/24, 12:23 PM

You can construct one inside a Server Hook, but they need to be created fresh on each request

jacoblukewood•8/17/24, 12:57 PM

Hi, I'm using D1 in SvelteKit.

I want to prerender all of my pages because the content only needs to be updated occasionally (every few weeks), on build I want to fill in the content of my pages with the content in the DB.

I can't seem to get it to work with adapter-static or adapter-cloudflare because the platform.env.DB object isn't bound at build time. This happens both if I try building locally and on Cloudflare Pages.

Any advice?

Jjacoblukewood Hi, I'm using D1 in SvelteKit. I want to prerender all of my pages because the ...

Hello, I’m Allie!•8/17/24, 12:57 PM

Bindings like D1 are unfortunately not available at build time

jacoblukewood•8/17/24, 12:59 PM

Do you have any guidance on where I could go from here to be able to do a static build? The only thing I can think of is moving my svelte endpoints that access D1 to workers functions and calling those

HHello, I’m Allie!You can construct one inside a Server Hook, but they need to be created fresh on...

veequeOP•8/17/24, 1:17 PM

so it's fine if in a +(*.)server.ts+(*.)server.ts route i alway reinstantiate drizzle, right?

Vveeque so it's fine if in a `+(*.)server.ts` route i alway reinstantiate drizzle, right...

Hard@Work•8/17/24, 1:19 PM

Yeah, it's fine

Jjacoblukewood Do you have any guidance on where I could go from here to be able to do a static...

Hard@Work•8/17/24, 1:20 PM

You could make the queries via the D1 API? It's quite a bit slower, but I would think it is a bit easier than splitting up your app like that

veequeOP•8/17/24, 1:26 PM

if in my wrangler.toml file i put a

database_id

database_id

and a different

preview_database_id

preview_database_id

(one is called prod-mainprod-main the other dev-maindev-main, but in the file i have just database_name = "prod-main"database_name = "prod-main") will it still work?

veequeOP•8/17/24, 1:36 PM

also, migrations stored in the migrationsmigrations folder don't get applied automatically if someone pushes a new sql file, right? if that's the case however, how can i disable that behaviour?

HHard@Work You could make the queries via the D1 API? It's quite a bit slower, but I would ...

jacoblukewood•8/17/24, 1:50 PM

great idea. thank you

Vveeque if in my wrangler.toml file i put a `database_id` and a different `preview_datab...

Hard@Work•8/17/24, 1:53 PM

In local mode?

Vveeque also, migrations stored in the `migrations` folder don't get applied automatical...

Hard@Work•8/17/24, 1:53 PM

I don't think there is a setting to have the automatically applied. I think you need to run the migrations yourself manually

X•8/17/24, 6:11 PM

Ottomated•8/18/24, 1:19 AM

Anyone know why BLOB fields return number[]number[] instead of ArrayBufferArrayBuffer? Seems weird because the docs show that they should map to ArrayBuffers.

FFini I ❤️ Cloudflare My production D1 has been down for 2 days and still no reply on ...

Walshy•8/18/24, 12:13 PM

what's your ticket id?

Walshy•8/18/24, 12:41 PM

I've escalated it to support to check on

shellsort•8/18/24, 3:16 PM

Using rusts prepare and all functions, I execute an sql statement in my scheduled worker using the --test-scheduled flag of wrangler and then running

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

to simulate a scheduled event instantly.

This returns an error:

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

When executing the same statement via the REST API I get the expected result.

I tried wrapping the table name in ' ' marks, but get the same result.

Does anyone have an idea?
Yes it's the same database. Yes I double checked the table name.

shellsort•8/18/24, 3:18 PM

It's a really simple sql statement too. No joins or anything like that happening. Just good old select x from y when z.

shellsort•8/18/24, 4:04 PM

-> Fixed. Resolve was using the --remote flag/creating a local dev d1 db.

moonchav•8/18/24, 7:26 PM

is it possible to bind multiple D1 dbs to a single worker? And is it possible to bind a single D1 db to multiple workers?

Mmoonchav is it possible to bind multiple D1 dbs to a single worker? And is it possible to...

Isaac McFadyen•8/18/24, 7:26 PM

Yes and yes

Isaac McFadyen•8/18/24, 7:26 PM

Just bind it like normal in your wrangler.toml but specify multiple of them

moonchav•8/18/24, 7:27 PM

oh sweet, thank you! I should have just rolled the dice and tried it before asking

Isaac McFadyen•8/18/24, 7:27 PM

No problem :lul:

veequeOP•8/19/24, 1:47 PM

in my

wrangler.toml

wrangler.toml

file I have this:

[[d1_databases]]
binding = "db"
database_name = "prod-main"
database_id = "[uuid1]"
preview_database_id = "[uuid2]"

[[d1_databases]]
binding = "db"
database_name = "prod-main"
database_id = "[uuid1]"
preview_database_id = "[uuid2]"

(it's a sveltekit app) however the preview deployments still use the production database... I thought that setting the

preview_database_id

preview_database_id

to the uuid of the preview database would suffice, but apparently it doesn't. In the D1 documentation I could only find https://developers.cloudflare.com/d1/configuration/environments/ but the config used looks vastly different than mine. what do I have to do?

Vveeque in my `wrangler.toml` file I have this: ``` [[d1_databases]] binding = "db" dat...

Hard@Work•8/19/24, 1:51 PM

IIRC preview IDs aren't used for anything on pages. You need to add a