DT
Drizzle Team•3w ago
fluchat

Init Drizzle with cloudflare env variables

I'm trying to connect my database with the drizzle adapter. My backend will be hosted on cloudflare workers (with hono) so I can't use process.env to get my environement variables. How to get my cloudflare env variables to the db init ? Thanks for your help! import { drizzle } from "drizzle-orm/neon-http"; import { neon } from "@neondatabase/serverless"; interface Env { Bindings: { DATABASE_URL: string }; } const sql = neon("DATABASE_URL"); export const db = drizzle(sql);
1 Reply
Maston
Maston•3w ago
I think you pretty much cant have "db" as a top level variable in cloudflare workers, with Hono i do something like this: 
import { type NeonHttpDatabase, drizzle } from 'drizzle-orm/neon-http';
import { Hono } from 'hono';

let db: NeonHttpDatabase<typeof schema> | undefined;

const app = new Hono<{
    Bindings: { DATABASE_URL: string };
    Variables: { db: NeonHttpDatabase<typeof schema> };
}>().use(async (ctx, next) => {
    db ??= drizzle(ctx.env.DATABASE_URL, { schema });
    ctx.set('db', db);
    return next();
});

app.get('/', async (ctx) => {
    // now you can use the database in any route, properly typed
    const count = await ctx.var.db.$count(table);
    return ctx.json({ count });
});

export default app;
import { type NeonHttpDatabase, drizzle } from 'drizzle-orm/neon-http';
import { Hono } from 'hono';

let db: NeonHttpDatabase<typeof schema> | undefined;

const app = new Hono<{
    Bindings: { DATABASE_URL: string };
    Variables: { db: NeonHttpDatabase<typeof schema> };
}>().use(async (ctx, next) => {
    db ??= drizzle(ctx.env.DATABASE_URL, { schema });
    ctx.set('db', db);
    return next();
});

app.get('/', async (ctx) => {
    // now you can use the database in any route, properly typed
    const count = await ctx.var.db.$count(table);
    return ctx.json({ count });
});

export default app;

Did you find this page helpful?