Database

Overview

service-database provides a Drizzle PostgreSQL client as an Effect service. It reads DATABASE_URL, configures pg type parsing for date and interval types, and exposes a reusable layer for application programs.

Usage

import { Effect } from "effect";
import { DB } from "@/services/database";
import { users } from "@/db/schema";

const program = Effect.gen(function* () {
  const db = yield* DB;
  return yield* db.select().from(users);
});

const usersList = await Effect.runPromise(
  program.pipe(Effect.provide(DB.layer)),
);