Better Auth•3w ago

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);

Solution:

```ts import { drizzle } from "drizzle-orm/d1"; import * as schema from "./auth-schema"; export const createDrizzle = (db: D1Database) => drizzle(db, { schema });...

Jump to solution

6 Replies

Ping•3w ago

I don't use Hono, but from what I've seen with other users, it should look something like this:

export const createAuth = (env: CloudflareBindings) =>
    betterAuth({
        database: drizzleAdapter(createDrizzle(env.DB), { provider: "sqlite" }),
        secret: "some-secret-value-here",
        emailAndPassword: {
            enabled: true,
        },
    });

export type Auth = ReturnType<typeof createAuth>;

export const createAuth = (env: CloudflareBindings) =>
    betterAuth({
        database: drizzleAdapter(createDrizzle(env.DB), { provider: "sqlite" }),
        secret: "some-secret-value-here",
        emailAndPassword: {
            enabled: true,
        },
    });

export type Auth = ReturnType<typeof createAuth>;

fluchatOP•3w ago

thank you so much! do you have the complete codebase? @Ping

Solution

Ping•3w ago

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

import { drizzle } from "drizzle-orm/d1";
import * as schema from "./auth-schema";

export const createDrizzle = (db: D1Database) => drizzle(db, { schema });

Ping•3w ago

This is just me searching through the better-auth codebase. Must be some demo / testing code

fluchatOP•3w ago

thanks a lot! I think I get it, still trying to figure it out on my own code base, will update this post with my solution for others :)

fluchatOP•3w ago

https://tenor.com/view/there-you-have-it-boys-case-closed-the-simpsons-gif-13616870

Tenor

Gaming

Programming

Init Drizzle with cloudflare env variables

Did you find this page helpful?