suaveplan/openspec/archive/2026-05-26-api-db-sqlite-memory/api-db-sqlite-memory/tasks.md

Tasks — @suaveplan/api-db-sqlite-memory

Every checkbox MUST reflect work actually done in this change.

0. Pre-flight (non-negotiable)

• 0.1 Confirm clean working tree (git status reports nothing) and no in-flight worktrees with uncommitted work (git worktree list then git status in each)
• 0.2 If any worktrees exist under .claude/worktrees/, account for each one: still-active agent, work-pending-merge, or stale-and-prune. Stale worktrees MUST be removed (git worktree remove) before opening a new one — code that has been lost twice on main is the failure mode this guards against.
• 0.3 Confirm the package set in MANIFEST.md matches find packages -maxdepth 3 -name package.json count. Drift here means a prior change archived without regenerating the manifest.

1. Spec authoring

• 1.1 Read design doc (§13.2, §13.4, §15 Stage 5)
• 1.2 Read openspec/changes/api-db-adapter/ for Stage 4 parallel
• 1.3 Read openspec/AGENTS.md Sections 13 and 14
• 1.4 Draft proposal.md
• 1.5 Draft specs/api-db-sqlite-memory/spec.md
• 1.6 Every requirement carries **Verified by:**

2. Implementation

• 2.1 Scaffold packages/api/api-db-sqlite-memory/ (deps: api-db, api-types, error, zod)
• 2.2 src/options/sqlite-memory-db-options.ts — Zod schema
• 2.3 src/factory/create-sqlite-memory-db.ts — direct surface (admin + scoped)
• 2.4 src/tenant-scoping/tenant-scoping.ts — read/write injection + rejection
• 2.5 src/migrations/migrations.ts — runner with __plugin_migrations table
• 2.6 src/error-codes.ts — DB_SQLITE_MEMORY_* codes via defineCodes
• 2.7 src/index.ts — explicit named re-exports
• 2.8 Register this adapter in @suaveplan/api-host/testing's adapter table under engine: "sqlite-memory"

3. Tests

• 3.1 src/factory/create-sqlite-memory-db.test.ts
• 3.2 src/factory/create-sqlite-memory-db.spec-conformance.test.ts — conformance
• 3.3 src/tenant-scoping/tenant-scoping.test.ts
• 3.4 src/migrations/migrations.test.ts
• 3.5 tests/integration/integration.test.ts — via createTestHost
• 3.6 Every it(...) carries { timeout: 5000 }

4. Documentation

• 4.1 Sibling .md per implementation .ts
• 4.2 README documents the :memory: connection string and the WAL/foreign-keys default pragmas

5. Pre-archive verification (5-gate triple)

• 5.1 bun run check — clean
• 5.2 bunx turbo lint typecheck test --filter=@suaveplan/api-db-sqlite-memory — green
• 5.3 bunx turbo test:coverage --filter=@suaveplan/api-db-sqlite-memory — 100/100/100/100
• 5.4 bun scripts/openspec-conformance.ts @suaveplan/api-db-sqlite-memory — exit 0
• 5.5 bunx turbo build --filter=@suaveplan/api-db-sqlite-memory — green

6. Pre-archive 7-row checklist

• 6.1 expectTypeOf asserts admin vs scoped surfaces type-distinct (same field name, different type)
• 6.2 Zod schema at options + manifest boundaries
• 6.3 Every DB_SQLITE_MEMORY_* code thrown by at least one production path
• 6.4 Strict-mode (autoInjectInserts on/off) tested both ways
• 6.5 OTel instruments (api.db.query_duration_ms, api.db.migrations_applied_total) asserted with in-memory MeterProvider
• 6.6 Migration idempotency tested
• 6.7 No retroactive tick

7. Archive

• 7.1 Fold into openspec/specs/api-db-sqlite-memory/spec.md
• 7.2 Move to openspec/archive/<yyyy-mm-dd>-api-db-sqlite-memory/
• 7.3 Tick Stage 5 box in umbrella tasks
• 7.4 Refresh MANIFEST.md