This is a point-in-time record of the week of 2026-03-16 to 2026-03-22. It was written from the repository's history for that week and is not revised afterwards, so later pages may supersede what it says.

Week of 2026-03-16 to 2026-03-22

Window: 2026-03-16 00:00:00 to 2026-03-22 23:59:59, local author time Recapped: 2026-08-30 Commits in window: 95 (77 non-merge, 18 merges)

This is a backfill written 161 days after the window closed. It is an unusually active week: the measured commit-body/stat read was about 18.5k tokens. The repository gained its first planning index while the running system expanded from a scraper pipeline into an operated data product with an admin UI, dashboard, asynchronous jobs, health signals and installation support.

What shipped

The week's opening commits established the operating surface. d512157 implemented Plan 11's validated search-config admin UI, moved legacy state views into dbt, expanded intermediate and mart models, and introduced docs/PLANS.md. 683ef1d delivered Plan 10's durability controls: stale-run termination, stuck-artifact recovery, a pipeline_errors table and a shared Error Handler workflow. The completed-plan ledger records why these controls mattered: automated work needed explicit recovery and an inspectable failure path rather than permanently running rows.

The analytics surface followed. Plan 9 moved from Metabase query notes to a four-section Streamlit dashboard in 8ba5bbf; Plan 12 added dealer extraction and propagated dealer identity into marts; Plans 15, 18 and 20 added Telegram alerts, active-run progress, refresh controls, dbt timings, Postgres sessions and lock visibility. The dashboard was repeatedly corrected so rotation, freshness, inventory and unlisted metrics described the intended target set rather than all observations in the raw tables.

Plans 6, 18 and 19 changed orchestration. 45cc84e, e60ae34 and 9fd997c moved SRP work behind an asynchronous job API and n8n Job Poller, expanded the worker pool, and added orphan/failed-job recovery. a486889 prevented detail scrapes from overlapping search/detail runs, while c071b3e exposed progress counts. Follow-up fixes ensured a zero-pending poll still emitted a row, separated schedules, tracked jobs with working credentials, and stopped a newly requested run from blocking its own rotation guard.

Data correctness and cost became explicit plan work. Plans 14 and 22 removed orphan dbt models and centralized staleness configuration. Plans 24 and 25 re-queued dealer-unenriched vehicles, carried numeric customer_id through detail observations and repaired the dealer join. Plans 26, 27 and 32 added slot-based discovery, failure-rate alerts and a force-stale detail pool. Plan 37 repaired carousel URLs and VIN validation, mapped carousel discoveries back to VINs, filtered them to configured make/model targets and included their earliest observations in days-on-market.

The unattributed anti-detection and performance commits still shipped material work. The scraper moved from Playwright to Patchright with rotating Chrome fingerprints, ZIPs, viewports, pacing and page order. dbt staging models became incremental, on-target filtering reached both marts and the dashboard, slow view joins were removed, and detail batches were capped at 1,500 VINs to fit the half-hour operating window. Plan 23 also supplied a schema dump, environment template, setup script and seed config, while Plan 17 rewrote the README around the system that now existed.

What moved between states

The planning index was created and revised 35 times during the window. Its net historical state placed Plans 0–4, 6–13, 15, 17–23, 26, 28, 31, 32 and 37 directly into the in-index archive from an absent pre-index state. This is a bootstrap of the new planning record as well as a record of work completed during the week; it should not be read as 26 independent state transitions from backlog through build.

What is still owed

Plan 24 shipped in 0377460 but never appeared in docs/PLANS.md at any revision. That was a historical filing defect. As of 2026-08-30, the completed-plan ledger has recovered Plan 24, Plan 6 and the other work implicated here. No planning-state edit is owed today.

Several technical threads continued into the next week: dbt materialization, parallel detail claiming, workflow import, dashboard decomposition and admin operations. They are not treated as unfinished omissions here because their subsequent commits belong to the next recap.

Unattributed commits

Forty-two non-merge commits name at least one plan in their subject or body. For denominator reconciliation, they are:

d512157 Plans 0–11 roadmap; Plan 11 admin UI
683ef1d Plan 10
84c066f Plan 9
c6bfaf5 Plan 9
d667c31 Plan 12
4f3ec83 Plan 12
5959dbc Plans 9, 14 and 15
f496f03 Plans 14, 15 and 16
16b28de Plan 16
45cc84e Plan 6
e60ae34 Plan 6
9fd997c Plan 6
a486889 Plan 19
c071b3e Plan 18
d432d11 Plans 14 and 22
b4b7abe Plan 22
c7ffbb4 Plans 17 and 23
759d2ba Plan 23
a33be62 Plan 23
0377460 Plan 24
72fb6e9 Plan 25
1fbe940 Plan 25
9dc84ae Plan 25
c81ec78 Plan 26
b37b1d3 Plan 26
5fbdd49 Plans 15 and 27
5b4f90e Plan 20
56db0ca Plan 26
096139f Plan 25
795fcc1 Plan 26
b1bb006 Plan 27
dda97b7 Plan 27
7e49fab Plan 32
988bdf6 Plan 25
1429b2b Plans 28 and 31
ef1f4fc Plans 25–34
e52cdea Plan 35
f8ad64e Plan 36
13153e4 Plan 37
2f3cac1 Plan 37
bc675da Plan 37
ca12121 Plan 37

The other 35 are unattributed and are still part of the week's shipped work:

d2086bf Fix listing_state inference, drop legacy tables, refresh Metabase queries
8ba5bbf Add Streamlit dashboard, dealer pipeline, dbt incremental optimization
4064848 docs: clean up PLANS.md — move completed items to table, slim detail sections
f0db5b2 Clean up PLANS.md — trim completed detail sections, fix numbering
517961b Fix Job Poller: Check Pending Jobs always returns a row when all done
64f94aa Update n8n workflow exports — Job Poller fix, detail scrape timing
cc84d00 Dashboard: add full_details_stale series to price freshness chart
fc70904 Fix ops_vehicle_staleness accepted_values test — add dealer_unenriched
928ceec Fix dealer_unenriched check — use EXISTS on detail_observations instead of dealers.street
e44aedb Add search scrape success rate chart to Pipeline Health dashboard
9adcb2b Fix carousel parsing — cars.com renamed spark-* components to fuse-*
b0b2ee8 Fix SRP parser: support fuse-card alongside spark-card
1a188e0 Optimize dealer_name lookup in mart_deal_scores — CTE instead of LATERAL
694788f Optimize dbt build: 2min → 45s, mart_deal_scores 75s → 8s
75273e6 Fix detail scrape gate blocking on error artifacts
aad50ed Fix Error Handler SQL injection on error messages with multiple single quotes
6bd4855 Fix search scrape pipeline: scrape_jobs INSERT + remove phantom Mark Run Done
f42edc6 Fix search scrape rotation firing too often + detail scrape orphan recovery
035c332 Update PLANS.md: mark 25.2, 25.3, 28, 31 done
0a8c60f Add search scrape rotation schedule to Pipeline Health tab
4a7db9f Redesign Pipeline Health top section into two summary tables
41a90cb Fix rotation schedule: scope artifact counts to slot's search keys
f982e7d Fix rotation self-blocking and filter invalid VINs from detail_observations
24c53b0 Fix scrape job tracking and broken DB credentials in scraper
019308f Fixing some logic holes
6176fd4 Code review fixes + extract vehicle attributes from detail pages
31c8cac SRP anti-detection: Patchright, ZIP rotation, fingerprint profiles, human pacing, random page order
32e6c2f Dashboard: add processor activity section; Job Poller: aggregate error alerts
2edce6b Add scrape_targets seed + filter carousel hints by make AND model; include detail-only VINs in active listings
9f0a1a1 Dashboard: filter all queries to on-target scrape targets only
cb6510e Dashboard: filter all queries to on-target scrape targets only
4f3ef5f Filter mart_vehicle_snapshot to on-target scrape targets only
a5c1419 Materialize staging views as incremental tables
fe053d9 Cap detail scrape batch size to 1500 VINs (~15 min at 100/min)
3c9d63d Dashboard: eliminate int_vehicle_attributes view joins for performance

Merges

34df4cb names Plans 25.2 and 25.3. The other merge branches do not name a plan; merges are listed but not recapped.

Deferred to the next recap

1,254 commits sit after this window's end as of 2026-08-30.

git rev-list --count --all --since='2026-03-22 23:59:59'   # 1254

That raw tail includes the following backfilled week and every later week through the current partial week. The week ending March 29 is covered in this batch, and the existing series covers March 30 through August 23. No following complete week is genuinely uncovered; the week ending August 30 is in progress.