[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_183":184,"_185":186},"routes/_app.x.$handle.$name",{"_102":101,"_38":51,"_110":92,"_33":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_26":-5,"_122":-5,"_123":-5,"_124":31,"_125":126,"_127":64,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":31},"version",5,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","523d3b24-3103-4236-ad2a-e37486e5df90","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":43,"_41":42,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","7141722e-a6c7-11f1-b0ba-1607ee4eb77e","name","fileType","script","content","import { Hono } from \"npm:hono\";\nimport { fetchPatch } from \"./commitfest.ts\";\nimport { buildRss } from \"./rss.ts\";\n\nconst app = new Hono();\napp.onError((err) => Promise.reject(err));\n\nconst ID_RE = /^\\d+$/;\n\napp.get(\"/\", (c) => {\n const base = new URL(c.req.url).origin;\n return c.html(`\n\nCommitfest patch history RSS\n\n

Commitfest patch history → RSS

Expose the hidden History section of a\n PostgreSQL commitfest patch\n page as an RSS feed.

\n \n

Or use the URL directly:

/patch/6982

/patch/<id> — RSS feed for a patch
/patch/<id>.json — same data as JSON (for debugging)

\n \n\n`);\n});\n\n// /patch/6982 and /patch/6982.json\napp.get(\"/patch/:id(.json)?\", async (c) => {\n const id = c.req.param(\"id\");\n const asJson = (c.req.path.match(/\\.json$/) ? true : false);\n if (!ID_RE.test(id ?? \"\")) {\n return c.json({ error: \"Patch id must be numeric\" }, 400);\n }\n const patch = await fetchPatch(id!);\n if (asJson) return c.json(patch);\n return new Response(buildRss(patch, new URL(c.req.url).href), {\n headers: { \"Content-Type\": \"application/rss+xml; charset=utf-8\" },\n });\n});\n\n// Convenience: /6982\napp.get(\"/:id(.json)?\", async (c) => {\n const id = c.req.param(\"id\");\n const asJson = (c.req.path.match(/\\.json$/) ? true : false);\n if (!ID_RE.test(id ?? \"\")) {\n return c.redirect(\"/\", 302);\n }\n const patch = await fetchPatch(id!);\n if (asJson) return c.json(patch);\n return new Response(buildRss(patch, new URL(c.req.url).href), {\n headers: { \"Content-Type\": \"application/rss+xml; charset=utf-8\" },\n });\n});\n\nexport default app.fetch;\n","http","createdAt",["D",1788351115560],"branchVersion","branchId","277bd56f-e1f2-4860-ab1d-825ac0ba658c","id","f91ca2e2-7113-4e4b-96aa-86f5439f3875","cf-rss",["D",1788351095345],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Commitfest patch history as an RSS feed","imageUrl","bd61c49b-f855-4fa8-b249-7c6b35c00fb8","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","e576abfa-ab5a-4d5d-9341-3aa9d0b00c42","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_19":61,"_106":107,"_108":31},"branch",{"_13":91,"_38":92,"_49":48,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",46,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mootari","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yVkpXNXhUYUJCM0N5RGNBNklRUWJrZXdOWmIucG5nIn0","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":179,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":180,"_86":181,"_88":182,"_90":31},"tree",[166,167,168],"files",[166,167,168],"counts",{"_155":68,"_156":157,"_158":68,"_159":160,"_161":162},"contents",[132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":149,"_38":150,"_36":151,"_138":-5,"_47":48,"_46":147,"_140":31,"_44":152,"_13":68,"_39":40,"_41":153,"_30":31,"_143":-5,"_33":154},{"_49":145,"_38":34,"_36":37,"_138":-5,"_47":48,"_46":14,"_140":31,"_44":146,"_13":147,"_39":43,"_41":42,"_30":31,"_143":51,"_33":148},{"_49":135,"_38":136,"_36":137,"_138":-5,"_47":48,"_46":139,"_140":31,"_44":141,"_13":68,"_39":40,"_41":142,"_30":31,"_143":-5,"_33":144},"981ad546-e221-4428-88a5-26efb7e9d599","rss.ts","7bbbb75a-a6c7-11f1-b9c8-1607ee4eb77e","parentId",3,"latest",["D",1788351112969],"import type { PatchInfo } from \"./commitfest.ts\";\n\n/** Convert \"YYYY-MM-DD HH:MM:SS\" (assumed UTC) to an RFC-822 RSS pubDate. */\nfunction toRfc822(dateStr: string): string {\n const m = dateStr.match(\n /^(\\d{4})-(\\d{2})-(\\d{2})\\s+(\\d{2}):(\\d{2}):(\\d{2})/,\n );\n if (!m) return \"\";\n const [_, y, mo, d, h, mi, s] = m;\n const date = new Date(\n Date.UTC(\n Number(y), Number(mo) - 1, Number(d), Number(h), Number(mi), Number(s),\n ),\n );\n return date.toUTCString(); // \"Tue, 10 Jul 2026 07:04:17 GMT\"\n}\n\nfunction xmlEscape(s: string): string {\n return s\n .replace(/&/g, \"&\")\n .replace(//g, \">\");\n}\n\nexport function buildRss(patch: PatchInfo, feedUrl: string): string {\n const title = patch.title\n ? `Commitfest patch #${patch.id}: ${patch.title}`\n : `Commitfest patch #${patch.id}`;\n\n const items = patch.history.map((h, i) => {\n const pubDate = toRfc822(h.date);\n const titleLine = `${h.who}: ${h.what}`;\n const guid = `${patch.id}-${i}`;\n return `\n ${xmlEscape(titleLine)}\n ${patch.url}\n ${guid}\n ${pubDate ? `${pubDate}` : \"\"}\n ${xmlEscape(h.what)}\n`;\n }).join(\"\\n\");\n\n return `\n\n\n ${xmlEscape(title)}\n ${patch.url}\n ${xmlEscape(title)} — history feed\n en\n ${new Date().toUTCString()}\n ${patch.history.length > 0\n ? `${toRfc822(patch.history[0].date)}`\n : \"\"}\n${items}\n\n\n`;\n}\n","label",[136],"83231597-774b-4bff-a7a2-21444a386a78",["D",1788351115560],2,[34],"edb7120e-7c67-464a-9234-26da9b251baf","commitfest.ts","755ef5f2-a6c7-11f1-8c42-1607ee4eb77e",["D",1788351102297],"// Fetch a PostgreSQL commitfest patch page and extract its history table,\n// which the commitfest JSON API does not expose.\n\nexport interface HistoryEntry {\n date: string;\n who: string;\n what: string;\n}\n\nexport interface PatchInfo {\n id: number;\n title: string;\n url: string;\n history: HistoryEntry[];\n}\n\nexport class AppError extends Error {\n status: number;\n constructor(message: string, status = 500) {\n super(message);\n this.status = status;\n }\n}\n\n/** Collapse HTML into plain text: strip tags and decode the common entities. */\nfunction decodeEntities(s: string): string {\n return s\n .replace(/<[^>]+>/g, \"\")\n .replace(/ /g, \" \")\n .replace(/&/g, \"&\")\n .replace(/</g, \"<\")\n .replace(/>/g, \">\")\n .replace(/"/g, '\"')\n .replace(/'/gi, \"'\")\n .replace(/'/g, \"'\")\n .replace(///gi, \"/\")\n .replace(/&#(\\d+);/g, (_, n) => String.fromCharCode(Number(n)))\n .replace(/\\s+/g, \" \")\n .trim();\n}\n\nfunction extractTitle(html: string): string {\n const m = html.match(/\\s*Title\\s*<\\/th>\\s*]*>([\\s\\S]*?)<\\/td>/i);\n return m ? decodeEntities(m[1]) : \"\";\n}\n\nfunction extractHistory(html: string): HistoryEntry[] {\n // Anchor on the `History` cell. The first `` after it is the\n // nested history table; its first `

` closes it.\n const anchor = html.indexOf(\"History\");\n if (anchor === -1) return [];\n const tableStart = html.indexOf(\"\", tableStart);\n if (tableEnd === -1) return [];\n\n const tableHtml = html.slice(tableStart, tableEnd);\n const entries: HistoryEntry[] = [];\n\n const rowRe = /]*>([\\s\\S]*?)<\\/tr>/gi;\n let rm: RegExpExecArray | null;\n while ((rm = rowRe.exec(tableHtml))) {\n // Skip header row (contains , not three ).\n const cells = [...rm[1].matchAll(/]*>([\\s\\S]*?)<\\/td>/gi)];\n if (cells.length !== 3) continue;\n entries.push({\n date: decodeEntities(cells[0][1]),\n who: decodeEntities(cells[1][1]),\n what: decodeEntities(cells[2][1]),\n });\n }\n return entries;\n}\n\nexport async function fetchPatch(id: number | string): Promise {\n const url = `https://commitfest.postgresql.org/patch/${id}/`;\n const res = await fetch(url, {\n headers: { \"User-Agent\": \"cf-rss (+https://val.town/mootari/cf-rss)\" },\n redirect: \"follow\",\n });\n if (res.status === 404) {\n throw new AppError(`Patch ${id} not found`, 404);\n }\n if (!res.ok) {\n throw new AppError(`commitfest returned HTTP ${res.status}`, 502);\n }\n const html = await res.text();\n return {\n id: Number(id),\n title: extractTitle(html),\n url,\n history: extractHistory(html),\n };\n}\n",[150],"pulls","branches",1,"forks","envVars",{"_163":68,"_165":68},"connections",{"_163":68,"_164":68},"count","unfilledCount","emptyCount",{"_49":149,"_38":150,"_36":151,"_138":-5,"_47":48,"_46":147,"_140":31,"_44":176,"_13":68,"_39":40,"_41":153,"_30":31,"_143":-5,"_170":177,"_33":178},{"_49":145,"_38":34,"_36":37,"_138":-5,"_47":48,"_46":14,"_140":31,"_44":173,"_13":147,"_39":43,"_41":42,"_30":31,"_143":51,"_170":174,"_33":175},{"_49":135,"_38":136,"_36":137,"_138":-5,"_47":48,"_46":139,"_140":31,"_44":169,"_13":68,"_39":40,"_41":142,"_30":31,"_143":-5,"_170":171,"_33":172},["D",1788351112969],"children",[],[136],["D",1788351115560],[],[34],["D",1788351102297],[],[150],["D",1788351095345],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_19":61,"_106":107,"_108":31},{"_13":91,"_38":92,"_49":48,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":216,"_217":218,"_219":220,"_221":31,"_222":31,"_223":31,"_224":64,"_225":-5,"_226":-7,"_227":-7,"_228":68,"_229":31,"_230":31,"_231":-5,"_232":31,"_233":31,"_234":31,"_235":-5},"ENV",{"_187":188,"_189":190,"_191":92,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215},"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 · v5