drizzle-effect.ts

import * as PgDrizzle from "@effect/sql-drizzle/Pg";
import { PgClient } from "@effect/sql-pg";
import { Config, Effect } from "effect";
import * as schema from "~/lib/server/schema";

const PgLive = PgClient.layerConfig({
  url: Config.redacted("DATABASE_URL"),
});

export class DrizzleClient extends Effect.Service<DrizzleClient>()("app/DrizzleClient", {
  dependencies: [PgLive],
  effect: Effect.gen(function* () {
    const db = yield* PgDrizzle.make<typeof schema>({
      schema: schema,
    });
    return db;
  }),
}) {}

thank you @kandros! I was stuck on this for a long time :)
Please update this as well when there is a better way to handle this 🙏