Initilize Database adapter Dynamically.

[bqrkhn]

I'm using cloudflare D1 database. Since they have a hard limit of 10GB data per database, I have to create different Databases for each live Tenant.

I have Key Value store (KV) which maps domain -> Database Name. So when a page (expect SignIn/Signup) are accessed, I need to know which database connect to dynamically.

As per docs, I need to export this from the src/auth.ts file:

const adapter = new DrizzleSQLiteAdapter(db, sessionTable, userTable);

So how to I handle this now? I can create a initilizeLucia function which will initialize based on the domain but that will create a new database adapter everytime.

import { Lucia } from "lucia";
import { DrizzleSQLiteAdapter } from "@lucia-auth/adapter-drizzle";
import { getClientDb, userTable, sessionTable } from "./db";

export async function initializeLucia(domain: string) {
    const db = await getClientDb(domain);
    if (!db) {
        throw new Error(`Unable to initialize database for domain: ${domain}`);
    }

    const adapter = new DrizzleSQLiteAdapter(db, sessionTable, userTable);

    return new Lucia(adapter, {
        sessionCookie: {
            attributes: {
                secure: process.env.NODE_ENV === "production"
            }
        }
    });
}

// Extend the Lucia type definitions
declare module "lucia" {
    interface Register {
        Lucia: ReturnType<typeof initializeLucia>;
        DatabaseUserAttributes: {};
    }
}

Is there a better way to do this?