${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;",[18,67],"pulls","branches",1,"forks","envVars",{"_190":26,"_192":26},"connections",{"_190":26,"_191":26},"count","unfilledCount","emptyCount",{"_36":230,"_13":229,"_65":223,"_46":-5,"_38":39,"_170":231,"_172":24,"_40":232,"_42":26,"_68":99,"_174":-5,"_70":30,"_175":-5,"_206":233,"_17":234},{"_36":220,"_13":221,"_65":222,"_46":223,"_38":39,"_170":224,"_172":24,"_40":225,"_42":26,"_68":21,"_174":226,"_70":30,"_175":-5,"_206":227,"_17":228},{"_36":169,"_13":18,"_65":98,"_46":-5,"_38":39,"_170":171,"_172":24,"_40":217,"_42":26,"_68":99,"_174":-5,"_70":30,"_175":-5,"_206":218,"_17":219},{"_36":178,"_13":67,"_65":66,"_46":98,"_38":39,"_170":92,"_172":24,"_40":214,"_42":43,"_68":69,"_174":180,"_70":30,"_175":-5,"_206":215,"_17":216},{"_36":210,"_13":209,"_65":202,"_46":-5,"_38":39,"_170":184,"_172":24,"_40":211,"_42":26,"_68":99,"_174":-5,"_70":30,"_175":-5,"_206":212,"_17":213},{"_36":199,"_13":200,"_65":201,"_46":202,"_38":39,"_170":203,"_172":24,"_40":204,"_42":184,"_68":21,"_174":205,"_70":30,"_175":-5,"_206":207,"_17":208},"e64f5bd0-c1b2-11f0-a173-42dde27851f2","style.css","7b3952a2-c1b1-11f0-9ebc-42dde27851f2","2d89b0a6-c1b1-11f0-896e-42dde27851f2",9,["D",1763163456067],":root{--bg:#ffffff;--text:#111827;--muted:#6b7280;--line:#e5e7eb;--line-strong:#d1d5db;--accent:#111827;--accent-weak:#f3f4f6;--btn:#111827;--btn-text:#ffffff}\n*{box-sizing:border-box}\nhtml,body{margin:0;padding:0}\nbody{font:16px/1.6 system-ui,-apple-system,Segoe UI,Roboto,Ubuntu,Cantarell,Noto Sans,sans-serif;background:var(--bg);color:var(--text)}\n.container{max-width:760px;margin:0 auto;padding:24px}\n\n.site-header{border-bottom:1px solid var(--line);background:#fff;position:sticky;top:0}\n.site-title{font-size:18px;margin:0}\n.site-title a{text-decoration:none;color:var(--text)}\n.site-nav{display:flex;gap:12px;align-items:center}\n.site-footer{border-top:1px solid var(--line);padding:16px 0;margin-top:48px}\n.muted{color:var(--muted)}\n\n.card{border:1px solid var(--line);border-radius:12px;background:#fff;overflow:hidden}\n.card + .card{margin-top:16px}\n.card-head,.card-foot{display:flex;justify-content:space-between;align-items:center;padding:14px 16px;border-bottom:1px solid var(--line)}\n.card-foot{border-top:1px solid var(--line);border-bottom:none}\n.card h2{font-size:18px;margin:0}\n\n.post-list{list-style:none;margin:0;padding:0}\n.post-item{border-top:1px solid var(--line)}\n.post-item:first-child{border-top:none}\n.post-row{display:flex;justify-content:space-between;gap:12px;padding:14px 16px}\n.post-meta{display:flex;flex-direction:column}\n.post-title{font-weight:600;color:var(--text);text-decoration:none}\n.post-title:hover{opacity:.9}\n.timestamp{color:var(--muted);font-size:12px;margin-top:2px}\n.post-actions{display:flex;gap:8px}\n.post-actions .link{font-size:14px}\n.empty{padding:14px 16px;color:var(--muted)}\n\n.link{color:var(--text);text-decoration:none;border-bottom:1px solid var(--line)}\n.link:hover{border-bottom-color:var(--line-strong)}\n\n.btn{display:inline-flex;align-items:center;gap:8px;padding:8px 12px;border:1px solid var(--line);border-radius:8px;background:var(--accent-weak);color:var(--text);text-decoration:none;cursor:pointer}\n.btn:hover{background:#eef2f7}\n.btn.primary{background:var(--btn);color:var(--btn-text);border-color:#111}\n.btn.primary:hover{filter:brightness(.96)}\n\n.form{padding:16px}\n.form-row{display:flex;flex-direction:column;gap:8px;padding:12px 0;border-top:1px solid var(--line)}\n.form-row:first-child{border-top:none}\nlabel{font-weight:600}\ninput[type=text], textarea{width:100%;padding:10px 12px;border:1px solid var(--line);border-radius:8px;background:#fff;color:var(--text)}\ninput[type=text]:focus, textarea:focus{outline:none;border-color:var(--line-strong);box-shadow:0 0 0 3px rgba(17,24,39,.05)}\n.form-actions{display:flex;gap:12px;padding-top:16px;border-top:1px solid var(--line)}\n\n.post-content{padding:16px;border-top:1px solid var(--line);border-bottom:1px solid var(--line)}\n\n/* Minimal prose styling for Markdown */\n.prose{line-height:1.7}\n.prose h1,.prose h2,.prose h3{margin:1.2em 0 .6em;font-weight:700}\n.prose h1{font-size:1.6rem}\n.prose h2{font-size:1.3rem}\n.prose h3{font-size:1.1rem}\n.prose p{margin:.8em 0}\n.prose ul,.prose ol{margin:.8em 0;padding-left:1.2em}\n.prose li+li{margin-top:.25em}\n.prose a{color:var(--text);border-bottom:1px solid var(--line)}\n.prose a:hover{border-bottom-color:var(--line-strong)}\n.prose code{background:#f8fafc;border:1px solid var(--line);border-radius:6px;padding:.1em .3em;font-family:ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;font-size:.95em}\n.prose pre{background:#0b1020;color:#e5e7eb;border-radius:8px;padding:12px;overflow:auto;border:1px solid #11182720}\n.prose pre code{background:transparent;border:none;padding:0;color:inherit}\n.prose blockquote{border-left:3px solid var(--line-strong);margin:1em 0;padding:.1em 1em;color:var(--muted)}\n.error{color:#b91c1c}\n","children",[],[209,200],"frontend","2d89afc0-c1b1-11f0-896e-42dde27851f2",["D",1763162716573],[198],[209],["D",1763163732713],[],[18,67],["D",1763162789385],[196],[18],"6bd87044-c1b2-11f0-bccc-42dde27851f2","extensions.json","6bd87184-c1b2-11f0-bccc-42dde27851f2","6bb7fff8-c1b2-11f0-bccc-42dde27851f2",7,["D",1763163250612],"{\n \"recommendations\": [\n \"denoland.vscode-deno\"\n ]\n}",[],[229,221],".vscode","6bb7ff3a-c1b2-11f0-bccc-42dde27851f2",6,["D",1763163250398],[194],[229],["D",1763161677088],{"_11":12,"_147":73},{"_11":12,"_143":-5,"_72":73,"_31":71,"_144":145,"_146":30},{"_42":92,"_13":16,"_36":39,"_135":101,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":14,"_142":12},"ctx",{"_55":-5,"_166":272,"_273":274,"_275":276,"_277":30,"_278":30,"_279":30,"_280":24,"_281":-5,"_282":-7,"_283":-7,"_284":26,"_285":30,"_286":30,"_287":-5,"_288":30,"_289":30,"_290":30,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":16,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

History · backend