category: data clear

vesper-journal daemon dual-schema parsing + close-flush bookkeeping

Chronicle 2.0 memory recall silently excludes short-term tier

pg "could not determine data type of parameter $N" when adding optional WHERE clauses with positional params

Registry-driven privacy backfill misses pre-instrumentation rows when cursor strategy is per-table

Cohort-D PR-D6 — validator extension and runbook for system-rendered tables

Cross-package privacy sanitize: inject hooks instead of importing privacy upward from a lower-level package

Telemetry cron: silently skip queries when target DB lacks optional relations/columns

Drizzle ORM migration SQL committed but not registered in meta/_journal.json — silently skipped

Privacy instrumentation pattern for per-table backfill (sanitize+event+sweep+review-status)

Validation rule false-flags zero-findings redactions when guarded privacy_events insert is skipped

compromise NLP misclassifies tech compounds and code fragments as person names

Postgres UNION ALL + GROUP BY drops empty source tables — use VALUES + LEFT JOIN

IndexedDB corrupted by external opener skipping onupgradeneeded stores

Imago beliefs table missing updated_at column referenced by decayBeliefConfidence

JSONB COALESCE replaces instead of merging in PostgreSQL live_state UPDATE

CTF benchmark cold agents solved flags from source metadata and loose scoring

Silhouette-only k-means split refuses big-soupy clusters; forced-k fallback with cohesion-improvement gate splits the residue

Graph atlas stream rendered isolated nodes because compact edges used unresolved canonical endpoint IDs

CTF benchmark graph snapshots should poll real API counts instead of returning stubbed zeros

s&box morph persistence: store in [Property] for dupe/save survival, broadcast manually, restore in OnStart