${title}

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","hrbrmstr","name","mire-rss","path","rss.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/hrbrmstr/mire-rss/code/rss.ts","extension","id","aded7fdb-6887-49bf-96e5-640ca839c5ec","fileId","01a08005-59e7-76be-9090-6b5231fade2a","parentId","branchId","97df149b-8210-434c-b3d7-1d1b2ce3d5cf","branchVersion",4,"latest",true,"createdAt",["D",1788854570996],"version",1,"fileType","script","content","// RSS feed generator — reads blog entries from SQLite and serves RSS 2.0 XML.\n\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst FEED_TITLE = \"The MIRE/C³ Blog\";\nconst FEED_DESCRIPTION = \"Notes from the treacle — findings, experiments and war stories from the MIRE/C³ honeypot cluster.\";\nconst FEED_LINK = \"https://mire.cc/the-blog/\";\n\n/**\n * Escape XML special characters.\n */\nfunction escapeXml(str: string): string {\n return str\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}\n\n/**\n * Generate RSS 2.0 XML from stored blog entries.\n */\nexport async function generateRss(feedUrl: string): Promise {\n const result = await sqlite.execute(\n \"SELECT slug, title, category, pub_date, description, link FROM blog_entries ORDER BY pub_date DESC\",\n );\n\n const items = result.rows\n .map((row) => {\n const title = escapeXml(String(row.title ?? \"\"));\n const link = escapeXml(String(row.link ?? \"\"));\n const description = row.description ? escapeXml(String(row.description)) : \"\";\n const category = row.category ? `${escapeXml(String(row.category))}` : \"\";\n const pubDate = row.pub_date ? new Date(String(row.pub_date)).toUTCString() : \"\";\n const guid = escapeXml(String(row.slug ?? \"\"));\n\n return ` \n ${title}\n ${link}\n ${description}\n ${category}\n ${pubDate}\n ${guid}\n `;\n })\n .join(\"\\n\");\n\n const lastBuildDate = new Date().toUTCString();\n\n return `\n\n \n ${escapeXml(FEED_TITLE)}\n ${escapeXml(FEED_LINK)}\n ${escapeXml(FEED_DESCRIPTION)}\n en-gb\n ${lastBuildDate}\n \n${items}\n \n`;\n}\n","deleted",false,"label",[14],"7f8d8abb-937e-4199-a86a-87d156d4c9e5",["D",1788854229386],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Unofficial RSS feed for the MIRE/C³ blog (mire.cc/the-blog)","imageUrl","userId","660e611e-30de-4ed3-8449-79507be25f74","pinnedFileId","01a08005-59e7-76be-9090-633fa90a968d","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","f4053730-af3b-4f20-9c5e-6d19f910dfd0","tursoName","7f8d8abb937e4199a86a87d156d4c9e5","tursoHostname","7f8d8abb937e4199a86a87d156d4c9e5-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789461042390],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_102":-5,"_103":104,"_55":56,"_105":106,"_107":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":93,"_94":95,"_96":50,"_97":98,"_99":65,"_100":12,"_101":10},"isOwned",10,"main","projectId","forkedBranchId","e6d4b62a-460c-11f1-9efa-42b51c65c3df","forkedBranchVersion",13,"forkedProjectPrivacy","forkedProjectId","e6d3dcaa-460c-11f1-9efa-42b51c65c3df","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybTQ2MzZSZEl6dm1wZjZnT1hJM2NGNjFCbWgifQ","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_142":143,"_144":145,"_146":147,"_148":42,"_149":42,"_150":42,"_151":32,"_152":-5,"_153":-7,"_154":-7,"_155":63,"_156":42,"_157":42,"_158":-5,"_159":42,"_160":42,"_161":42,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":90,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]