AGENTS.md

1# Effect Drizzle SQLite
2 
3This package vendors a Drizzle Effect SQLite adapter for this repo.
4 
5- Keep this package generic: Drizzle + Effect + SQLite only.
6- Do not add opencode-specific tables, paths, migrations, post-commit hooks, or domain storage APIs here.
7- Runtime code should depend on generic `effect/unstable/sql/SqlClient`, not a specific SQLite driver.
8- Concrete SQLite clients such as `@effect/sql-sqlite-bun` belong in tests or examples unless this package intentionally adds a driver-specific helper.
9- Preserve Drizzle adapter naming and behavior where possible so this can be replaced by upstream `drizzle-orm/effect-sqlite` later.
10- If touching copied Drizzle internals, compare with current `drizzle-orm@1.0.0-rc.2` declarations and runtime JS.
11- If touching Effect APIs, verify against `/Users/kit/code/open-source/effect-smol`.
12 
13Useful entry points:
14 
15- `src/effect-sqlite/driver.ts`: creates the Effect-backed Drizzle database with `make` and `makeWithDefaults`.
16- `src/effect-sqlite/session.ts`: adapts generic Effect `SqlClient` execution and transactions to Drizzle SQLite sessions.
17- `src/sqlite-core/effect/*`: Effect-yieldable SQLite query builders.
18- `src/internal/drizzle-utils.ts`: local typed shims for Drizzle runtime internals that RC2 does not expose in declarations.
19- `examples/basic.ts`: minimal usage example with Bun SQLite.
20