await. You can't see the value of a Promise before it's completed, and the console.debug({}) is run before the result of the Promise.await
I
T
D
JJTJ
HHH
env and ctx?HHExportedHandler and Env?
Sconst db = drizzle(env.DB); everywhere they need the db. is that the way to go? or is it still possible to somehow export 1 drizzle client globally?
HSS
BB
await DB.prepare('SELECT col FROM table WHERE col1 = ?2 AND col2 = ?1 AND col3 = ?1').bind(1, 2).run()
ISELECT file_id FROM file WHERE ref_id = '123'"rows_read": 2npx wrangler d1 migrations --helpnpx wrangler d1 migrations apply --helppersist-to
--help
I
S
JS
M
LM
OLAlso is there any way to prevent this replication? Like when does that happen? If for anyone outside of an specific region no DB access happens, does that mean no replication is happening either?There is no replication at the moment. Once it's out, we will have some control for jurisdictions once those are added for D1.
MM
L
meta
CMRPHH
CLOr does it count rows that were checked and not returned as well?All rows read are counted. From indices, non-indices, views, etc.
C
1
DY
if (e.message.startsWith(`D1_ERROR: UNIQUE constraint failed:`)){
throw createError({statusCode:400, statusMessage:`Your name needs to be unique`})
}envctxExportedHandlerEnvconst db = drizzle(env.DB);async fetch(request, env, ctx)