andrijan_
andrijan_
Explore posts from servers
DTDrizzle Team
Created by andrijan_ on 8/21/2023 in #help
Instantiate a connection with PlanetScale in Cloudflare Workers
Hey, What would be the right way to instantiate a database connection with PlanetScale in Cloudflare workers and reuse it across different handlers? We cannot instantiate it outside the handler because we have no access to the environment variables :
const connection = connect({
url: ENV,
fetch: (url, init) => {
delete init["cache"];
return fetch(url, init);
},
});

const db = drizzle(connection);

app.get("/users", async () => ...);
const connection = connect({
url: ENV,
fetch: (url, init) => {
delete init["cache"];
return fetch(url, init);
},
});

const db = drizzle(connection);

app.get("/users", async () => ...);
So, we need to create a function where we can pass the env object as a parameter to access the environment variables:
export function db(env: ENV_VARIABLES) {
const connection = connect({
url: env.DATABASE_URL,
fetch: (url, init) => {
delete init["cache"];
return fetch(url, init);
},
});

return drizzle(connection);
}
export function db(env: ENV_VARIABLES) {
const connection = connect({
url: env.DATABASE_URL,
fetch: (url, init) => {
delete init["cache"];
return fetch(url, init);
},
});

return drizzle(connection);
}
And then use it in different handlers:
app.post("/users", async (context) => db.insert(users).values({...});
app.post("/posts", async (context) => db.insert(posts).values({...});
app.post("/users", async (context) => db.insert(users).values({...});
app.post("/posts", async (context) => db.insert(posts).values({...});
I wonder if this is a safe way to instantiate a connection and reuse it across different handlers with Cloudflare Workers?
2 replies