PH-DB execution tracker — phases, workpackages, cross-links¶
Status: Active (2026-05-26)
Sprint: Wave 3 = WP-G … WP-K (CI, containers, hosting, production gates)
Plans: ph-db-battle-plan.md (engine WPs A–F) · ph-db-ci-hosting-plan.md (CI/hosting WPs G–K) · ph-db-lidb-platform.md (phase index)
1. Execution phases (Wave 3 ladder)¶
Cross-repo CI + hosting MVP phases from ph-db-ci-hosting-plan.md §6–9. Status reflects verified state 2026-05-26; update this table when a phase exit gate closes.
| Phase | Theme | Primary WPs | Exit gate (summary) | CI | Containers | Hosting | Prod gates | Owner / notes |
|---|---|---|---|---|---|---|---|---|
| 0 | CI foundation | WP-G (+ WP-A, WP-E prereqs) | Cross-repo PR signal: lidb smoke + lis db-smoke + agents mock e2e; engine e2e tracked (continue-on-error until green) | Partial | — | — | — | lidb, lis, li-cursor-agents; optional lic aggregator |
| 1 | Containers | WP-H | docker compose -f docker-compose.ph-db.yml up → lis db status exit 0; optional ghcr.io/li-langverse/lidb-ci | Partial (per-repo only) | Not started | — | — | lidb, lis; docs mirror in lic |
| 2 | Hosting | WP-I (+ WP-B) | lis db start\|status is agent health gate; CI runs db-smoke.sh on Linux + macOS; systemd/foreground sample | Partial | — | Dev-ready | — | lis (embeds lidb) |
| 3 | Production gates | WP-J, WP-K (+ WP-C) | ORM contract semver; nightly Postgres compare → honest P95 ratio; §9 DoD complete before default LI_CONTROL_PLANE_STORE=lidb | No Postgres nightly | — | Staging = Supabase default | Blocked | benchmarks, lidb, agents; human flip required |
Phase dependency sketch
flowchart LR
P0["Phase 0 CI foundation"]
P1["Phase 1 Containers"]
P2["Phase 2 Hosting"]
P3["Phase 3 Prod gates"]
WPA[WP-A engine]
WPB[WP-B lis db]
WPE[WP-E persist]
WPG[WP-G CI cross-repo]
WPH[WP-H containers]
WPI[WP-I lis service]
WPJ[WP-J ORM contracts]
WPK[WP-K Postgres nightly]
WPA --> P0
WPE --> P0
WPG --> P0
WPB --> P1
WPH --> P1
WPB --> P2
WPI --> P2
WPA --> P3
WPJ --> P3
WPK --> P3
P0 --> P1
P1 --> P2
P2 --> P3 2. Workpackage registry (WP-A … WP-K)¶
PR URL pattern (new): https://github.com/li-langverse/{owner-repo}/compare/main...{branch}?expand=1
Shortcut: https://github.com/li-langverse/{owner-repo}/pull/new/{branch}
| WP | Wave | Owner repo(s) | Branch pattern | Tip (2026-05-26) | Depends on | Phase | §10 verified | Ready merge? | DoD |
|---|---|---|---|---|---|---|---|---|---|
| A | 1 | lidb | cursor/wp-a-ph-db-2-engine | 7ef9509 | Wave 0 | — | §10.1 | No | - [ ] smoke + pytest green on main- [ ] security harness: zero critical skips/fails - [ ] liorm.execute vs native embed (integration test)- [ ] PR: lidb/pull/new/cursor/wp-a-ph-db-2-engine |
| B | 1 | lis | cursor/wp-b-ph-db-3-lis-db | ceac11e | soft WP-A | 2 | §10.1 | Yes | - [x] db-smoke.sh start→status→migrate→stop- [ ] formal pytest in CI - [ ] README env contract sign-off - [ ] PR: lis/pull/new/cursor/wp-b-ph-db-3-lis-db |
| C | 2 | benchmarks, lidb | cursor/wp-c-ph-db-5-registry-bench | fee9582 | WP-A; soft WP-B | 3 | §10.1 | No | - [x] real harness code path; validate-only CI - [x] honest status=unknown without Postgres- [ ] Postgres P95 + ratio_vs_postgres ≤ 1.2 (3 scenarios)- [ ] PR: benchmarks/pull/new/cursor/wp-c-ph-db-5-registry-bench |
| D | 1–2 | lidb, lip, lic (docs) | cursor/wp-d-ph-db-4-registry | 4e34f0a | WP-A; soft WP-B | — | §10.1 | No | - [ ] registry_smoke green- [ ] pytest green on branch - [ ] lip OpenAPI parity table; zero blocking v2 read fields - [ ] human PH-8d-v2 unblock sign-off - [ ] PR: lidb/pull/new/cursor/wp-d-ph-db-4-registry · lic/pull/new/cursor/wp-d-ph-db-4-registry |
| E | 2 | li-cursor-agents | cursor/wp-e-ph-db-10-liorm | ac8c656 | WP-A, WP-B | 0 | §10.1 | No | - [x] npm test; mock e2e green- [ ] engine e2e: clear 2 todos (handoffs, control_plane_reports) - [ ] persist via liorm without LI_LIDB_MOCK=1- [ ] PR: li-cursor-agents/pull/new/cursor/wp-e-ph-db-10-liorm |
| F | 1 | research-findings | cursor/wp-f-db-r0-experiments | 826285a | — | — | §10.1 | Yes (study) | - [x] DB-R0-1, DB-R0-4 reproduce scripts green - [x] validity_grade: study-only artifacts- [ ] PR: research-findings/pull/new/cursor/wp-f-db-r0-experiments |
| G | 3 | lidb, lis, li-cursor-agents, optional lic | cursor/wp-g-ph-db-ci-cross-repo | — | WP-A, WP-E | 0 | not run | Not started | - [ ] agents PR CI re-enabled (path-filtered OK) - [ ] job lidb-engine-e2e with lidb checkout + cmake- [ ] mock e2e on every agents PR - [ ] PR: li-cursor-agents/pull/new/cursor/wp-g-ph-db-ci-cross-repo |
| H | 3 | lidb, lis, lic (docs) | cursor/wp-h-ph-db-containers | — | WP-B | 1 | not run | Not started | - [ ] lidb/docker/Dockerfile.embed- [ ] lis/docker/Dockerfile.supervisor- [ ] docker-compose.ph-db.yml healthcheck- [ ] PR: lis/pull/new/cursor/wp-h-ph-db-containers |
| I | 3 | lis | cursor/wp-i-ph-db-lis-service | — | WP-A, WP-B | 2 | not run | Not started | - [ ] merge WP-B; formal pytest in CI - [ ] lis db start --foreground; systemd sample- [ ] db-smoke mandatory ubuntu + macOS - [ ] PR: lis/pull/new/cursor/wp-i-ph-db-lis-service |
| J | 3 | lidb, lis, li-cursor-agents | cursor/wp-j-ph-db-orm-contracts | — | WP-A, WP-B | 3 | not run | Not started | - [ ] JSON schema: lis db status, bridge stdout- [ ] bridge session reuse; protocol semver doc - [ ] PR: lidb/pull/new/cursor/wp-j-ph-db-orm-contracts |
| K | 3 | benchmarks, lidb | cursor/wp-k-ph-db-bench-postgres-ci | — | WP-A, WP-C | 3 | not run | Not started | - [ ] GHA services: postgres:16 nightly + dispatch- [ ] BENCH_DB_REGISTRY_RUN_HARNESS=1 compare profile- [ ] artifact: numeric P95 + ratio or explicit failed- [ ] PR: benchmarks/pull/new/cursor/wp-k-ph-db-bench-postgres-ci |
Wave legend
| Wave | WPs | Sprint |
|---|---|---|
| 0 | merge stubs | fix-swarm-health-9031, stdlib-adt-wp0, wp-lic-01-verticals-toml — see battle plan §6 |
| 1 | A, B, D, F | Prior sprint (engine + supervisor + schema prep) |
| 2 | C, E | Integration (bench harness + control-plane persist) |
| 3 | G, H, I, J, K | This sprint — ci-hosting plan |
Tracker branch (lic): cursor/ph-db-execution-tracker · open PR
3. Merge order and parallelism¶
From ph-db-ci-hosting-plan.md §8 and ph-db-battle-plan.md §4–6.
| Order | WP / branch | Unblocks |
|---|---|---|
| Wave 0 | agents cursor/fix-swarm-health-9031; lic cursor/stdlib-adt-wp0, cursor/wp-lic-01-verticals-toml | baseline |
| 1 | WP-A cursor/wp-a-ph-db-2-engine | lidb CI, liorm execute, WP-G, WP-K |
| 2 | WP-B cursor/wp-b-ph-db-3-lis-db | WP-H, WP-I |
| 3 | WP-E cursor/wp-e-ph-db-10-liorm | WP-G engine e2e |
| 4 | WP-C cursor/wp-c-ph-db-5-registry-bench | WP-K nightly compare |
| 5 | WP-D cursor/wp-d-ph-db-4-registry | PH-8d-v2 (not CI MVP) |
| 6 | WP-G…K (this sprint) | Phase 0–3 exit |
flowchart LR
WPA[WP-A]
WPB[WP-B]
WPE[WP-E]
WPC[WP-C]
WPG[WP-G]
WPH[WP-H]
WPI[WP-I]
WPJ[WP-J]
WPK[WP-K]
WPA --> WPG
WPA --> WPK
WPB --> WPH
WPB --> WPI
WPE --> WPG
WPC --> WPK
WPA --> WPJ
WPB --> WPJ 4. Cross-link index¶
| Topic | Document | Section |
|---|---|---|
| Engine WPs A–F, Wave 0–2 | ph-db-battle-plan.md | §3 WPs, §4 waves, §10 verification |
| CI matrix, ORM layers, hosting | ph-db-ci-hosting-plan.md | §3 CI, §4 ORM, §5 hosting, §6 containers |
| Wave 3 WPs G–K | ph-db-ci-hosting-plan.md | §7 workpackages |
| Phase 0–3 exit / anti-goals | ph-db-ci-hosting-plan.md | §9 DoD, §10 anti-goals |
| PH-DB-0…10 phase IDs | ph-db-lidb-platform.md | phase table |
| Control plane migration | lidb-migration-control-plane.md | agents |
| lis db handoff | handoff-wp5-lis.md | WP-B |
| Tier registry bench | tier-db-registry-benchmark.md | WP-C, WP-K |
| R0 research seed | db-r0-vertical-seed | WP-F |
5. Phase 3 production gate checklist¶
All required before default LI_CONTROL_PLANE_STORE=lidb (ci-hosting §9):
- Phase 0: lidb + lis + agents PR CI as specified in WP-G
- Phase 1: compose or published dev image (WP-H)
- Phase 2:
lis db statushealth gate documented + CI smoke (WP-I) - Phase 3: ORM contract semver (WP-J); nightly Postgres ratio or honest
failed(WP-K) - WP-A security harness green; WP-E engine e2e todos cleared
- WP-C / PH-DB-5: measured P95 ≤ 1.2× Postgres on 3 scenarios
- Human sign-off: production store flip (separate from merge)
10. Prior-sprint WP-A…F verification (inherited)¶
Copied from ph-db-battle-plan.md §10 (2026-05-26). Wave 3 WPs G–K not yet verified.
10.1 Prior-sprint WP-A…F verification matrix¶
| WP | Repo | Branch | Tip | Tests run? | Command(s) | Result | Ready to merge? |
|---|---|---|---|---|---|---|---|
| A | lidb | cursor/wp-a-ph-db-2-engine | 7ef9509 | Yes | smoke.sh; run_tests.sh; check_no_sqlite.sh | smoke PASS; pytest 37 passed; security 5 pass, 4 skip, 1 fail; exit 1 | No |
| B | lis | cursor/wp-b-ph-db-3-lis-db | ceac11e | Yes | db-smoke.sh | PASS | Yes |
| C | benchmarks | cursor/wp-c-ph-db-5-registry-bench | fee9582 | Yes | validate-only; harness without POSTGRES_URL | validate PASS; unknown honest | No |
| D | lidb | cursor/wp-d-ph-db-4-registry | 4e34f0a | Yes | smoke; registry_smoke; run_tests | registry_smoke FAIL; 31 pass, 9 fail | No |
| D | lic | cursor/wp-d-ph-db-4-registry | (docs) | N/A | — | traceability only | N/A |
| E | li-cursor-agents | cursor/wp-e-ph-db-10-liorm | ac8c656 | Yes | npm test; e2e mock + engine | unit 293/1 skip; engine 8 pass, 2 todo | No |
| F | research-findings | cursor/wp-f-db-r0-experiments | 826285a | Yes | db-r0-1 + db-r0-4 reproduce | PASS (study-only) | Yes |
10.2 DoD gap snapshot (WP-A…F)¶
| WP | DONE (verified) | OPEN |
|---|---|---|
| A | Native smoke; pytest green; no sqlite3; liorm native path | Security parallel-race-plan-registry fail; RLS skips |
| B | lis db smoke; registry-min profile; in-process embed | Formal pytest; README sign-off |
| C | Harness path; validate-only; honest unknown | Postgres P95; PH-DB-5 ratio gate |
| D | Schema/migration work on branch | registry_smoke + 9 pytest fails; lip parity |
| E | unit + mock e2e; partial engine e2e | handoffs / control_plane_reports todos |
| F | DB-R0-1, DB-R0-4 reproduce | dashboard stays unknown until WP-C |
10.3 Human / infra still required¶
| Item | Blocks |
|---|---|
| lip OpenAPI alignment sign-off | PH-DB-4, PH-8d-v2 |
| Postgres 15+ in CI | WP-K, PH-DB-5 |
| Measured P95 ≤ 1.2× on 3 scenarios | PH-DB-5 exit |
Default LI_CONTROL_PLANE_STORE=lidb flip | Phase 3 |
| Wave 0 PR merges on lic verticals | Wave 1 start |
Changelog¶
| Date | Change |
|---|---|
| 2026-05-26 | Initial tracker: phases 0–3, WP-A…K registry, Wave 3 sprint, §10 verification cross-link |