Migrate `task-store.ts` to Drizzle (separate `tasks.db` client) #847

New issue

Closed

opened 2026-05-04 20:29:27 +00:00 by claude-desktop · 0 comments

claude-desktop commented

2026-05-04 20:29:27 +00:00

Collaborator

As a maintainer, I want task-store.ts rewritten on Drizzle with its own client over tasks.db, so that task persistence + usage analytics are type-safe.

Acceptance criteria

Client

db/client-tasks.ts — Drizzle wrapper over getTaskDb().
Schema files for tasks DB tables.

Rewrite

All ~30 fns rewritten on Drizzle: persistTask, getTaskById, getFullTaskById, listTasksForIssue, queryConcurrentRuns, listUnresolvedInterruptedTasks, lastFinishedAtByAgent, hasRecentDispatch, listZeroOutputSuccesses, computeUsage, getIssueUsage, etc.

Tests

task-store.test.ts + history-contract.test.ts green.

Out of scope

Domain analytics (domain/analytics/) — only data layer.

References

apps/server/src/infrastructure/database/task-store.ts.
Foundation story (#839) must merge first.

**As a** maintainer, **I want** `task-store.ts` rewritten on Drizzle with its own client over `tasks.db`, **so that** task persistence + usage analytics are type-safe. ## Acceptance criteria ### Client - [ ] `db/client-tasks.ts` — Drizzle wrapper over `getTaskDb()`. - [ ] Schema files for tasks DB tables. ### Rewrite - [ ] All ~30 fns rewritten on Drizzle: `persistTask`, `getTaskById`, `getFullTaskById`, `listTasksForIssue`, `queryConcurrentRuns`, `listUnresolvedInterruptedTasks`, `lastFinishedAtByAgent`, `hasRecentDispatch`, `listZeroOutputSuccesses`, `computeUsage`, `getIssueUsage`, etc. ### Tests - [ ] `task-store.test.ts` + `history-contract.test.ts` green. ## Out of scope - Domain analytics (`domain/analytics/`) — only data layer. ## References - `apps/server/src/infrastructure/database/task-store.ts`. - Foundation story (#839) must merge first.

claude-desktop added the

area:database

type:user-story

labels

2026-05-04 20:30:09 +00:00

claude-desktop added this to the ORM migration (Drizzle) milestone

2026-05-04 20:30:18 +00:00