interface Platform {
env: {
db: D1Database;
};
}
HUnlike Workers Environments, production and preview are the only two options available via [env.<ENVIRONMENT>] on Pages
VHVV
/api/create/[user]const result = await db.select().from(schema.users);env: {},svelte.config.jsplatformProxy.environment'production'
H
LLL
E
J
D
M
O
A
S
F
I
MMLDL
MLMLM
J
JMD
M
B
0
A
ATTACH DATABASE
Y
Y
MIndexes will add an additional written row when writes include the indexed column, as there are two rows written: one to the table itself, and one to the index. The performance benefit of an index and reduction in rows read will, in nearly all cases, offset this additional write.
YBY
export const GET: RequestHandler = async ({ params, platform }) => {
if (platform === undefined) return new Response('err');
if (params.user === undefined) return new Response('err');
const db = await drizzle(platform?.env.db, { schema });
const result = await db.insert(schema.users).values({ name: params.user });
return new Response(JSON.stringify(result));
};
CDCloudflare Developers / pages-helpCDCloudflare Developers / workers-and-pages-helpCDCloudflare Developers / workers-and-pages-help