Limadata: Profile Signal

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_290":291,"_292":293},"routes/_app.x.$handle.$name",{"_95":94,"_31":43,"_103":85,"_26":97,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":57,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",131,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","selftest-data.ts","latestPath","fileId","18b0d5ac-a715-11f1-b601-1607ee4eb77e","name","fileType","script","content","// Smoke test: both dashboards' /data.json handlers run their SQL and return\n// slug-based linkedin URLs (no urn-style /in/ACo... links).\nimport network from \"./dashboard.ts\";\nimport lima from \"./dashboard-lima.ts\";\n\nconst KEY = Deno.env.get(\"FEED_TOKEN\")!;\nfor (const [name, handler] of [[\"network\", network], [\"lima\", lima]] as const) {\n const res = await handler(new Request(`https://example.test/data.json?key=${KEY}`));\n if (res.status !== 200) throw new Error(`${name}: HTTP ${res.status}`);\n const d = await res.json();\n const rows = [...(d.detections || []), ...(d.changes || [])];\n const urls = rows.map((r: any) => r.linkedin_url).filter(Boolean);\n const urnish = urls.filter((u: string) => /\\/in\\/AC[ow]/.test(u));\n if (urnish.length) throw new Error(`${name}: ${urnish.length} urn-style urls remain, e.g. ${urnish[0]}`);\n console.log(`${name}: ok — ${rows.length} rows, ${urls.length} linkedin urls, 0 urn-style`);\n}\nconsole.log(\"data.json smoke test passed\");\n","createdAt",["D",1788384447548],"branchVersion","branchId","c987e021-bdd4-47b4-ac1b-6394d01f439a","id","6f48da3c-9820-44c4-a98d-da86a8d32458","raw-payload-webhook",["D",1788273667302],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Raw webhook landing: jsonb into Railway Postgres","imageUrl","a9bbe31c-d4b2-41f1-8950-ffb2490d13ff","pinnedFileId","31548dfe-a613-11f1-9ed1-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f9680-ede1-71fd-8189-f4ace7fc6bd1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":97},"org",{"_95":94,"_96":97,"_98":97,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"isOwned",145,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","androo","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_31":43,"_36":286,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":287,"_79":288,"_81":289,"_83":24},"tree",[237,238,239,240,241,242,243,244,245,246,247,248],"files",[237,238,239,240,241,242,243,244,245,246,247,248],"counts",{"_226":61,"_227":191,"_228":61,"_229":230,"_231":232},"contents",[124,125,126,127,128,129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":219,"_31":220,"_29":221,"_139":-5,"_39":40,"_38":222,"_141":57,"_36":223,"_13":183,"_32":20,"_34":224,"_23":24,"_145":-5,"_26":225},{"_41":211,"_31":212,"_29":213,"_139":-5,"_39":40,"_38":214,"_141":57,"_36":215,"_13":216,"_32":192,"_34":217,"_23":24,"_145":-5,"_26":218},{"_41":203,"_31":204,"_29":205,"_139":-5,"_39":40,"_38":206,"_141":24,"_36":207,"_13":208,"_32":20,"_34":209,"_23":24,"_145":-5,"_26":210},{"_41":195,"_31":196,"_29":197,"_139":-5,"_39":40,"_38":198,"_141":24,"_36":199,"_13":200,"_32":192,"_34":201,"_23":24,"_145":-5,"_26":202},{"_41":187,"_31":188,"_29":55,"_139":-5,"_39":40,"_38":189,"_141":57,"_36":190,"_13":191,"_32":192,"_34":193,"_23":24,"_145":-5,"_26":194},{"_41":178,"_31":179,"_29":180,"_139":-5,"_39":40,"_38":181,"_141":24,"_36":182,"_13":183,"_32":184,"_34":185,"_23":24,"_145":-5,"_26":186},{"_41":171,"_31":172,"_29":173,"_139":-5,"_39":40,"_38":174,"_141":57,"_36":175,"_13":61,"_32":33,"_34":176,"_23":24,"_145":-5,"_26":177},{"_41":164,"_31":165,"_29":166,"_139":-5,"_39":40,"_38":167,"_141":57,"_36":168,"_13":61,"_32":33,"_34":169,"_23":24,"_145":-5,"_26":170},{"_41":161,"_31":27,"_29":30,"_139":-5,"_39":40,"_38":14,"_141":57,"_36":162,"_13":61,"_32":33,"_34":35,"_23":24,"_145":-5,"_26":163},{"_41":154,"_31":155,"_29":156,"_139":-5,"_39":40,"_38":157,"_141":57,"_36":158,"_13":61,"_32":33,"_34":159,"_23":24,"_145":-5,"_26":160},{"_41":147,"_31":148,"_29":149,"_139":-5,"_39":40,"_38":150,"_141":57,"_36":151,"_13":61,"_32":33,"_34":152,"_23":24,"_145":-5,"_26":153},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":57,"_36":142,"_13":143,"_32":33,"_34":144,"_23":24,"_145":-5,"_26":146},"cd210d48-f836-4062-9669-5f793a4d3485","selftest-ui.ts","766281c8-a63e-11f1-8c17-1607ee4eb77e","parentId",93,"latest",["D",1788378557981],10,"// Dev smoke test for the dashboard HTML scripts: runs each page's \n\n\n",[204],"81ee6874-c25f-480e-a30b-51acd7db14a0","dashboard-lima.ts","560e1cec-a63a-11f1-80d0-1607ee4eb77e",130,["D",1788384415311],11,"// Limadata signal dashboard: the vendor-comparison twin of dashboard.ts, scoped to\n// vendor='limadata' rows in the shared Layer 2 tables (people/profile_changes).\n// Limadata has no company tracker, so there are no detections here; the change feed\n// is capped at the latest 6000 rows (~100k total) — stats always cover everything.\n// Read-gated by the same FEED_TOKEN (?key=).\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport postgres from \"npm:postgres\";\n\nconst sql = postgres(Deno.env.get(\"DATABASE_URL\")!, {\n max: 1,\n idle_timeout: 20,\n connect_timeout: 10,\n});\n\n// values go to the browser as real JSON (not truncated jsonb::text) so the UI can\n// render word-level diffs; prune caps long strings and drops image/logo noise\nconst STRIP = new Set([\"logo_url\", \"all_images\", \"profile_url\"]);\nfunction prune(v: any, top = true): any {\n if (typeof v === \"string\") {\n const cap = top ? 1500 : 400;\n return v.length > cap ? v.slice(0, cap) + \" …\" : v;\n }\n if (Array.isArray(v)) return v.slice(0, 12).map((x) => prune(x, false));\n if (v && typeof v === \"object\") {\n const out: Record = {};\n for (const [k, val] of Object.entries(v)) {\n if (STRIP.has(k)) continue;\n out[k] = prune(val, false);\n }\n return out;\n }\n return v;\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const token = Deno.env.get(\"FEED_TOKEN\") ?? \"\";\n if (!token || url.searchParams.get(\"key\") !== token) {\n return new Response(\"forbidden\", { status: 403 });\n }\n\n if (url.pathname.endsWith(\"/data.json\")) {\n const [stats] = await sql`select\n (select count(*) from thenetwork.people where vendor = 'limadata')::int as people,\n (select count(distinct company_hint) from thenetwork.profile_changes\n where vendor = 'limadata' and company_hint is not null)::int as companies,\n (select count(*) from thenetwork.profile_changes where vendor = 'limadata' and not noise)::int as changes,\n (select count(*) from thenetwork.profile_changes where vendor = 'limadata' and noise)::int as noise,\n (select count(*) from thenetwork.raw_payloads where vendor = 'limadata')::int as payloads,\n (select max(observed_on) from thenetwork.profile_changes where vendor = 'limadata' and not noise)::text as latest_observed,\n (select max(received_at) from thenetwork.raw_payloads where vendor = 'limadata') as latest_delivery,\n (select count(*) from thenetwork.raw_payloads\n where vendor = 'limadata' and processed_at is null and processing_error is null)::int as pending,\n (select count(*) from thenetwork.raw_payloads\n where vendor = 'limadata' and processing_error is not null)::int as errors,\n (select payload->'watch'->>'name' from thenetwork.raw_payloads\n where vendor = 'limadata' and payload ? 'watch' order by id desc limit 1) as watch_name`;\n\n const sections = await sql`\n select coalesce(section, '(none)') as section, count(*)::int as n\n from thenetwork.profile_changes where vendor = 'limadata' and not noise\n group by 1 order by n desc`;\n\n // company_hint holds Limadata's numeric linkedin company id; resolve names via\n // the companies table (populated from payload snapshot experiences)\n const by_company = await sql`\n select coalesce(co.name, ch.company_hint) as company, count(*)::int as n\n from thenetwork.profile_changes ch\n left join thenetwork.companies co\n on co.vendor = 'limadata' and co.linkedin_company_id = ch.company_hint\n where ch.vendor = 'limadata' and not ch.noise and ch.company_hint is not null\n group by 1 order by n desc limit 14`;\n\n const payloads = await sql`\n select id::text, received_at, payload->'data'->'after'->>'full_name' as person,\n processed_at, processing_error, length(payload::text)::int as bytes\n from thenetwork.raw_payloads\n where vendor = 'limadata'\n order by id desc limit 20`;\n\n const changes = await sql`\n select ch.observed_on::text, ch.detected_at, ch.section,\n coalesce(co.name, ch.company_hint) as company_hint,\n ch.field_path, ch.change_type, ch.previous_value, ch.current_value,\n p.name, p.category as person_category, p.location,\n case when p.public_identifier is not null\n then 'https://www.linkedin.com/in/' || p.public_identifier\n else p.linkedin_url end as linkedin_url\n from thenetwork.profile_changes ch\n join thenetwork.people p using (entity_id)\n left join thenetwork.companies co\n on co.vendor = 'limadata' and co.linkedin_company_id = ch.company_hint\n where ch.vendor = 'limadata' and not ch.noise\n order by ch.detected_at desc nulls last, ch.id desc\n limit 6000`;\n\n return Response.json({\n generated_at: new Date().toISOString(),\n stats,\n sections,\n by_company,\n payloads,\n changes: changes.map((c: any) => ({\n ...c,\n previous_value: prune(c.previous_value),\n current_value: prune(c.current_value),\n })),\n });\n }\n\n return new Response(await readFile(\"/dashboard-lima.html\", import.meta.url), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n}\n",[212],"d90a10c9-0968-4e71-9170-e675a214197c","dashboard-lima.html","7d0ade66-a63a-11f1-9ecb-1607ee4eb77e",108,["D",1788379333604],"\n\n\n\n\nLimadata: Profile Signal\n\n\n

Loading signal data…

\n\n\n\n",[220],"pulls","branches","forks","envVars",{"_233":235,"_236":61},"connections",{"_233":61,"_234":61},"count","unfilledCount",4,"emptyCount",{"_41":219,"_31":220,"_29":221,"_139":-5,"_39":40,"_38":222,"_141":57,"_36":283,"_13":183,"_32":20,"_34":224,"_23":24,"_145":-5,"_250":284,"_26":285},{"_41":211,"_31":212,"_29":213,"_139":-5,"_39":40,"_38":214,"_141":57,"_36":280,"_13":216,"_32":192,"_34":217,"_23":24,"_145":-5,"_250":281,"_26":282},{"_41":203,"_31":204,"_29":205,"_139":-5,"_39":40,"_38":206,"_141":24,"_36":277,"_13":208,"_32":20,"_34":209,"_23":24,"_145":-5,"_250":278,"_26":279},{"_41":195,"_31":196,"_29":197,"_139":-5,"_39":40,"_38":198,"_141":24,"_36":274,"_13":200,"_32":192,"_34":201,"_23":24,"_145":-5,"_250":275,"_26":276},{"_41":187,"_31":188,"_29":55,"_139":-5,"_39":40,"_38":189,"_141":57,"_36":271,"_13":191,"_32":192,"_34":193,"_23":24,"_145":-5,"_250":272,"_26":273},{"_41":178,"_31":179,"_29":180,"_139":-5,"_39":40,"_38":181,"_141":24,"_36":268,"_13":183,"_32":184,"_34":185,"_23":24,"_145":-5,"_250":269,"_26":270},{"_41":171,"_31":172,"_29":173,"_139":-5,"_39":40,"_38":174,"_141":57,"_36":265,"_13":61,"_32":33,"_34":176,"_23":24,"_145":-5,"_250":266,"_26":267},{"_41":164,"_31":165,"_29":166,"_139":-5,"_39":40,"_38":167,"_141":57,"_36":262,"_13":61,"_32":33,"_34":169,"_23":24,"_145":-5,"_250":263,"_26":264},{"_41":161,"_31":27,"_29":30,"_139":-5,"_39":40,"_38":14,"_141":57,"_36":259,"_13":61,"_32":33,"_34":35,"_23":24,"_145":-5,"_250":260,"_26":261},{"_41":154,"_31":155,"_29":156,"_139":-5,"_39":40,"_38":157,"_141":57,"_36":256,"_13":61,"_32":33,"_34":159,"_23":24,"_145":-5,"_250":257,"_26":258},{"_41":147,"_31":148,"_29":149,"_139":-5,"_39":40,"_38":150,"_141":57,"_36":253,"_13":61,"_32":33,"_34":152,"_23":24,"_145":-5,"_250":254,"_26":255},{"_41":136,"_31":137,"_29":138,"_139":-5,"_39":40,"_38":140,"_141":57,"_36":249,"_13":143,"_32":33,"_34":144,"_23":24,"_145":-5,"_250":251,"_26":252},["D",1788378557981],"children",[],[137],["D",1788378137760],[],[148],["D",1788296086727],[],[155],["D",1788384447548],[],[27],["D",1788381362561],[],[165],["D",1788381861334],[],[172],["D",1788362754103],[],[179],["D",1788275057394],[],[188],["D",1788384398373],[],[196],["D",1788383487766],[],[204],["D",1788384415311],[],[212],["D",1788379333604],[],[220],["D",1788273667302],{"_95":94,"_102":97},{"_95":94,"_96":97,"_98":97,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_41":40,"_86":42,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":43,"_93":94},"ctx",{"_77":-5,"_121":323,"_324":325,"_326":327,"_328":24,"_329":24,"_330":24,"_331":57,"_332":-5,"_333":-7,"_334":-7,"_335":61,"_336":24,"_337":24,"_338":-5,"_339":24,"_340":24,"_341":24,"_342":-5},"ENV",{"_294":295,"_296":297,"_298":85,"_299":300,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v131