Cloudflare Developers•5mo ago

Anyone know why BLOB fields return `number[]` instead of `ArrayBuffer`? Seems weird because the docs

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

14 Replies

Unknown User•5mo ago

Message Not Public

Walshy•5mo ago

what's your ticket id?

Unknown User•5mo ago

Message Not Public

Walshy•5mo ago

I've escalated it to support to check on

Unknown User•5mo ago

Message Not Public

shellsort•5mo ago

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. It's a really simple sql statement too. No joins or anything like that happening. Just good old select x from y when z. -> Fixed. Resolve was using the --remote flag/creating a local dev d1 db.

Unknown User•5mo ago

Message Not Public

moonchav•5mo ago

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?

Isaac McFadyen•5mo ago

Yes and yes 😄 Just bind it like normal in your wrangler.toml but specify multiple of them

moonchav•5mo ago

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

Isaac McFadyen•5mo ago

No problem :lul:

veeque•5mo ago

in my 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 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? 😅

Hard@Work•5mo ago

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

veeque•5mo ago

and that env is set to be the staging one by preview deployments without me having anything to do, right? ah ok, i see now, ty

Gaming

Programming

Anyone know why BLOB fields return `number[]` instead of `ArrayBuffer`? Seems weird because the docs