[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_168":169,"_170":171},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_127":-5,"_20":128,"_22":129,"_130":131,"_132":133,"_25":134,"_24":-5,"_135":-5,"_136":-5,"_137":54,"_138":139,"_140":45,"_141":-5,"_142":-5,"_143":144},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","pchinjr","name","valtown_project_analytics","branchName","main","version","path","","project",{"_34":73,"_13":14,"_46":74,"_75":-5,"_76":54,"_77":78,"_79":78,"_80":81,"_82":-5,"_83":84,"_85":-5,"_86":54,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":106,"_107":108,"_109":110,"_111":54},"tree",[64,65],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":43,"_49":24,"_51":62,"_53":54,"_55":-5,"_18":63},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","2dfdce0a-2395-11f1-baa1-42dde27851f2","main.ts","fileId","2dfdceb4-2395-11f1-baa1-42dde27851f2","parentId","branchId","2df7e864-2395-11f1-baa1-42dde27851f2","branchVersion",1,"latest",true,"createdAt",["D",1773925905380],0,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/global.ts\";\n\nconst CORS_HEADERS = {\n \"access-control-allow-origin\": \"*\",\n \"access-control-allow-methods\": \"GET,POST,OPTIONS\",\n \"access-control-allow-headers\": \"content-type\",\n};\n\nlet schemaReady: Promise | null = null;\n\nfunction json(data: unknown, init: ResponseInit = {}) {\n return new Response(JSON.stringify(data, null, 2), {\n ...init,\n headers: {\n \"content-type\": \"application/json; charset=utf-8\",\n ...CORS_HEADERS,\n ...(init.headers ?? {}),\n },\n });\n}\n\nfunction html(body: string, init: ResponseInit = {}) {\n return new Response(body, {\n ...init,\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n ...CORS_HEADERS,\n ...(init.headers ?? {}),\n },\n });\n}\n\nfunction javascript(body: string, init: ResponseInit = {}) {\n return new Response(body, {\n ...init,\n headers: {\n \"content-type\": \"application/javascript; charset=utf-8\",\n \"cache-control\": \"public, max-age=300\",\n ...CORS_HEADERS,\n ...(init.headers ?? {}),\n },\n });\n}\n\nasync function ensureSchema() {\n if (!schemaReady) {\n schemaReady = (async () => {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS events (\n id TEXT PRIMARY KEY,\n project TEXT NOT NULL,\n event TEXT NOT NULL,\n session_id TEXT,\n page_path TEXT,\n page_url TEXT,\n referrer TEXT,\n source TEXT,\n user_agent TEXT,\n ts TEXT NOT NULL,\n received_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n props_json TEXT NOT NULL DEFAULT '{}'\n )\n `);\n\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_events_project_ts ON events(project, ts DESC)\");\n await sqlite.execute(\"CREATE INDEX IF NOT EXISTS idx_events_project_event_ts ON events(project, event, ts DESC)\");\n })();\n }\n\n await schemaReady;\n}\n\nfunction pageHtml(origin: string) {\n return `\n\n \n \n \n ValTown Project Analytics\n \n \n \n

ValTown Project Analytics

Reusable event ingest and browser client for lightweight analytics across multiple Val Town projects.

Endpoints

GET  /client.js\nPOST /track\nGET  /summary?project=guess-that-hype\nGET  /events?project=guess-that-hype&limit=25

Quick Start

<script src=\"${origin}/client.js\" defer></script>\n<script defer>\n  window.addEventListener(\"DOMContentLoaded\", function () {\n    const analytics = window.ValTownAnalytics.init({\n      endpoint: \"${origin}/track\",\n      project: \"my-project\",\n    });\n\n    analytics.track(\"page_ready\", { area: \"landing\" });\n  });\n</script>

\n \n`;\n}\n\nfunction clientJs(origin: string) {\n return `(function () {\n var STORAGE_KEY = \"vt_project_analytics_session_v1\";\n var state = {\n endpoint: ${JSON.stringify(origin + \"/track\")},\n project: \"\",\n globalProps: {},\n sessionId: null,\n debug: false,\n };\n\n function randomId() {\n if (window.crypto && window.crypto.randomUUID) {\n return window.crypto.randomUUID();\n }\n return \"vt-\" + Date.now().toString(36) + \"-\" + Math.random().toString(36).slice(2, 10);\n }\n\n function getSessionId() {\n if (state.sessionId) return state.sessionId;\n try {\n var existing = window.localStorage.getItem(STORAGE_KEY);\n if (existing) {\n state.sessionId = existing;\n return existing;\n }\n var created = randomId();\n window.localStorage.setItem(STORAGE_KEY, created);\n state.sessionId = created;\n return created;\n } catch (_error) {\n state.sessionId = randomId();\n return state.sessionId;\n }\n }\n\n function send(payload) {\n var body = JSON.stringify(payload);\n if (state.debug) console.log(\"[ValTownAnalytics]\", payload);\n if (navigator.sendBeacon && body.length < 60000) {\n var blob = new Blob([body], { type: \"application/json\" });\n if (navigator.sendBeacon(state.endpoint, blob)) return Promise.resolve(true);\n }\n return fetch(state.endpoint, {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: body,\n keepalive: true,\n mode: \"cors\",\n }).then(function () { return true; }).catch(function () { return false; });\n }\n\n function track(event, props) {\n if (!state.project || !event) return Promise.resolve(false);\n return send({\n project: state.project,\n event: event,\n sessionId: getSessionId(),\n pagePath: window.location.pathname,\n pageUrl: window.location.href,\n referrer: document.referrer || null,\n source: \"browser\",\n ts: new Date().toISOString(),\n props: Object.assign({}, state.globalProps, props || {}),\n });\n }\n\n window.ValTownAnalytics = {\n init: function init(config) {\n config = config || {};\n state.endpoint = config.endpoint || state.endpoint;\n state.project = config.project || state.project;\n state.globalProps = config.globalProps || {};\n state.debug = Boolean(config.debug);\n getSessionId();\n return {\n track: track,\n sessionId: function () { return getSessionId(); },\n };\n },\n track: track,\n };\n})();`;\n}\n\nfunction safeString(value: unknown, max = 255) {\n if (typeof value !== \"string\") return null;\n const trimmed = value.trim();\n if (!trimmed) return null;\n return trimmed.slice(0, max);\n}\n\nfunction safeProps(value: unknown) {\n if (!value || typeof value !== \"object\" || Array.isArray(value)) return {};\n const jsonValue = JSON.stringify(value);\n if (!jsonValue) return {};\n if (jsonValue.length <= 6000) return value;\n return { truncated: true, preview: jsonValue.slice(0, 5900) };\n}\n\nfunction eventId() {\n return crypto.randomUUID();\n}\n\nasync function ingest(req: Request) {\n await ensureSchema();\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return json({ ok: false, error: \"invalid_json\" }, { status: 400 });\n }\n\n const project = safeString(body?.project, 120);\n const event = safeString(body?.event, 120);\n if (!project || !event) {\n return json({ ok: false, error: \"project_and_event_required\" }, { status: 400 });\n }\n\n const props = safeProps(body?.props);\n await sqlite.execute({\n sql: `INSERT INTO events (\n id, project, event, session_id, page_path, page_url, referrer, source, user_agent, ts, props_json\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n eventId(),\n project,\n event,\n safeString(body?.sessionId, 120),\n safeString(body?.pagePath, 500),\n safeString(body?.pageUrl, 1000),\n safeString(body?.referrer, 1000),\n safeString(body?.source, 60),\n safeString(req.headers.get(\"user-agent\"), 500),\n safeString(body?.ts, 64) || new Date().toISOString(),\n JSON.stringify(props),\n ],\n });\n\n return json({ ok: true });\n}\n\nasync function summary(project: string) {\n await ensureSchema();\n const totals = await sqlite.execute({\n sql: `SELECT event, COUNT(*) AS count FROM events WHERE project = ? GROUP BY event ORDER BY count DESC, event ASC`,\n args: [project],\n });\n const latest = await sqlite.execute({\n sql: `SELECT ts, event, props_json FROM events WHERE project = ? ORDER BY ts DESC LIMIT 10`,\n args: [project],\n });\n const sessions = await sqlite.execute({\n sql: `SELECT COUNT(DISTINCT session_id) AS count FROM events WHERE project = ?`,\n args: [project],\n });\n\n return {\n project,\n uniqueSessions: sessions.rows?.[0]?.count ?? 0,\n events: totals.rows ?? [],\n latest: (latest.rows ?? []).map((row: any) => ({\n ts: row.ts,\n event: row.event,\n props: JSON.parse(row.props_json || \"{}\"),\n })),\n };\n}\n\nasync function recentEvents(project: string, limit: number) {\n await ensureSchema();\n const rows = await sqlite.execute({\n sql: `SELECT ts, event, session_id, page_path, props_json FROM events WHERE project = ? ORDER BY ts DESC LIMIT ?`,\n args: [project, limit],\n });\n return (rows.rows ?? []).map((row: any) => ({\n ts: row.ts,\n event: row.event,\n sessionId: row.session_id,\n pagePath: row.page_path,\n props: JSON.parse(row.props_json || \"{}\"),\n }));\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const origin = url.origin;\n\n if (req.method === \"OPTIONS\") {\n return new Response(null, { status: 204, headers: CORS_HEADERS });\n }\n\n if (req.method === \"GET\" && url.pathname === \"/\") {\n return html(pageHtml(origin));\n }\n\n if (req.method === \"GET\" && url.pathname === \"/client.js\") {\n return javascript(clientJs(origin));\n }\n\n if (req.method === \"POST\" && url.pathname === \"/track\") {\n return ingest(req);\n }\n\n if (req.method === \"GET\" && url.pathname === \"/summary\") {\n const project = safeString(url.searchParams.get(\"project\"), 120);\n if (!project) return json({ ok: false, error: \"project_required\" }, { status: 400 });\n return json(await summary(project));\n }\n\n if (req.method === \"GET\" && url.pathname === \"/events\") {\n const project = safeString(url.searchParams.get(\"project\"), 120);\n const limit = Math.min(Number(url.searchParams.get(\"limit\") || 25), 100);\n if (!project) return json({ ok: false, error: \"project_required\" }, { status: 400 });\n return json({ project, events: await recentEvents(project, limit) });\n }\n\n return json({ ok: false, error: \"not_found\" }, { status: 404 });\n}\n","deleted",false,"label",[36],"2ec9dcca-239a-11f1-972d-42dde27851f2","README.md","91baabde-2395-11f1-9eea-42dde27851f2",3,["D",1773928054187],"# ValTown Project Analytics\n\nPublic Val Town analytics service:\n- https://www.val.town/x/pchinjr/valtown_project_analytics\n\nLive service:\n- https://pchinjr--2dfdceb4239511f1baa142dde27851f2.web.val.run\n\n## Overview\n\n`valtown_project_analytics` is a reusable analytics service for lightweight event tracking across multiple Val Town projects.\n\nIt provides:\n- a browser client script you can drop into any Val Town app\n- an ingest endpoint for event writes\n- simple JSON reporting endpoints for summaries and recent events\n- shared storage using Val Town global SQLite\n\nThis is intentionally small and pragmatic. It is meant for meaningful product events, not full session replay or enterprise analytics workflows.\n\n## Routes\n\n- `GET /`\n Human-readable landing page with usage notes\n- `GET /client.js`\n Reusable browser client\n- `POST /track`\n Event ingest endpoint\n- `GET /summary?project=`\n Per-project summary with unique sessions, totals, and recent events\n- `GET /events?project=&limit=25`\n Recent per-project event stream\n- `OPTIONS *`\n CORS preflight handling\n\n## Data Model\n\nEvents are stored in a shared SQLite table named `events`.\n\nColumns:\n- `id`\n- `project`\n- `event`\n- `session_id`\n- `page_path`\n- `page_url`\n- `referrer`\n- `source`\n- `user_agent`\n- `ts`\n- `received_at`\n- `props_json`\n\nIndexes:\n- `idx_events_project_ts`\n- `idx_events_project_event_ts`\n\n## Browser Integration\n\n```html\n\n\n```\n\n## Client API\n\n`window.ValTownAnalytics.init(config)` accepts:\n- `project`\n- `endpoint` optional override\n- `globalProps` optional object merged into every event\n- `debug` optional boolean\n\nIt returns:\n- `track(event, props)`\n- `sessionId()`\n\nBehavior:\n- generates and persists a browser session id in `localStorage`\n- uses `navigator.sendBeacon` when available\n- falls back to `fetch` with `keepalive`\n\n## Event Shape\n\n```json\n{\n \"project\": \"guess-that-hype\",\n \"event\": \"quiz_started\",\n \"sessionId\": \"vt-...\",\n \"pagePath\": \"/\",\n \"pageUrl\": \"https://example.web.val.run/\",\n \"referrer\": \"https://example.com/\",\n \"source\": \"browser\",\n \"ts\": \"2026-03-19T13:00:00.000Z\",\n \"props\": {\n \"runId\": \"...\",\n \"questionsPerRun\": 8\n }\n}\n```\n\n## Recommended Metrics\n\n- `page_viewed`\n- `quiz_started`\n- `question_answered`\n- `quiz_completed`\n- `share_clicked`\n- `share_copied`\n- `cta_clicked`\n\n## Tradeoffs\n\nGood fit for:\n- custom event analytics across several Val Town projects\n- product funnels and lightweight reporting\n- simple owner-controlled instrumentation\n\nNot designed for:\n- session replay\n- identity stitching across devices\n- advanced cohort analysis\n- enterprise-scale analytics workloads\n\n## Files\n\n- `main.ts`\n Full analytics service implementation\n- `README.md`\n Project documentation\n",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":70,"_17":43,"_49":24,"_51":62,"_53":54,"_55":-5,"_67":71,"_18":72},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":66,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_67":68,"_18":69},["D",1773925905380],"children",[],[36],["D",1773928054187],[],[58],"2df77352-2395-11f1-baa1-42dde27851f2",["D",1773925905345],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Reusable analytics for Val Town apps.","imageUrl","userId","40e69d1a-3254-4858-920b-7b1449761575","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","54bae3d1-8223-41e5-b22d-81eb28a263c7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_126":122},"org",{"_11":12,"_120":-5,"_121":122,"_83":84,"_123":124,"_125":54},"branch",{"_17":60,"_13":16,"_34":41,"_112":73,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2OaSpooJk6yZ5KFqyjtIVA4z3SH.jpeg","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":73,"_13":14,"_46":164,"_75":-5,"_76":54,"_77":78,"_79":78,"_80":81,"_82":-5,"_83":84,"_85":-5,"_86":54,"_87":-5,"_88":-5,"_89":48,"_90":91,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":97,"_98":97,"_99":100,"_101":100,"_102":100,"_103":97,"_104":97,"_105":165,"_107":166,"_109":167,"_111":54},[158,159],"files",[158,159],"counts",{"_149":48,"_150":43,"_151":48,"_31":152,"_153":154},[145,146],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":43,"_49":24,"_51":62,"_53":54,"_55":-5,"_18":148},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":147},[36],[58],"pulls","branches","forks",{"_155":48,"_157":48},"connections",{"_155":48,"_156":48},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":70,"_17":43,"_49":24,"_51":62,"_53":54,"_55":-5,"_67":162,"_18":163},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":66,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_67":160,"_18":161},[],[36],[],[58],["D",1773925905345],{"_11":12,"_126":122},{"_11":12,"_120":-5,"_121":122,"_83":84,"_123":124,"_125":54},{"_17":60,"_13":16,"_34":41,"_112":73,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"ctx",{"_105":-5,"_142":201,"_202":203,"_204":205,"_206":54,"_207":54,"_208":54,"_209":45,"_210":-5,"_211":-7,"_212":-7,"_213":48,"_214":54,"_215":54,"_216":-5,"_217":54,"_218":54,"_219":54,"_220":-5},"ENV",{"_172":173,"_174":175,"_176":16,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200},"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"]

Code