sailfork / t3code-github / .repos/ alchemy-effect/ demos/ effect-prezzy/ chapters/ 07-telemetry/ src/ Storage.ts

import * as Cloudflare from "@alchemy.run/cloudflare";
import * as D1 from "@alchemy.run/cloudflare/D1/SQL";
import * as Neon from "@alchemy.run/neon";
import * as Postgres from "@alchemy.run/sql/Postgres";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";

/** SQLite on Cloudflare D1. */
export const D1Storage = Layer.unwrap(
  Effect.gen(function* () {
    const db = yield* Cloudflare.D1.Database("Db", { migrations: "./migrations" });
    return D1.D1Layer(yield* Cloudflare.D1.QueryDatabase(db));
  }),
).pipe(Layer.provide(Cloudflare.D1.QueryDatabaseBinding));

/** Postgres on Neon, pooled at the edge by Hyperdrive. Same migrations. */
export const NeonStorage = Layer.unwrap(
  Effect.gen(function* () {
    const db = yield* Neon.Project("Postgres", { migrations: "./migrations" });
    const pool = yield* Cloudflare.Hyperdrive.Connection("Pool", {
      origin: db.origin, // deployed: Hyperdrive pools Neon's direct endpoint
      dev: db.pooledOrigin, // alchemy dev: straight to Neon's own pooler
      caching: { disabled: true }, // links must be read-after-write
    });
    const connection = yield* Cloudflare.Hyperdrive.Connect(pool);
    return Postgres.PostgresLayer({ url: connection.connectionString });
  }),
).pipe(Layer.provide(Cloudflare.Hyperdrive.ConnectBinding));