just a question though, is it safe to put my wrangler.toml's config containing the database_id in th

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.DB

platform.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-main

prod-main

the other

dev-main

dev-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

migrations

migrations

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

ArrayBuffer

ArrayBuffer

? 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

database_id

database_id

to the preview env

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

and that env is set to be the staging one by preview deployments without me having anything to do, right?

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

ah ok, i see now, ty

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

can a d1 db be renamed?

FFini Thanks, I appreciate it. It's a production system that's now been done for 2 day...

Walshy•8/19/24, 6:20 PM

You should be good now, apologies for the issue!

カ

カイル•8/20/24, 5:00 AM

Is it possible to use the D1 rest API but lockdown the API key to only that D1 database

WWalshy You should be good now, apologies for the issue!

Dean•8/20/24, 10:06 AM

What was the cause? Deploying a ton of databases and this has me concerned

カカイル Is it possible to use the D1 rest API but lockdown the API key to only that D1 d...

Dean•8/20/24, 10:20 AM

Better off using a worker with an API Key.

veequeOP•8/20/24, 11:25 AM

this is my

wrangler.toml

wrangler.toml

name = "[the name]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[env.production.d1_databases]]
binding = "db"
database_name = "prod-main"
database_id = "524d4c4f-410b-46f9-9a87-2dc4f6110b1c"

[[env.preview.d1_databases]]
binding = "db"
database_name = "dev-main"
database_id = "025df237-d405-4f57-859f-ad3a055fd74b"

name = "[the name]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[env.production.d1_databases]]
binding = "db"
database_name = "prod-main"
database_id = "524d4c4f-410b-46f9-9a87-2dc4f6110b1c"

[[env.preview.d1_databases]]
binding = "db"
database_name = "dev-main"
database_id = "025df237-d405-4f57-859f-ad3a055fd74b"

and when I try to run

wrangler d1 migrations apply prod-main --local

wrangler d1 migrations apply prod-main --local

(or even without

--local

--local

) it says:

 ⛅️ wrangler 3.72.0
-------------------

✘ [ERROR] Couldn't find a D1 DB with the name or binding 'prod-main' in wrangler.toml.

 ⛅️ wrangler 3.72.0
-------------------

✘ [ERROR] Couldn't find a D1 DB with the name or binding 'prod-main' in wrangler.toml.

is it because of the way I've set up the environment variables?

veequeOP•8/20/24, 11:26 AM

it works just fine when running on cloudflare itself

name = "[the name]" compatibility_date = "2024-07-29" pages_build_output_dir = ".svelte-kit/cloudflare" [[env.production.d1_databases]] binding = "db" database_name = "prod-main" database_id = "524d4c4f-410b-46f9-9a87-2dc4f6110b1c" [[env.preview.d1_databases]] binding = "db" database_name = "dev-main" database_id = "025df237-d405-4f57-859f-ad3a055fd74b"

just a question though, is it safe to put my wrangler.toml's config containing the database_id in th

Similar Threads

Similar Threads

Similar Threads