[object Object]

← back to Ventura Corridor

yolo enrichment + audit: parallel enrichers shipped 129 ad-signals, 127 headlines, 100 chamber-memberships, 196 businesses w/contacts, 17.4k ownership-classified, 55 confirmed paying advertisers. Plus migration 020 (pitches.website/instagram/li_connection_status) caught by Playwright tab audit. Score-headlines batch=5 (was 50, choking Mac1 Ollama)

d687733edf300bf875c06ad28c80f307210009ca · 2026-05-07 09:17:41 -0700 · Steve

Files touched

Diff

commit d687733edf300bf875c06ad28c80f307210009ca
Author: Steve <steve@designerwallcoverings.com>
Date:   Thu May 7 09:17:41 2026 -0700

    yolo enrichment + audit: parallel enrichers shipped 129 ad-signals, 127 headlines, 100 chamber-memberships, 196 businesses w/contacts, 17.4k ownership-classified, 55 confirmed paying advertisers. Plus migration 020 (pitches.website/instagram/li_connection_status) caught by Playwright tab audit. Score-headlines batch=5 (was 50, choking Mac1 Ollama)
---
 db/migrations/020_pitches_query_columns.sql | 12 ++++++++++++
 src/enrich/score_headlines_batch.ts         |  2 +-
 2 files changed, 13 insertions(+), 1 deletion(-)

diff --git a/db/migrations/020_pitches_query_columns.sql b/db/migrations/020_pitches_query_columns.sql
new file mode 100644
index 0000000..a63311f
--- /dev/null
+++ b/db/migrations/020_pitches_query_columns.sql
@@ -0,0 +1,12 @@
+-- Migration 020 — restore columns the /api/pitches query was already selecting.
+--
+-- Caught 2026-05-07 by the audit-tabs.cjs Playwright sweep: /pitches.html
+-- returned `column p.website does not exist` because earlier migrations 010
+-- and 019 added a subset of pitches columns but the query in
+-- src/server/index.ts also references website / instagram / li_connection_status
+-- which had no migration of their own.
+
+ALTER TABLE pitches
+  ADD COLUMN IF NOT EXISTS website              TEXT,
+  ADD COLUMN IF NOT EXISTS instagram            TEXT,
+  ADD COLUMN IF NOT EXISTS li_connection_status TEXT;
diff --git a/src/enrich/score_headlines_batch.ts b/src/enrich/score_headlines_batch.ts
index 7ee2660..8524d7a 100644
--- a/src/enrich/score_headlines_batch.ts
+++ b/src/enrich/score_headlines_batch.ts
@@ -7,7 +7,7 @@ import { query, pool } from '../../db/pool.ts';
 
 const OLLAMA = process.env.OLLAMA_HOST || 'http://192.168.1.133:11434';
 const MODEL = process.env.OLLAMA_MODEL || 'mistral:7b';
-const BATCH = 50;
+const BATCH = 5;
 
 const VOICE_LABELS = ['', 'TEMPLATE', 'FUNCTIONAL', 'SHARP', 'EXCEPTIONAL'];

← 04185a9 fix(launchd): strip broken 2>&amp;1 inline redirect from 11  ·  back to Ventura Corridor  ·  feat(news): per-business news/blog/press scraper + qwen3 sum 2422375 →