${escapeHtml(opts.title)}

\n ${opts.body}\n

\n \n\n`;\n}\n\n// Backfill slugs at startup\n{\n const res = await sqlite.execute(`SELECT id, title FROM ${TABLE} WHERE slug IS NULL OR slug = ''`);\n for (const row of res.rows as Array<{ id: number; title: string }>) {\n const s = await slugify(row.title);\n await sqlite.execute(`UPDATE ${TABLE} SET slug = ? WHERE id = ?`, [s, row.id]);\n }\n}\n\n// Home: list posts\napp.get(\"/\", async (c) => {\n const res = await sqlite.execute(`SELECT id, title, created_at, slug FROM ${TABLE} ORDER BY id DESC`);\n const rows = res.rows as Array<{ id: number; title: string; created_at: string; slug: string }>;\n const items = rows.map((row) => `\n

\n ${escapeHtml(row.title)}\n ${new Date(row.created_at).toLocaleString()}\n

\n Edit\n

\n `).join(\"\");\n\n const body = `\n

Posts

\n Write a post\n

No posts yet. Create the first.

\n `;\n return c.html(layout({ title: \"Town Blog\", body }));\n});\n\n// New post form\napp.get(\"/new\", (c) => {\n const body = `\n \n

Preview

Start typing to see preview…

\n \n `;\n return c.html(layout({ title: \"New Post\", body }));\n});\n\n// Create post\napp.post(\"/posts\", async (c) => {\n const form = await c.req.formData();\n const title = String(form.get(\"title\") ?? \"\").trim();\n const content = String(form.get(\"content\") ?? \"\").trim();\n if (!title || !content) {\n return c.html(layout({\n title: \"New Post - Error\",\n body: `

Title and content are required.

Go back

`\n }), 400);\n }\n const createdAt = new Date().toISOString();\n const slug = await slugify(title);\n await sqlite.execute(`INSERT INTO ${TABLE} (title, content, created_at, slug) VALUES (?, ?, ?, ?)`, [title, content, createdAt, slug]);\n return redirect(`/p/${slug}`);\n});\n\n// View by slug\napp.get(\"/p/:slug\", async (c) => {\n const slug = c.req.param(\"slug\");\n const res = await sqlite.execute(`SELECT id, title, content, created_at, slug FROM ${TABLE} WHERE slug = ?`, [slug]);\n const row = res.rows[0] as { id: number; title: string; content: string; created_at: string; slug: string } | undefined;\n if (!row) return c.notFound();\n const body = `\n

${escapeHtml(row.title)}

\n Edit\n \n

${md.render(row.content)}

\n Published ${new Date(row.created_at).toLocaleString()}\n

\n `;\n return c.html(layout({ title: row.title, body }));\n});\n\n// Legacy: view by id -> redirect to slug\napp.get(\"/posts/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const res = await sqlite.execute(`SELECT slug FROM ${TABLE} WHERE id = ?`, [id]);\n const row = res.rows[0] as { slug: string } | undefined;\n if (!row || !row.slug) return c.notFound();\n return redirect(`/p/${row.slug}`);\n});\n\n// Edit form (by id)\napp.get(\"/edit/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const res = await sqlite.execute(`SELECT id, title, content FROM ${TABLE} WHERE id = ?`, [id]);\n const row = res.rows[0] as { id: number; title: string; content: string } | undefined;\n if (!row) return c.notFound();\n const body = `\n \n \n

Preview

\n \n `;\n return c.html(layout({ title: `Edit: ${row.title}`, body }));\n});\n\n// Update post (by id)\napp.post(\"/posts/:id\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n const form = await c.req.formData();\n const title = String(form.get(\"title\") ?? \"\").trim();\n const content = String(form.get(\"content\") ?? \"\").trim();\n if (!title || !content) {\n return c.html(layout({\n title: \"Edit Post - Error\",\n body: `

Title and content are required.

Go back

`\n }), 400);\n }\n // If title changed, update slug as well (preserve uniqueness)\n const current = await sqlite.execute(`SELECT title, slug FROM ${TABLE} WHERE id = ?`, [id]);\n const currentRow = current.rows[0] as { title: string; slug: string } | undefined;\n const currentSlug = currentRow?.slug ?? null;\n const newSlug = currentRow && currentRow.title !== title ? await slugify(title) : currentSlug;\n await sqlite.execute(`UPDATE ${TABLE} SET title = ?, content = ?, slug = ? WHERE id = ?`, [title, content, newSlug, id]);\n return redirect(`/p/${newSlug}`);\n});\n\n// Delete post (by id)\napp.post(\"/posts/:id/delete\", async (c) => {\n const id = Number(c.req.param(\"id\"));\n await sqlite.execute(`DELETE FROM ${TABLE} WHERE id = ?`, [id]);\n return redirect(\"/\");\n});\n\nexport default app.fetch;",[],[58,90],["D",1763163250398],[102],[64],{"_35":103,"_13":104,"_38":105,"_40":65,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":24,"_52":108,"_53":54,"_55":-5,"_73":109,"_18":110},"6bd87044-c1b2-11f0-bccc-42dde27851f2","extensions.json","6bd87184-c1b2-11f0-bccc-42dde27851f2",7,["D",1763163250612],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[64,104],"c1f38774-c1ae-11f0-8e92-42dde27851f2",["D",1763161677088],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","fa602270-d767-476a-be2a-1070a19b692d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","f4b8cdfb-e8ce-48da-840c-727b846965e1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_163":159},"org",{"_11":12,"_157":-5,"_158":159,"_120":121,"_160":161,"_162":54},"branch",{"_17":92,"_13":16,"_35":42,"_149":111,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":14,"_156":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yYXNFTjNuRzhRY0xQQnJPdkVVTnpMZXJQVUwifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":111,"_13":14,"_47":215,"_113":-5,"_114":54,"_115":116,"_117":116,"_118":19,"_119":-5,"_120":121,"_122":91,"_123":46,"_124":46,"_125":-5,"_126":49,"_127":128,"_129":-5,"_130":-5,"_131":-5,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_142":216,"_144":217,"_146":218,"_148":54},[197,199,201],"files",[197,198,199,200,201,202],"counts",{"_188":49,"_189":44,"_190":49,"_31":191,"_192":193},[182,183,184],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":63,"_13":64,"_38":65,"_40":-5,"_41":42,"_43":66,"_45":46,"_47":67,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_18":187},{"_35":57,"_13":58,"_38":59,"_40":-5,"_41":42,"_43":60,"_45":46,"_47":61,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_18":186},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_18":185},[37],[58],[64],"pulls","branches","forks",{"_194":49,"_196":49},"connections",{"_194":49,"_195":49},"count","unfilledCount","emptyCount",{"_35":63,"_13":64,"_38":65,"_40":-5,"_41":42,"_43":66,"_45":46,"_47":99,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_73":213,"_18":214},{"_35":103,"_13":104,"_38":105,"_40":65,"_41":42,"_43":106,"_45":46,"_47":107,"_17":49,"_50":24,"_52":108,"_53":54,"_55":-5,"_73":211,"_18":212},{"_35":57,"_13":58,"_38":59,"_40":-5,"_41":42,"_43":60,"_45":46,"_47":85,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_73":209,"_18":210},{"_35":89,"_13":90,"_38":91,"_40":59,"_41":42,"_43":92,"_45":46,"_47":93,"_17":94,"_50":95,"_52":96,"_53":54,"_55":-5,"_73":207,"_18":208},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":72,"_17":49,"_50":51,"_52":-5,"_53":54,"_55":-5,"_73":205,"_18":206},{"_35":77,"_13":78,"_38":79,"_40":39,"_41":42,"_43":80,"_45":46,"_47":81,"_17":44,"_50":24,"_52":82,"_53":54,"_55":-5,"_73":203,"_18":204},[],[37,78],[202],[37],[],[58,90],[200],[58],[],[64,104],[198],[64],["D",1763161677088],{"_11":12,"_163":159},{"_11":12,"_157":-5,"_158":159,"_120":121,"_160":161,"_162":54},{"_17":92,"_13":16,"_35":42,"_149":111,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":-5,"_155":14,"_156":12},"ctx",{"_142":-5,"_179":252,"_253":254,"_255":256,"_257":54,"_258":54,"_259":54,"_260":46,"_261":-5,"_262":-7,"_263":-7,"_264":49,"_265":54,"_266":54,"_267":-5,"_268":54,"_269":54,"_270":54,"_271":-5},"ENV",{"_223":224,"_225":226,"_227":16,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251},"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