effect feat: expose raw sqlite client in `sql-sqlite-bun` and `sql-sqlite-node`

Type

[ ] Refactor
[x] Feature
[ ] Bug Fix
[ ] Optimization
[ ] Documentation Update

Description

This PR is intended to expose the internal database client for sql-sqlite-bun and sql-sqlite-node packages. My primary reason for doing this was the need to feed the better-auth library with the raw database client, which currently is not available.

I think this can be afterwards added to the other sql packages.

Usage:

const sql = yield* SqliteClient.SqliteClient
const rawClient = yield* sql.rawClient
yield* Effect.sync(() => rawClient.exec("CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT)"))
yield* Effect.sync(() => rawClient.exec("INSERT INTO test (name) VALUES ('hello')"))
const rows = yield* Effect.try(() => rawClient.prepare("SELECT * FROM test").all())
assert.deepStrictEqual(rows, [{ id: 1, name: "hello" }])

Or in my use-case:

const make = Effect.gen(function*() {
  const sql = yield* SqliteClient.SqliteClient;
  const rawClient = yield* sql.rawClient;

  const auth = yield* Effect.try(() =>
    betterAuth({
      database: rawClient,
      emailAndPassword: {
        enabled: true,
      },
    }),
  );

  return BetterAuthClient.of(auth);
});

feat: expose raw sqlite client in `sql-sqlite-bun` and `sql-sqlite-node`

Type

Description

Related

⚠️ No Changeset found