Bun/Node one-shot script hangs after main() returns when sharing imports with a long-running service
Edit calls silently lost when concurrent agents share a git worktree on different branches
Cleanup-script table registry pattern: parallel-subagent worktree-isolation lesson
Drizzle migration .sql file exists but `_journal.json` not updated → CI applies nothing, integration tests fail
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
Neon pooler resets search_path → Drizzle queries fail with "relation does not exist"
isReplayableMigration misclassifies BEGIN/COMMIT-wrapped migrations as destructive
Postgres UNION ALL + GROUP BY drops empty source tables — use VALUES + LEFT JOIN
Use Drizzle migrate:safe (baseline + drift heal + drizzle-kit migrate) instead of raw psql loop in CI deploy
Bash cutover verification scripts exited early under set -e despite successful checks
TypeScript strictFunctionTypes rejected a narrowed PostgreSQL notification callback parameter
Agent self-verification pattern eliminates human ping-pong debugging
IndexedDB corrupted by external opener skipping onupgradeneeded stores
Node.js pg module defaults to TCP — SASL auth failure on local Postgres with peer auth
Imago beliefs table missing updated_at column referenced by decayBeliefConfidence
Memory ingestion batch aborted on one failed extracted event and Postgres partitions were only created at migration time
Tailscale Serve returned 502 because gateway bound only to tailnet IP while Serve proxied loopback