[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_151":152,"_153":154},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_115":-5,"_20":116,"_22":117,"_118":119,"_120":121,"_25":122,"_24":-5,"_123":-5,"_124":-5,"_125":53,"_126":127,"_128":44,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","roramigator","name","bulletinBoard","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":44,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":94,"_95":96,"_97":98,"_99":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","0c811142-26d9-11f0-a5b3-569c3dd06744","main.tsx","fileId","0c7af03c-26d9-11f0-a5b3-569c3dd06744","parentId","branchId","0c78b646-26d9-11f0-a5b3-569c3dd06744","branchVersion",2,"latest",true,"createdAt",["D",1725240915447],1,"fileType","http","content","// This app creates a community bulletin board where users can post messages with titles and view all posts.\n// Posts are automatically deleted after 24 hours. A basic spam filter is implemented to prevent abuse.\n// The app uses SQLite for data storage and includes both server-side and client-side components.\n\n/** @jsxImportSource https://esm.sh/react */\nimport React, { useEffect, useState } from \"https://esm.sh/react\";\nimport { createRoot } from \"https://esm.sh/react-dom/client\";\n\nfunction App() {\n const [posts, setPosts] = useState([]);\n const [newTitle, setNewTitle] = useState(\"\");\n const [newPost, setNewPost] = useState(\"\");\n const [error, setError] = useState(\"\");\n\n useEffect(() => {\n fetchPosts();\n const interval = setInterval(fetchPosts, 30000); // Refresh every 30 seconds\n return () => clearInterval(interval);\n }, []);\n\n const fetchPosts = async () => {\n const response = await fetch(\"/posts\");\n const data = await response.json();\n setPosts(data);\n };\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n setError(\"\");\n const response = await fetch(\"/post\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ title: newTitle, content: newPost }),\n });\n if (response.ok) {\n setNewTitle(\"\");\n setNewPost(\"\");\n fetchPosts();\n } else {\n const error = await response.text();\n setError(error);\n }\n };\n\n return (\n

📰 Bulletin Board

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nasync function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const SCHEMA_VERSION = 1;\n const KEY = \"bulletinBoard\";\n const TABLE_NAME = `${KEY}_posts_${SCHEMA_VERSION}`;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Function to delete old posts\n const deleteOldPosts = async () => {\n await sqlite.execute(`\n DELETE FROM ${TABLE_NAME}\n WHERE timestamp < datetime('now', '-1 day')\n `);\n };\n\n // Delete old posts before processing the request\n await deleteOldPosts();\n\n const url = new URL(request.url);\n if (url.pathname === \"/posts\") {\n // Fetch posts\n const posts = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME}\n ORDER BY timestamp DESC\n `);\n return new Response(JSON.stringify(posts.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } else if (url.pathname === \"/post\" && request.method === \"POST\") {\n // Create new post\n const { title, content } = await request.json();\n\n // Basic spam filter\n if (title.length > 100) {\n return new Response(\"Title is too long (max 100 characters)\", { status: 400 });\n }\n if (content.length > 500) {\n return new Response(\"Post is too long (max 500 characters)\", { status: 400 });\n }\n\n await sqlite.execute(\n `\n INSERT INTO ${TABLE_NAME} (title, content) VALUES (?, ?)\n `,\n [title, content],\n );\n return new Response(\"Post created successfully\");\n } else {\n // Serve HTML\n return new Response(\n `\n \n \n Community Bulletin Board\n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n }\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 0;\n background-color: #f4f4f4;\n}\n.container {\n width: 80%;\n margin: auto;\n overflow: hidden;\n padding: 20px;\n}\nh1 {\n color: #333;\n text-align: center;\n}\nform {\n background: #fff;\n padding: 20px;\n margin-bottom: 20px;\n}\ntextarea {\n width: 100%;\n padding: 10px;\n height: 100px;\n}\ninput[type=\"text\"] {\n width: 100%;\n padding: 10px;\n margin-bottom: 10px;\n}\nbutton {\n display: block;\n width: 100%;\n padding: 10px;\n background: #333;\n color: #fff;\n border: none;\n cursor: pointer;\n}\nbutton:hover {\n background: #555;\n}\n.posts {\n background: #fff;\n}\n.post {\n border-bottom: 1px solid #ccc;\n padding: 10px;\n}\n.post:last-child {\n border-bottom: none;\n}\n.post h2 {\n margin-top: 0;\n color: #333;\n}\n.post .content {\n margin-bottom: 5px;\n}\n.error {\n color: red;\n text-align: center;\n}\nfooter {\n text-align: center;\n margin-top: 20px;\n}\nfooter a {\n color: #333;\n text-decoration: none;\n}\nfooter a:hover {\n text-decoration: underline;\n}\n`;\n\nexport default server;","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1725240915447],"children",[],[35],"0c786452-26d9-11f0-a5b3-569c3dd06744",["D",1746137410744],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","1fbcf2a8-b3b9-4505-b29e-815025b3dafd","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","824a863c-d35d-43e7-b506-aa6581d7c870","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_114":110},"org",{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},"branch",{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaWRleE4xZG5sSW9IbnN2R3hFd0xaR2dqNXUifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":147,"_63":-5,"_64":44,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":-5,"_81":-5,"_82":-5,"_83":-5,"_84":85,"_86":85,"_87":88,"_89":88,"_90":88,"_91":85,"_92":85,"_93":148,"_95":149,"_97":150,"_99":53},[144],"files",[144],"counts",{"_135":77,"_136":47,"_137":77,"_31":138,"_139":140},[133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":134},[35],"pulls","branches","forks",{"_141":77,"_143":77},"connections",{"_141":77,"_142":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":145,"_18":146},[],[35],["D",1746137410744],{"_11":12,"_114":110},{"_11":12,"_108":-5,"_109":110,"_70":71,"_111":112,"_113":53},{"_17":42,"_13":16,"_33":40,"_100":61,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":14,"_107":12},"ctx",{"_93":-5,"_130":184,"_185":186,"_187":188,"_189":53,"_190":53,"_191":53,"_192":44,"_193":-5,"_194":-7,"_195":-7,"_196":77,"_197":53,"_198":53,"_199":-5,"_200":53,"_201":53,"_202":53,"_203":-5},"ENV",{"_155":156,"_157":158,"_159":16,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]

📰 Bulletin Board

{post.title}

Code