`, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_363":364,"_365":366},"routes/_app.x.$handle.$name",{"_107":106,"_38":52,"_115":97,"_33":116,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_26":-5,"_127":-5,"_128":-5,"_129":31,"_130":131,"_132":66,"_133":-5,"_134":-5,"_135":136},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_50":51,"_38":52,"_45":53,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":78,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":90,"_91":92,"_93":94,"_95":31},"version",33,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","735176c0-7384-4a9c-a4ed-f8b6b3904eaa","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":39,"_40":41,"_42":44,"_45":46,"_47":14,"_48":49,"_30":31},"previous",{"_36":37,"_38":39,"_40":41,"_42":43},"deleted",false,"deletedHere","path","lib/store.ts","latestPath","fileId","7352bd2e-a7b3-11f1-8441-1607ee4eb77e","name","store.ts","fileType","script","content","// lib/store.ts\n// Persistence for DLX Designs verified leads.\n//\n// The val's project-scoped SQLite database is the authoritative store — it\n// works with zero configuration and is isolated to this val. If SUPABASE_URL\n// and SUPABASE_SERVICE_ROLE_KEY are set, every insert is ALSO mirrored to a\n// Supabase `dlx_verified_leads` table via PostgREST (see database/schema.sql\n// to create that table). Supabase is strictly optional; nothing breaks if\n// those env vars are absent.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Lead {\n id: string;\n name: string;\n gmail: string;\n score: number;\n source: string;\n signal: string;\n created_at: string;\n}\n\nexport async function initDb(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS dlx_verified_leads (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n gmail TEXT NOT NULL UNIQUE,\n score INTEGER NOT NULL DEFAULT 0,\n source TEXT NOT NULL DEFAULT '',\n signal TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n}\n\n/** Insert a verified lead. Returns null when the email already exists. */\nexport async function insertLead(\n lead: Omit,\n): Promise {\n await initDb();\n const row: Lead = {\n id: crypto.randomUUID(),\n created_at: new Date().toISOString(),\n ...lead,\n };\n try {\n await sqlite.execute({\n sql: `INSERT INTO dlx_verified_leads\n (id, name, gmail, score, source, signal, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.id,\n row.name,\n row.gmail,\n row.score,\n row.source,\n row.signal,\n row.created_at,\n ],\n });\n } catch (err) {\n if (String((err as Error)?.message ?? err).includes(\"UNIQUE\")) {\n return null; // duplicate gmail — already verified, no double entry\n }\n throw err;\n }\n await mirrorToSupabase(row);\n return row;\n}\n\nexport async function listLeads(limit = 100): Promise {\n await initDb();\n const res = await sqlite.execute(\n `SELECT * FROM dlx_verified_leads ORDER BY created_at DESC LIMIT ?`,\n [limit],\n );\n return res.rows as unknown as Lead[];\n}\n\nasync function mirrorToSupabase(lead: Lead): Promise {\n const url = Deno.env.get(\"SUPABASE_URL\");\n const key = Deno.env.get(\"SUPABASE_SERVICE_ROLE_KEY\");\n if (!url || !key) return; // Supabase not configured — native store is authoritative\n try {\n const res = await fetch(\n `${url.replace(/\\/$/, \"\")}/rest/v1/dlx_verified_leads`,\n {\n method: \"POST\",\n headers: {\n apikey: key,\n Authorization: `Bearer ${key}`,\n \"Content-Type\": \"application/json\",\n Prefer: \"resolution=merge-duplicates\",\n },\n body: JSON.stringify({\n id: lead.id,\n name: lead.name,\n gmail: lead.gmail,\n score: lead.score,\n source: lead.source,\n signal: lead.signal,\n created_at: lead.created_at,\n }),\n },\n );\n if (!res.ok) {\n console.error(\"Supabase mirror HTTP\", res.status, await res.text());\n }\n } catch (err) {\n console.error(\"Supabase mirror failed:\", err);\n }\n}\n","// lib/store.ts\n// Persistence for DLX Designs verified leads — the growth engine's store.\n//\n// The val's project-scoped SQLite database is the authoritative store (zero\n// config, isolated to this val). If SUPABASE_URL + SUPABASE_SERVICE_ROLE_KEY\n// are set, every insert is ALSO mirrored to a Supabase `dlx_verified_leads`\n// table. Supabase is strictly optional.\n//\n// Every record carries evidence: where it came from (source/source_url), what\n// was said (evidence = raw inquiry), and when (captured_at). No information is\n// ever invented.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { STAGES } from \"../backend/pipeline.ts\";\n\nexport interface Lead {\n id: string;\n name: string;\n gmail: string;\n phone: string;\n score: number; // 0..100\n source: string;\n source_url: string;\n evidence: string; // raw inquiry / provenance text\n signal: string; // buying signal summary\n action: string; // recommended next action\n status: string; // pipeline stage (see STAGES)\n history: StageEvent[]; // stage-transition trail\n created_at: string;\n updated_at: string;\n}\n\nexport interface StageEvent {\n from: string;\n to: string;\n at: string;\n note?: string;\n}\n\nexport async function initDb(): Promise {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS dlx_verified_leads (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n gmail TEXT NOT NULL UNIQUE,\n phone TEXT NOT NULL DEFAULT '',\n score INTEGER NOT NULL DEFAULT 0,\n source TEXT NOT NULL DEFAULT '',\n source_url TEXT NOT NULL DEFAULT '',\n evidence TEXT NOT NULL DEFAULT '',\n signal TEXT NOT NULL DEFAULT '',\n action TEXT NOT NULL DEFAULT '',\n status TEXT NOT NULL DEFAULT 'new',\n history TEXT NOT NULL DEFAULT '[]',\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`);\n // Migrations for pre-existing tables (idempotent)\n await ensureColumn(\"phone\", \"TEXT NOT NULL DEFAULT ''\");\n await ensureColumn(\"source_url\", \"TEXT NOT NULL DEFAULT ''\");\n await ensureColumn(\"evidence\", \"TEXT NOT NULL DEFAULT ''\");\n await ensureColumn(\"action\", \"TEXT NOT NULL DEFAULT ''\");\n await ensureColumn(\"status\", \"TEXT NOT NULL DEFAULT 'new'\");\n await ensureColumn(\"history\", \"TEXT NOT NULL DEFAULT '[]'\");\n await ensureColumn(\"updated_at\", \"TEXT NOT NULL DEFAULT (datetime('now'))\");\n}\n\nasync function ensureColumn(column: string, ddl: string): Promise {\n try {\n await sqlite.execute(`ALTER TABLE dlx_verified_leads ADD COLUMN ${column} ${ddl}`);\n } catch {\n /* column already exists — safe to ignore */\n }\n}\n\nexport type LeadSeed = Omit;\n\n/** Insert a genuinely-captured, already-qualified lead. Null on duplicate gmail. */\nexport async function insertLead(seed: LeadSeed): Promise {\n await initDb();\n const now = new Date().toISOString();\n const row: Lead = {\n id: crypto.randomUUID(),\n created_at: now,\n updated_at: now,\n history: [],\n ...seed,\n };\n try {\n await sqlite.execute({\n sql: `INSERT INTO dlx_verified_leads\n (id, name, gmail, phone, score, source, source_url, evidence, signal,\n action, status, history, created_at, updated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n row.id, row.name, row.gmail, row.phone, row.score, row.source,\n row.source_url, row.evidence, row.signal, row.action,\n row.status, JSON.stringify(row.history), row.created_at, row.updated_at,\n ],\n });\n } catch (err) {\n if (String((err as Error)?.message ?? err).includes(\"UNIQUE\")) {\n return null; // duplicate gmail\n }\n throw err;\n }\n await mirrorToSupabase(row);\n return row;\n}\n\nexport async function listLeads(limit = 200): Promise {\n await initDb();\n const res = await sqlite.execute(\n `SELECT * FROM dlx_verified_leads ORDER BY score DESC, created_at DESC LIMIT ?`,\n [limit],\n );\n return (res.rows as Record[]).map((r) => hydrate(r));\n}\n\nexport async function getLead(id: string): Promise {\n await initDb();\n const res = await sqlite.execute(\n `SELECT * FROM dlx_verified_leads WHERE id = ?`,\n [id],\n );\n const row = res.rows[0] as Record | undefined;\n return row ? hydrate(row) : null;\n}\n\n/**\n * Move a lead to the next pipeline stage (or any valid stage). Records a\n * history event so the business can learn which stages convert.\n */\nexport async function setLeadStatus(\n id: string,\n to: string,\n note?: string,\n): Promise {\n await initDb();\n const target = to.toLowerCase().replace(/ /g, \"_\");\n if (!STAGES.includes(target)) {\n throw new Error(`Invalid stage '${to}'. Allowed: ${STAGES.join(\", \")}`);\n }\n const lead = await getLead(id);\n if (!lead) return null;\n\n const at = new Date().toISOString();\n const event: StageEvent = {\n from: lead.status,\n to: target,\n at,\n note: note?.slice(0, 300),\n };\n const history = [...lead.history, event];\n await sqlite.execute(\n `UPDATE dlx_verified_leads SET status = ?, history = ?, updated_at = ? WHERE id = ?`,\n [target, JSON.stringify(history), at, id],\n );\n return { ...lead, status: target, history, updated_at: at };\n}\n\n// --- Analytics / learn ----------------------------------------------------\nexport interface StageCount {\n status: string;\n count: number;\n}\n\nexport async function stageDistribution(): Promise {\n await initDb();\n const res = await sqlite.execute(\n `SELECT status, COUNT(*) AS count FROM dlx_verified_leads GROUP BY status`,\n );\n return STAGES.map((s) => {\n const found = (res.rows as Record[]).find(\n (r) => r.status === s,\n );\n return { status: s, count: found ? Number(found.count) : 0 };\n });\n}\n\nexport async function topSources(limit = 6): Promise<{ source: string; count: number }[]> {\n await initDb();\n const res = await sqlite.execute(\n `SELECT source, COUNT(*) AS count, AVG(score) AS avg_score\n FROM dlx_verified_leads GROUP BY source ORDER BY count DESC LIMIT ?`,\n [limit],\n );\n return (res.rows as Record[]).map((r) => ({\n source: String(r.source || \"inbound-form\"),\n count: Number(r.count),\n }));\n}\n\nexport async function topSignals(limit = 6): Promise<{ signal: string; count: number }[]> {\n await initDb();\n const res = await sqlite.execute(\n `SELECT signal, COUNT(*) AS count FROM dlx_verified_leads\n GROUP BY signal ORDER BY count DESC LIMIT ?`,\n [limit],\n );\n return (res.rows as Record[]).map((r) => ({\n signal: String(r.signal),\n count: Number(r.count),\n }));\n}\n\nfunction hydrate(r: Record): Lead {\n let history: StageEvent[] = [];\n try {\n history = JSON.parse(String(r.history ?? \"[]\"));\n } catch {\n history = [];\n }\n return {\n id: String(r.id),\n name: String(r.name),\n gmail: String(r.gmail),\n phone: String(r.phone ?? \"\"),\n score: Number(r.score ?? 0),\n source: String(r.source ?? \"\"),\n source_url: String(r.source_url ?? \"\"),\n evidence: String(r.evidence ?? \"\"),\n signal: String(r.signal ?? \"\"),\n action: String(r.action ?? \"\"),\n status: String(r.status ?? \"new\"),\n history,\n created_at: String(r.created_at ?? \"\"),\n updated_at: String(r.updated_at ?? \"\"),\n };\n}\n\nasync function mirrorToSupabase(lead: Lead): Promise {\n const url = Deno.env.get(\"SUPABASE_URL\");\n const key = Deno.env.get(\"SUPABASE_SERVICE_ROLE_KEY\");\n if (!url || !key) return;\n try {\n const res = await fetch(\n `${url.replace(/\\/$/, \"\")}/rest/v1/dlx_verified_leads`,\n {\n method: \"POST\",\n headers: {\n apikey: key,\n Authorization: `Bearer ${key}`,\n \"Content-Type\": \"application/json\",\n Prefer: \"resolution=merge-duplicates\",\n },\n body: JSON.stringify({\n id: lead.id,\n name: lead.name,\n gmail: lead.gmail,\n phone: lead.phone,\n score: lead.score,\n source: lead.source,\n source_url: lead.source_url,\n evidence: lead.evidence,\n signal: lead.signal,\n action: lead.action,\n status: lead.status,\n created_at: lead.created_at,\n updated_at: lead.updated_at,\n }),\n },\n );\n if (!res.ok) {\n console.error(\"Supabase mirror HTTP\", res.status, await res.text());\n }\n } catch (err) {\n console.error(\"Supabase mirror failed:\", err);\n }\n}\n","createdAt",["D",1788493707488],"branchVersion","branchId","faea9245-6732-47d9-a1a2-3550998bc296","id","d2f8de76-3d02-4949-8a06-2f7cc759dae3","dlx-lead-engine",["D",1788452396724],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","DLX Designs lead qualification engine + React dashboard","imageUrl","0e434874-725d-4e49-bc72-a0c364fc943f","pinnedFileId","01a06811-df40-730d-85ee-1ae96a373bd7","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a04e8e-cc2d-73ad-9a1b-036254519f63","tursoName","d2f8de763d0249498a062f7cc759dae3","tursoHostname","d2f8de763d0249498a062f7cc759dae3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_107":106,"_114":-5},"org",{"_107":106,"_108":109,"_110":-5,"_19":-5,"_111":112,"_113":31},"branch",{"_13":96,"_38":97,"_50":49,"_98":51,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":-5,"_104":52,"_105":106},"isOwned",88,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dlxdesigns","handle","displayName","DLXdesigns ","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_50":51,"_38":52,"_45":358,"_54":-5,"_55":31,"_56":57,"_58":57,"_59":60,"_61":-5,"_19":62,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":70,"_71":72,"_73":74,"_75":76,"_77":359,"_79":-5,"_80":81,"_82":81,"_83":84,"_85":84,"_86":84,"_87":81,"_88":81,"_89":360,"_91":361,"_93":362,"_95":31},"tree",[211,216,218,226,228,230,231,232],"files",[211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232],"counts",{"_201":70,"_202":151,"_203":70,"_204":205,"_206":207},"contents",[137,138,139,140,141,142,143,144],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_50":195,"_38":196,"_36":197,"_147":-5,"_48":49,"_47":198,"_149":66,"_45":199,"_13":70,"_40":176,"_42":-5,"_30":31,"_154":-5,"_33":200},{"_50":189,"_38":190,"_36":191,"_147":-5,"_48":49,"_47":192,"_149":66,"_45":193,"_13":70,"_40":176,"_42":-5,"_30":31,"_154":-5,"_33":194},{"_50":184,"_38":185,"_36":186,"_147":-5,"_48":49,"_47":151,"_149":66,"_45":187,"_13":70,"_40":176,"_42":-5,"_30":31,"_154":-5,"_33":188},{"_50":178,"_38":179,"_36":180,"_147":-5,"_48":49,"_47":181,"_149":66,"_45":182,"_13":70,"_40":176,"_42":-5,"_30":31,"_154":-5,"_33":183},{"_50":171,"_38":172,"_36":173,"_147":-5,"_48":49,"_47":174,"_149":66,"_45":175,"_13":70,"_40":176,"_42":-5,"_30":31,"_154":-5,"_33":177},{"_50":165,"_38":166,"_36":167,"_147":-5,"_48":49,"_47":151,"_149":66,"_45":168,"_13":70,"_40":26,"_42":169,"_30":31,"_154":-5,"_33":170},{"_50":157,"_38":158,"_36":159,"_147":-5,"_48":49,"_47":160,"_149":31,"_45":161,"_13":162,"_40":26,"_42":163,"_30":31,"_154":-5,"_33":164},{"_50":145,"_38":146,"_36":64,"_147":-5,"_48":49,"_47":148,"_149":31,"_45":150,"_13":151,"_40":152,"_42":153,"_30":31,"_154":155,"_33":156},"c0b01d16-809e-482d-9020-a394b90d1b17","index.ts","parentId",9,"latest",["D",1788452717401],1,"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport { listLeads } from \"./lib/store.ts\";\nimport { ingestLead } from \"./backend/worker/ingest.ts\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root and as the dashboard\napp.get(\"/\", (c) => c.html(Root()));\napp.get(\"/dashboard\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// --- Lead API -----------------------------------------------------------\n\n// GET verified (already-qualified) leads for the dashboard\napp.get(\"/api/leads\", async (c) => {\n const leads = await listLeads(100);\n return c.json(leads);\n});\n\n// POST an inbound lead: { name, gmail, message, source }\n// Runs the strict qualification engine. Only high-intent leads are stored;\n// budget seekers and duplicates are rejected (422) and never persisted.\napp.post(\"/api/ingest\", async (c) => {\n const body = await c.req.json().catch(() => undefined);\n const outcome = await ingestLead((body as object) ?? {});\n return c.json(outcome, outcome.decision === \"reject\" ? 422 : 201);\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","label","dlx-leads",[146],"672f2da4-3b61-4b97-823b-a4dc275a39f2","README.md","01a06811-df40-730d-85ee-161b7548ebf9",32,["D",1788493439215],11,"# DLX Designs · Verified Lead Intelligence Engine\n\nProduction-ready lead-generation and **strict qualification** engine for DLX\nDesigns — a luxury bespoke traditional menswear brand targeting high-net-worth\nclients, grooms and corporate executives in Lagos & Abeokuta, Nigeria.\n\nIt ingests real inbound traffic, filters out low-budget seekers with strict\nsemantic rules, stores only verified high-intent leads, and renders them as\nscored lead cards in a live dashboard.\n\n> **Live dashboard:** [Try the app](url:index.ts)\n> **Ingest endpoint:** `POST /api/ingest`\n\n## Architecture\n\n```mermaid\ngraph LR\n Inbound[\"Web form / corridor
(blog, IG, ads)\"] -->|\"POST /api/ingest\"| Qual[\"Qualifier
backend/worker/qualifier.ts\"]\n Qual -->|\"hard reject\"| X[\"Low budget → dropped
never stored\"]\n Qual -->|\"optional\"| LLM[\"AI refine
(free tier, optional)\"]\n Qual -->|\"pass ≥ 50\"| Store[\"SQLite store
lib/store.ts\"]\n Store -->|\"optional mirror\"| Supabase[\"Supabase
dlx_verified_leads\"]\n Store -->|\"GET /api/leads\"| UI[\"React dashboard
frontend/\"]\n```\n\n- **Dashboard:** client-side React + Hono backend (App Router-equivalent), Twind/Tailwind styling.\n- **Database:** val-scoped PostgreSQL-compatible SQLite. **Supabase mirror optional.**\n- **Qualifier:** deterministic heuristic (zero-config) + optional free-tier AI refinement.\n\n## The strict qualification engine\n\nRuns in `backend/worker/qualifier.ts` and never fabricates data.\n\n**Layer 1 — hard disqualifiers (instant reject):** `cheap`, `affordable`,\n`under 20k`/`20k`, `discount`, `thrift`, `okirika`.\n\n**Layer 2 — scoring matrix (0–100):** baseline 25, high-tier signals add points —\n`bespoke` +18, `groom`/`chieftaincy` +20, `cashmere` +15, `wedding` +14,\n`3-piece` +12, `executive` +14, `lekki`/`victoria island` +10, `lagos`/`abeokuta`\n+6, etc. **Pass threshold: ≥ 50.** Sub-threshold leads are rejected.\n\n**Layer 3 — AI refinement (optional, zero-config by default):** the engine is\n**deterministic-first** — the strict heuristic above is authoritative and needs\n**no AI key, no external call, no cost**, so no provider can ever block it. If\nyou add a free-tier key, that provider refines the score and writes a natural\nbuying signal (tried in order: `GEMINI_API_KEY`, `GROQ_API_KEY`, `OPENAI_API_KEY`).\nA provider failing just falls back to the heuristic — never an error.\n\n### Endpoints\n\n| Method | Path | Purpose |\n| --- | --- | --- |\n| `GET` | `/` | Dashboard |\n| `GET` | `/dashboard` | Dashboard (alias) |\n| `GET` | `/api/leads` | Verified leads (JSON) |\n| `POST` | `/api/ingest` | Ingest & qualify an inbound lead — 201 on pass, 422 on reject |\n\n`POST /api/ingest` request body:\n\n```json\n{\n \"name\": \"Oluwatosin Adeyemi\",\n \"gmail\": \"tosin@example.com\",\n \"source\": \"nigerianmenswear.com\",\n \"message\": \"I need a bespoke 3-piece groom suit for my chieftaincy ceremony in Abeokuta\"\n}\n```\n\nOnly passing leads persist. Rejected and duplicate leads are returned (422) and\nnever stored.\n\n## Configuration (environment variables)\n\nEverything runs out of the box with **zero environment variables**. The\nqualification engine is fully deterministic. The following optional keys unlock\nthe AI refinement layer (free tiers are preferred — none require billing) and\nthe Supabase mirror:\n\n- **`GEMINI_API_KEY`** — free tier (Google AI Studio key, no card required). Recommended.\n- **`GROQ_API_KEY`** — free tier. Ignored unless Gemini is absent or fails.\n- **`OPENAI_API_KEY`** — requires active OpenAI billing; only used as a last resort.\n- **`SUPABASE_URL`** + **`SUPABASE_SERVICE_ROLE_KEY`** — mirror verified leads to\n your Supabase `dlx_verified_leads` table (native SQLite store stays authoritative).\n\n👉 Add GEMINI_API_KEY here: https://www.val.town/x/dlxdesigns/dlx-lead-engine/environment-variables?key=GEMINI_API_KEY\n👉 Add GROQ_API_KEY here: https://www.val.town/x/dlxdesigns/dlx-lead-engine/environment-variables?key=GROQ_API_KEY\n👉 Add OPENAI_API_KEY here: https://www.val.town/x/dlxdesigns/dlx-lead-engine/environment-variables?key=OPENAI_API_KEY\n👉 Add SUPABASE_URL here: https://www.val.town/x/dlxdesigns/dlx-lead-engine/environment-variables?key=SUPABASE_URL\n👉 Add SUPABASE_SERVICE_ROLE_KEY here: https://www.val.town/x/dlxdesigns/dlx-lead-engine/environment-variables?key=SUPABASE_SERVICE_ROLE_KEY\n\n### Supabase setup (optional)\n\nCreate the mirror table by running [`database/schema.sql`](database/schema.sql)\nin the Supabase SQL editor. The table uses `gen_random_uuid()` ids, enforces a\n`score BETWEEN 0 AND 100` check, has a `gmail UNIQUE` constraint, and enables\nRow-Level Security (locked to service-role access by default). The val writes\nvia PostgREST with the service-role key and `resolution=merge-duplicates`.\n\n## File structure\n\n```\ndatabase/\n schema.sql ← Supabase/PostgreSQL schema (mirror table)\nbackend/worker/\n qualifier.ts ← strict qualification engine (disqualifiers + scoring)\n ingest.ts ← ingest worker (bridge inbound → store)\n llm.ts ← optional AI adapter (free tier Gemini / Groq / OpenAI)\nlib/\n store.ts ← SQLite persistence + Supabase mirror\nfrontend/\n components/App.tsx ← dashboard layout + empty state\n components/LeadCard.tsx ← individual verified-lead card\nscripts/\n selftest.ts ← end-to-end qualifier + store self-test\nindex.ts ← Hono HTTP backend (dashboard + /api/*)\n```\n\n## Integrity guarantees\n\n- **No hardcoded, fake, or mock contacts anywhere.** Every record comes from a\n real `POST /api/ingest` submission that passed strict qualification.\n- Empty store → dashboard shows *“Awaiting live inbound high-intent signals…”*,\n never fake cards.\n- Duplicate emails are rejected (UNIQUE), budget seekers are dropped, sub-50\n intent is dropped.\n\n## Running the self-test\n\n`scripts/selftest.ts` exercises the full pipeline with synthetic example inputs\n(high-intent pass, low-budget reject, no-signal reject, duplicate reject) and is\nsafe to run repeatedly.\n",[158],"a130fa68-e89b-4e79-b351-ae119f51052e","CHANGELOG.md","01a06811-df40-730d-85ee-12df63d9ba38",["D",1788452396724],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v33