`, 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",{"_440":441,"_442":443},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_110":91,"_27":105,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":60,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",23,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/db.ts","latestPath","fileId","196d739e-afbf-11f1-bca7-1607ee4eb77e","name","db.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { type EventItem, isCategory, type ScrapedEvent, type SourceStatus } from \"../shared/types.ts\";\nimport { addDays, dedupKey, warsawToday } from \"./normalize.ts\";\n\nconst EVENTS = \"cwz_events\";\nconst SOURCES = \"cwz_sources\";\nconst PUSH = \"cwz_push\";\nconst LLM_CACHE = \"cwz_llm_cache\";\nconst LOGIN_FAILS = \"cwz_login_fails\";\nconst META = \"cwz_meta\";\n\nconst DAY_MS = 24 * 60 * 60 * 1000;\n\nexport async function initDb() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS ${EVENTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n dedup_key TEXT NOT NULL UNIQUE,\n title TEXT NOT NULL,\n date TEXT NOT NULL,\n end_date TEXT,\n time TEXT,\n place TEXT,\n town TEXT NOT NULL,\n category TEXT NOT NULL,\n price TEXT,\n image_url TEXT,\n url TEXT,\n description TEXT,\n showtimes TEXT,\n sources TEXT NOT NULL DEFAULT '[]',\n priority INTEGER NOT NULL DEFAULT 0,\n manual INTEGER NOT NULL DEFAULT 0,\n hidden INTEGER NOT NULL DEFAULT 0,\n first_seen INTEGER NOT NULL,\n last_seen INTEGER NOT NULL\n )`,\n args: [],\n },\n { sql: `CREATE INDEX IF NOT EXISTS cwz_events_date ON ${EVENTS} (date)`, args: [] },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${SOURCES} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n last_run INTEGER,\n last_ok INTEGER,\n last_error TEXT,\n last_count INTEGER NOT NULL DEFAULT 0,\n prev_count INTEGER NOT NULL DEFAULT 0\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${PUSH} (\n endpoint TEXT PRIMARY KEY,\n p256dh TEXT NOT NULL,\n auth TEXT NOT NULL,\n favorites TEXT NOT NULL DEFAULT '[]',\n created_at INTEGER NOT NULL\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${LLM_CACHE} (hash TEXT PRIMARY KEY, result TEXT NOT NULL, created_at INTEGER NOT NULL)`,\n args: [],\n },\n { sql: `CREATE TABLE IF NOT EXISTS ${LOGIN_FAILS} (ip TEXT NOT NULL, at INTEGER NOT NULL)`, args: [] },\n { sql: `CREATE TABLE IF NOT EXISTS ${META} (key TEXT PRIMARY KEY, value TEXT)`, args: [] },\n ]);\n}\n\n// ---------- events ----------\n\nconst COLUMNS =\n \"id, title, date, end_date, time, place, town, category, price, image_url, url, description, showtimes, sources, manual\";\n\nfunction parseJson(value: unknown, fallback: T): T {\n try {\n return value == null ? fallback : JSON.parse(String(value));\n } catch {\n return fallback;\n }\n}\n\nfunction toEvent(r: Record): EventItem {\n const str = (v: unknown) => (v == null ? null : String(v));\n return {\n id: Number(r.id),\n title: String(r.title),\n date: String(r.date),\n endDate: str(r.end_date),\n time: str(r.time),\n place: str(r.place),\n town: String(r.town),\n category: isCategory(r.category) ? r.category : \"inne\",\n price: str(r.price),\n imageUrl: str(r.image_url),\n url: str(r.url),\n description: str(r.description),\n sources: parseJson(r.sources, []),\n manual: Number(r.manual) === 1,\n showtimes: parseJson(r.showtimes, null),\n };\n}\n\n// Events happening on any day in [from, to], including multi-day ones that started earlier\nexport async function listEvents(from: string, to: string): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT ${COLUMNS} FROM ${EVENTS}\n WHERE hidden = 0 AND date <= ? AND COALESCE(end_date, date) >= ?\n ORDER BY date, COALESCE(time, '00:00'), title`,\n args: [to, from],\n });\n return rows.map(toEvent);\n}\n\nexport async function getEvent(id: number): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT ${COLUMNS} FROM ${EVENTS} WHERE id = ?`, args: [id] });\n return rows[0] ? toEvent(rows[0]) : null;\n}\n\nexport async function getEventsByIds(ids: number[]): Promise {\n if (ids.length === 0) return [];\n const { rows } = await sqlite.execute({\n sql: `SELECT ${COLUMNS} FROM ${EVENTS} WHERE hidden = 0 AND id IN (${ids.map(() => \"?\").join(\", \")})`,\n args: ids,\n });\n return rows.map(toEvent);\n}\n\ntype FieldRow = Record;\n\nconst FIELDS: [keyof ScrapedEvent, string][] = [\n [\"title\", \"title\"],\n [\"endDate\", \"end_date\"],\n [\"time\", \"time\"],\n [\"place\", \"place\"],\n [\"town\", \"town\"],\n [\"category\", \"category\"],\n [\"price\", \"price\"],\n [\"imageUrl\", \"image_url\"],\n [\"url\", \"url\"],\n [\"description\", \"description\"],\n [\"showtimes\", \"showtimes\"],\n];\n\nconst dbValue = (v: unknown) => (v == null ? null : typeof v === \"object\" ? JSON.stringify(v) : v);\n\n/**\n * Stores events from one source. The same event seen on several sites is merged:\n * a source with higher priority overwrites fields, a lower one only fills gaps.\n */\nexport async function upsertEvents(sourceId: string, priority: number, events: ScrapedEvent[], manual = false) {\n const unique = new Map();\n for (const e of events) unique.set(dedupKey(e.title, e.date), e);\n if (unique.size === 0) return 0;\n\n const keys = [...unique.keys()];\n const existing = new Map();\n for (let i = 0; i < keys.length; i += 200) {\n const chunk = keys.slice(i, i + 200);\n const { rows } = await sqlite.execute({\n sql: `SELECT * FROM ${EVENTS} WHERE dedup_key IN (${chunk.map(() => \"?\").join(\", \")})`,\n args: chunk,\n });\n for (const r of rows) existing.set(String(r.dedup_key), r);\n }\n\n // The same event worded differently on another site: same day, compatible time, mostly the same words\n const missing = [...unique].filter(([key]) => !existing.has(key));\n if (missing.length) {\n const dates = [...new Set(missing.map(([, e]) => e.date))];\n const { rows } = await sqlite.execute({\n sql: `SELECT * FROM ${EVENTS} WHERE date IN (${dates.map(() => \"?\").join(\", \")})`,\n args: dates,\n });\n for (const [key, e] of missing) {\n const match = rows.find((r) =>\n r.date === e.date &&\n !(r.category === \"kino\" && e.category === \"kino\") &&\n (r.time == null || e.time == null || r.time === e.time) &&\n similarTitles(String(r.title), e.title)\n );\n if (match) existing.set(key, match);\n }\n }\n\n const now = Date.now();\n const statements = [];\n for (const [key, e] of unique) {\n const row = existing.get(key);\n if (!row) {\n statements.push({\n sql: `INSERT INTO ${EVENTS} (dedup_key, date, sources, priority, manual, first_seen, last_seen,\n ${FIELDS.map(([, c]) => c).join(\", \")})\n VALUES (?, ?, ?, ?, ?, ?, ?, ${FIELDS.map(() => \"?\").join(\", \")})`,\n args: [key, e.date, JSON.stringify([sourceId]), priority, manual ? 1 : 0, now, now,\n ...FIELDS.map(([f]) => dbValue(e[f]))],\n });\n continue;\n }\n const wins = priority >= Number(row.priority);\n const sets: string[] = [];\n const args: unknown[] = [];\n for (const [field, column] of FIELDS) {\n const value = dbValue(e[field]);\n if (value == null) continue;\n if (wins || row[column] == null) {\n sets.push(`${column} = ?`);\n args.push(value);\n }\n }\n const sources = parseJson(row.sources, []);\n if (!sources.includes(sourceId)) sources.push(sourceId);\n sets.push(\"sources = ?\", \"last_seen = ?\", \"priority = ?\");\n args.push(JSON.stringify(sources), now, Math.max(priority, Number(row.priority)));\n statements.push({ sql: `UPDATE ${EVENTS} SET ${sets.join(\", \")} WHERE id = ?`, args: [...args, row.id] });\n }\n\n for (let i = 0; i < statements.length; i += 50) {\n await sqlite.batch(statements.slice(i, i + 50) as { sql: string; args: never[] }[]);\n }\n return unique.size;\n}\n\nexport async function hideEvent(id: number) {\n await sqlite.execute({ sql: `UPDATE ${EVENTS} SET hidden = 1 WHERE id = ?`, args: [id] });\n}\n\n// Past events are of no use; multi-day ones stay until their last day has passed\nexport async function pruneOldEvents() {\n const cutoff = addDays(warsawToday(), -2);\n await sqlite.execute({ sql: `DELETE FROM ${EVENTS} WHERE COALESCE(end_date, date) < ?`, args: [cutoff] });\n}\n\n// Seen by the source before, but gone from it for a while: cancelled or moved\nexport async function dropVanished(sourceId: string, runStartedAt: number) {\n const today = warsawToday();\n await sqlite.execute({\n sql: `DELETE FROM ${EVENTS}\n WHERE manual = 0 AND sources = ? AND last_seen < ? AND date >= ?`,\n args: [JSON.stringify([sourceId]), runStartedAt - 2 * DAY_MS, today],\n });\n}\n\n// URLs already known for a source, so detail pages are fetched only once\nexport async function knownUrls(prefix: string): Promise> {\n const { rows } = await sqlite.execute({\n sql: `SELECT url FROM ${EVENTS} WHERE url LIKE ? AND time IS NOT NULL`,\n args: [`${prefix}%`],\n });\n return new Set(rows.map((r) => String(r.url)));\n}\n\n// ---------- sources ----------\n\nexport async function recordSourceRun(id: string, name: string, result: { count: number } | { error: string }) {\n const now = Date.now();\n if (\"error\" in result) {\n await sqlite.execute({\n sql: `INSERT INTO ${SOURCES} (id, name, last_run, last_error) VALUES (?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET name = excluded.name, last_run = excluded.last_run, last_error = excluded.last_error`,\n args: [id, name, now, result.error.slice(0, 500)],\n });\n } else {\n await sqlite.execute({\n sql: `INSERT INTO ${SOURCES} (id, name, last_run, last_ok, last_error, last_count, prev_count)\n VALUES (?, ?, ?, ?, NULL, ?, 0)\n ON CONFLICT(id) DO UPDATE SET name = excluded.name, last_run = excluded.last_run, last_ok = excluded.last_ok,\n last_error = NULL, prev_count = ${SOURCES}.last_count, last_count = excluded.last_count`,\n args: [id, name, now, now, result.count],\n });\n }\n}\n\nexport async function listSources(): Promise {\n const { rows } = await sqlite.execute(`SELECT * FROM ${SOURCES} ORDER BY id`);\n return rows.map((r) => ({\n id: String(r.id),\n name: String(r.name),\n lastRun: r.last_run == null ? null : Number(r.last_run),\n lastOk: r.last_ok == null ? null : Number(r.last_ok),\n lastError: r.last_error == null ? null : String(r.last_error),\n lastCount: Number(r.last_count),\n prevCount: Number(r.prev_count),\n }));\n}\n\n// ---------- meta ----------\n\nexport async function setMeta(key: string, value: string) {\n await sqlite.execute({\n sql: `INSERT INTO ${META} (key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n });\n}\n\nexport async function getMeta(key: string): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT value FROM ${META} WHERE key = ?`, args: [key] });\n return rows[0]?.value == null ? null : String(rows[0].value);\n}\n\n// ---------- LLM cache ----------\n\nexport async function getCached(hash: string): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT result FROM ${LLM_CACHE} WHERE hash = ?`, args: [hash] });\n return rows[0] ? String(rows[0].result) : null;\n}\n\nexport async function setCached(hash: string, result: string) {\n const now = Date.now();\n await sqlite.batch([\n { sql: `DELETE FROM ${LLM_CACHE} WHERE created_at < ?`, args: [now - 30 * DAY_MS] },\n {\n sql: `INSERT INTO ${LLM_CACHE} (hash, result, created_at) VALUES (?, ?, ?)\n ON CONFLICT(hash) DO UPDATE SET result = excluded.result, created_at = excluded.created_at`,\n args: [hash, result, now],\n },\n ]);\n}\n\n// ---------- push subscriptions ----------\n\nexport interface PushRow {\n endpoint: string;\n p256dh: string;\n auth: string;\n favorites: number[];\n}\n\nexport async function saveSubscription(endpoint: string, p256dh: string, auth: string, favorites: number[]) {\n await sqlite.execute({\n sql: `INSERT INTO ${PUSH} (endpoint, p256dh, auth, favorites, created_at) VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(endpoint) DO UPDATE SET p256dh = excluded.p256dh, auth = excluded.auth, favorites = excluded.favorites`,\n args: [endpoint, p256dh, auth, JSON.stringify(favorites), Date.now()],\n });\n}\n\nexport async function deleteSubscription(endpoint: string) {\n await sqlite.execute({ sql: `DELETE FROM ${PUSH} WHERE endpoint = ?`, args: [endpoint] });\n}\n\nexport async function allSubscriptions(): Promise {\n const { rows } = await sqlite.execute(`SELECT endpoint, p256dh, auth, favorites FROM ${PUSH}`);\n return rows.map((r) => ({\n endpoint: String(r.endpoint),\n p256dh: String(r.p256dh),\n auth: String(r.auth),\n favorites: parseJson(r.favorites, []),\n }));\n}\n\n// ---------- PIN attempts ----------\n\nexport async function countLoginFails(ip: string, since: number) {\n const { rows } = await sqlite.execute({\n sql: `SELECT COUNT(*) AS total, COALESCE(SUM(CASE WHEN ip = ? THEN 1 ELSE 0 END), 0) AS mine\n FROM ${LOGIN_FAILS} WHERE at >= ?`,\n args: [ip, since],\n });\n return { total: Number(rows[0]?.total ?? 0), mine: Number(rows[0]?.mine ?? 0) };\n}\n\nexport async function recordLoginFail(ip: string) {\n const now = Date.now();\n await sqlite.batch([\n { sql: `DELETE FROM ${LOGIN_FAILS} WHERE at < ?`, args: [now - DAY_MS] },\n { sql: `INSERT INTO ${LOGIN_FAILS} (ip, at) VALUES (?, ?)`, args: [ip, now] },\n ]);\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { type EventItem, isCategory, type ScrapedEvent, type SourceStatus } from \"../shared/types.ts\";\nimport { addDays, dedupKey, similarTitles, warsawToday } from \"./normalize.ts\";\n\nconst EVENTS = \"cwz_events\";\nconst SOURCES = \"cwz_sources\";\nconst PUSH = \"cwz_push\";\nconst LLM_CACHE = \"cwz_llm_cache\";\nconst LOGIN_FAILS = \"cwz_login_fails\";\nconst META = \"cwz_meta\";\n\nconst DAY_MS = 24 * 60 * 60 * 1000;\n\nexport async function initDb() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS ${EVENTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n dedup_key TEXT NOT NULL UNIQUE,\n title TEXT NOT NULL,\n date TEXT NOT NULL,\n end_date TEXT,\n time TEXT,\n place TEXT,\n town TEXT NOT NULL,\n category TEXT NOT NULL,\n price TEXT,\n image_url TEXT,\n url TEXT,\n description TEXT,\n showtimes TEXT,\n sources TEXT NOT NULL DEFAULT '[]',\n priority INTEGER NOT NULL DEFAULT 0,\n manual INTEGER NOT NULL DEFAULT 0,\n hidden INTEGER NOT NULL DEFAULT 0,\n first_seen INTEGER NOT NULL,\n last_seen INTEGER NOT NULL\n )`,\n args: [],\n },\n { sql: `CREATE INDEX IF NOT EXISTS cwz_events_date ON ${EVENTS} (date)`, args: [] },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${SOURCES} (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n last_run INTEGER,\n last_ok INTEGER,\n last_error TEXT,\n last_count INTEGER NOT NULL DEFAULT 0,\n prev_count INTEGER NOT NULL DEFAULT 0\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${PUSH} (\n endpoint TEXT PRIMARY KEY,\n p256dh TEXT NOT NULL,\n auth TEXT NOT NULL,\n favorites TEXT NOT NULL DEFAULT '[]',\n created_at INTEGER NOT NULL\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS ${LLM_CACHE} (hash TEXT PRIMARY KEY, result TEXT NOT NULL, created_at INTEGER NOT NULL)`,\n args: [],\n },\n { sql: `CREATE TABLE IF NOT EXISTS ${LOGIN_FAILS} (ip TEXT NOT NULL, at INTEGER NOT NULL)`, args: [] },\n { sql: `CREATE TABLE IF NOT EXISTS ${META} (key TEXT PRIMARY KEY, value TEXT)`, args: [] },\n ]);\n}\n\n// ---------- events ----------\n\nconst COLUMNS =\n \"id, title, date, end_date, time, place, town, category, price, image_url, url, description, showtimes, sources, manual\";\n\nfunction parseJson(value: unknown, fallback: T): T {\n try {\n return value == null ? fallback : JSON.parse(String(value));\n } catch {\n return fallback;\n }\n}\n\nfunction toEvent(r: Record): EventItem {\n const str = (v: unknown) => (v == null ? null : String(v));\n return {\n id: Number(r.id),\n title: String(r.title),\n date: String(r.date),\n endDate: str(r.end_date),\n time: str(r.time),\n place: str(r.place),\n town: String(r.town),\n category: isCategory(r.category) ? r.category : \"inne\",\n price: str(r.price),\n imageUrl: str(r.image_url),\n url: str(r.url),\n description: str(r.description),\n sources: parseJson(r.sources, []),\n manual: Number(r.manual) === 1,\n showtimes: parseJson(r.showtimes, null),\n };\n}\n\n// Events happening on any day in [from, to], including multi-day ones that started earlier\nexport async function listEvents(from: string, to: string): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT ${COLUMNS} FROM ${EVENTS}\n WHERE hidden = 0 AND date <= ? AND COALESCE(end_date, date) >= ?\n ORDER BY date, COALESCE(time, '00:00'), title`,\n args: [to, from],\n });\n return rows.map(toEvent);\n}\n\nexport async function getEvent(id: number): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT ${COLUMNS} FROM ${EVENTS} WHERE id = ?`, args: [id] });\n return rows[0] ? toEvent(rows[0]) : null;\n}\n\nexport async function getEventsByIds(ids: number[]): Promise {\n if (ids.length === 0) return [];\n const { rows } = await sqlite.execute({\n sql: `SELECT ${COLUMNS} FROM ${EVENTS} WHERE hidden = 0 AND id IN (${ids.map(() => \"?\").join(\", \")})`,\n args: ids,\n });\n return rows.map(toEvent);\n}\n\ntype FieldRow = Record;\n\nconst FIELDS: [keyof ScrapedEvent, string][] = [\n [\"title\", \"title\"],\n [\"endDate\", \"end_date\"],\n [\"time\", \"time\"],\n [\"place\", \"place\"],\n [\"town\", \"town\"],\n [\"category\", \"category\"],\n [\"price\", \"price\"],\n [\"imageUrl\", \"image_url\"],\n [\"url\", \"url\"],\n [\"description\", \"description\"],\n [\"showtimes\", \"showtimes\"],\n];\n\nconst dbValue = (v: unknown) => (v == null ? null : typeof v === \"object\" ? JSON.stringify(v) : v);\n\n/**\n * Stores events from one source. The same event seen on several sites is merged:\n * a source with higher priority overwrites fields, a lower one only fills gaps.\n */\nexport async function upsertEvents(sourceId: string, priority: number, events: ScrapedEvent[], manual = false) {\n const unique = new Map();\n for (const e of events) unique.set(dedupKey(e.title, e.date), e);\n if (unique.size === 0) return 0;\n\n const keys = [...unique.keys()];\n const existing = new Map();\n for (let i = 0; i < keys.length; i += 200) {\n const chunk = keys.slice(i, i + 200);\n const { rows } = await sqlite.execute({\n sql: `SELECT * FROM ${EVENTS} WHERE dedup_key IN (${chunk.map(() => \"?\").join(\", \")})`,\n args: chunk,\n });\n for (const r of rows) existing.set(String(r.dedup_key), r);\n }\n\n // The same event worded differently on another site: same day, compatible time, mostly the same words\n const missing = [...unique].filter(([key]) => !existing.has(key));\n if (missing.length) {\n const dates = [...new Set(missing.map(([, e]) => e.date))];\n const { rows } = await sqlite.execute({\n sql: `SELECT * FROM ${EVENTS} WHERE date IN (${dates.map(() => \"?\").join(\", \")})`,\n args: dates,\n });\n for (const [key, e] of missing) {\n const match = rows.find((r) =>\n r.date === e.date &&\n !(r.category === \"kino\" && e.category === \"kino\") &&\n (r.time == null || e.time == null || r.time === e.time) &&\n similarTitles(String(r.title), e.title)\n );\n if (match) existing.set(key, match);\n }\n }\n\n const now = Date.now();\n const statements = [];\n for (const [key, e] of unique) {\n const row = existing.get(key);\n if (!row) {\n statements.push({\n sql: `INSERT INTO ${EVENTS} (dedup_key, date, sources, priority, manual, first_seen, last_seen,\n ${FIELDS.map(([, c]) => c).join(\", \")})\n VALUES (?, ?, ?, ?, ?, ?, ?, ${FIELDS.map(() => \"?\").join(\", \")})`,\n args: [key, e.date, JSON.stringify([sourceId]), priority, manual ? 1 : 0, now, now,\n ...FIELDS.map(([f]) => dbValue(e[f]))],\n });\n continue;\n }\n const wins = priority >= Number(row.priority);\n const sets: string[] = [];\n const args: unknown[] = [];\n for (const [field, column] of FIELDS) {\n const value = dbValue(e[field]);\n if (value == null) continue;\n if (wins || row[column] == null) {\n sets.push(`${column} = ?`);\n args.push(value);\n }\n }\n const sources = parseJson(row.sources, []);\n if (!sources.includes(sourceId)) sources.push(sourceId);\n sets.push(\"sources = ?\", \"last_seen = ?\", \"priority = ?\");\n args.push(JSON.stringify(sources), now, Math.max(priority, Number(row.priority)));\n statements.push({ sql: `UPDATE ${EVENTS} SET ${sets.join(\", \")} WHERE id = ?`, args: [...args, row.id] });\n }\n\n for (let i = 0; i < statements.length; i += 50) {\n await sqlite.batch(statements.slice(i, i + 50) as { sql: string; args: never[] }[]);\n }\n return unique.size;\n}\n\nexport async function hideEvent(id: number) {\n await sqlite.execute({ sql: `UPDATE ${EVENTS} SET hidden = 1 WHERE id = ?`, args: [id] });\n}\n\n// Past events are of no use; multi-day ones stay until their last day has passed\nexport async function pruneOldEvents() {\n const cutoff = addDays(warsawToday(), -2);\n await sqlite.execute({ sql: `DELETE FROM ${EVENTS} WHERE COALESCE(end_date, date) < ?`, args: [cutoff] });\n}\n\n// Seen by the source before, but gone from it for a while: cancelled or moved\nexport async function dropVanished(sourceId: string, runStartedAt: number) {\n const today = warsawToday();\n await sqlite.execute({\n sql: `DELETE FROM ${EVENTS}\n WHERE manual = 0 AND sources = ? AND last_seen < ? AND date >= ?`,\n args: [JSON.stringify([sourceId]), runStartedAt - 2 * DAY_MS, today],\n });\n}\n\n// URLs already known for a source, so detail pages are fetched only once\nexport async function knownUrls(prefix: string): Promise> {\n const { rows } = await sqlite.execute({\n sql: `SELECT url FROM ${EVENTS} WHERE url LIKE ? AND time IS NOT NULL`,\n args: [`${prefix}%`],\n });\n return new Set(rows.map((r) => String(r.url)));\n}\n\n// ---------- sources ----------\n\nexport async function recordSourceRun(id: string, name: string, result: { count: number } | { error: string }) {\n const now = Date.now();\n if (\"error\" in result) {\n await sqlite.execute({\n sql: `INSERT INTO ${SOURCES} (id, name, last_run, last_error) VALUES (?, ?, ?, ?)\n ON CONFLICT(id) DO UPDATE SET name = excluded.name, last_run = excluded.last_run, last_error = excluded.last_error`,\n args: [id, name, now, result.error.slice(0, 500)],\n });\n } else {\n await sqlite.execute({\n sql: `INSERT INTO ${SOURCES} (id, name, last_run, last_ok, last_error, last_count, prev_count)\n VALUES (?, ?, ?, ?, NULL, ?, 0)\n ON CONFLICT(id) DO UPDATE SET name = excluded.name, last_run = excluded.last_run, last_ok = excluded.last_ok,\n last_error = NULL, prev_count = ${SOURCES}.last_count, last_count = excluded.last_count`,\n args: [id, name, now, now, result.count],\n });\n }\n}\n\nexport async function listSources(): Promise {\n const { rows } = await sqlite.execute(`SELECT * FROM ${SOURCES} ORDER BY id`);\n return rows.map((r) => ({\n id: String(r.id),\n name: String(r.name),\n lastRun: r.last_run == null ? null : Number(r.last_run),\n lastOk: r.last_ok == null ? null : Number(r.last_ok),\n lastError: r.last_error == null ? null : String(r.last_error),\n lastCount: Number(r.last_count),\n prevCount: Number(r.prev_count),\n }));\n}\n\n// ---------- meta ----------\n\nexport async function setMeta(key: string, value: string) {\n await sqlite.execute({\n sql: `INSERT INTO ${META} (key, value) VALUES (?, ?) ON CONFLICT(key) DO UPDATE SET value = excluded.value`,\n args: [key, value],\n });\n}\n\nexport async function getMeta(key: string): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT value FROM ${META} WHERE key = ?`, args: [key] });\n return rows[0]?.value == null ? null : String(rows[0].value);\n}\n\n// ---------- LLM cache ----------\n\nexport async function getCached(hash: string): Promise {\n const { rows } = await sqlite.execute({ sql: `SELECT result FROM ${LLM_CACHE} WHERE hash = ?`, args: [hash] });\n return rows[0] ? String(rows[0].result) : null;\n}\n\nexport async function setCached(hash: string, result: string) {\n const now = Date.now();\n await sqlite.batch([\n { sql: `DELETE FROM ${LLM_CACHE} WHERE created_at < ?`, args: [now - 30 * DAY_MS] },\n {\n sql: `INSERT INTO ${LLM_CACHE} (hash, result, created_at) VALUES (?, ?, ?)\n ON CONFLICT(hash) DO UPDATE SET result = excluded.result, created_at = excluded.created_at`,\n args: [hash, result, now],\n },\n ]);\n}\n\n// ---------- push subscriptions ----------\n\nexport interface PushRow {\n endpoint: string;\n p256dh: string;\n auth: string;\n favorites: number[];\n}\n\nexport async function saveSubscription(endpoint: string, p256dh: string, auth: string, favorites: number[]) {\n await sqlite.execute({\n sql: `INSERT INTO ${PUSH} (endpoint, p256dh, auth, favorites, created_at) VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(endpoint) DO UPDATE SET p256dh = excluded.p256dh, auth = excluded.auth, favorites = excluded.favorites`,\n args: [endpoint, p256dh, auth, JSON.stringify(favorites), Date.now()],\n });\n}\n\nexport async function deleteSubscription(endpoint: string) {\n await sqlite.execute({ sql: `DELETE FROM ${PUSH} WHERE endpoint = ?`, args: [endpoint] });\n}\n\nexport async function allSubscriptions(): Promise {\n const { rows } = await sqlite.execute(`SELECT endpoint, p256dh, auth, favorites FROM ${PUSH}`);\n return rows.map((r) => ({\n endpoint: String(r.endpoint),\n p256dh: String(r.p256dh),\n auth: String(r.auth),\n favorites: parseJson(r.favorites, []),\n }));\n}\n\n// ---------- PIN attempts ----------\n\nexport async function countLoginFails(ip: string, since: number) {\n const { rows } = await sqlite.execute({\n sql: `SELECT COUNT(*) AS total, COALESCE(SUM(CASE WHEN ip = ? THEN 1 ELSE 0 END), 0) AS mine\n FROM ${LOGIN_FAILS} WHERE at >= ?`,\n args: [ip, since],\n });\n return { total: Number(rows[0]?.total ?? 0), mine: Number(rows[0]?.mine ?? 0) };\n}\n\nexport async function recordLoginFail(ip: string) {\n const now = Date.now();\n await sqlite.batch([\n { sql: `DELETE FROM ${LOGIN_FAILS} WHERE at < ?`, args: [now - DAY_MS] },\n { sql: `INSERT INTO ${LOGIN_FAILS} (ip, at) VALUES (?, ?)`, args: [ip, now] },\n ]);\n}\n","createdAt",["D",1789368295843],"branchVersion","branchId","255405a6-055f-4761-b8d5-94d1ffe681e3","id","25f66c95-84fd-4431-a007-b1f4e010323a","co-w-zamosciu",["D",1789336184443],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Co dziś w Zamościu i na Roztoczu — koncerty, kino, wydarzenia","imageUrl","5dd5cdfa-b36a-42e1-a911-81ba86e3b64c","pinnedFileId","01a09cbf-66da-7600-85d1-7a5d4b41e0de","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09aab-d118-725d-b44f-c12d328bfdc6","tursoName","25f66c9584fd4431a007b1f4e010323a","tursoHostname","25f66c9584fd4431a007b1f4e010323a-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",150,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dominik1","handle","displayName","Dominik","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_44":45,"_32":46,"_39":435,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":436,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":437,"_85":438,"_87":439,"_89":25},"tree",[202,217,220,227,229,231,232,233],"files",[202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233],"counts",{"_191":64,"_192":142,"_193":64,"_194":195,"_196":197},"contents",[131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":185,"_32":186,"_30":187,"_141":-5,"_42":43,"_41":188,"_143":60,"_39":189,"_13":64,"_34":166,"_36":-5,"_24":25,"_147":-5,"_27":190},{"_44":179,"_32":180,"_30":181,"_141":-5,"_42":43,"_41":182,"_143":60,"_39":183,"_13":64,"_34":166,"_36":-5,"_24":25,"_147":-5,"_27":184},{"_44":174,"_32":175,"_30":176,"_141":-5,"_42":43,"_41":142,"_143":60,"_39":177,"_13":64,"_34":166,"_36":-5,"_24":25,"_147":-5,"_27":178},{"_44":168,"_32":169,"_30":170,"_141":-5,"_42":43,"_41":171,"_143":60,"_39":172,"_13":64,"_34":166,"_36":-5,"_24":25,"_147":-5,"_27":173},{"_44":161,"_32":162,"_30":163,"_141":-5,"_42":43,"_41":164,"_143":60,"_39":165,"_13":64,"_34":166,"_36":-5,"_24":25,"_147":-5,"_27":167},{"_44":155,"_32":156,"_30":157,"_141":-5,"_42":43,"_41":142,"_143":60,"_39":158,"_13":64,"_34":20,"_36":159,"_24":25,"_147":-5,"_27":160},{"_44":149,"_32":150,"_30":151,"_141":-5,"_42":43,"_41":142,"_143":25,"_39":152,"_13":64,"_34":20,"_36":153,"_24":25,"_147":-5,"_27":154},{"_44":139,"_32":140,"_30":58,"_141":-5,"_42":43,"_41":142,"_143":25,"_39":144,"_13":64,"_34":145,"_36":146,"_24":25,"_147":46,"_27":148},"c32ff9f8-6fbb-4039-be8e-8daae2d99007","index.ts","parentId",1,"latest",["D",1789336184443],"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (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// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\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",[140],"6f9cf8c5-cc6d-47ba-b106-6d7e24b7f39b","README.md","01a09cbf-66da-7600-85d1-77f7ef9c20ff",["D",1789336184443],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[150],"42cea312-1aaf-4642-b2da-e3bba05e69b9","CHANGELOG.md","01a09cbf-66da-7600-85d1-72302458f448",["D",1789336184443],"# 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 · v23