{props.children}

\n \n \n );\n};\n\nconst Top = async () => {\n const messages = await sqlite.execute(\"SELECT * from messages;\");\n console.log(messages);\n return (\n \n

Guestbook

Hey there! Sign my guestbook!

\n \n

{message}

\n \n );\n};\n\napp.get(\"/\", (c) => {\n return c.html();\n});\n\napp.post(\"/message\", async (c) => {\n const body = await c.req.formData();\n const message = String(body.get(\"message\") ?? \"\");\n if (message.length > 1000) return r.text(`That's too long!`);\n await sqlite.execute(\"INSERT INTO messages (message) VALUES (?)\", [message]);\n return c.redirect(\"/\");\n});\n\nexport default app.fetch;","deleted","label","guestbook-example",[129],"4aeb0bc4-7361-47ac-91bd-38aefbf7fd48","README.md","a2efc5ca-ad3c-11f1-bbe0-1607ee4eb77e",11,["D",1789061186501],1,"# Guestbook\n\nMinimal example to showcase\n[SQLite in Val Town](https://docs.val.town/reference/std/sqlite).",[146],"pulls","branches","forks","envVars",{"_160":43,"_162":43},"connections",{"_160":43,"_161":43},"count","unfilledCount","emptyCount",{"_18":145,"_20":146,"_130":147,"_131":-5,"_132":72,"_133":148,"_134":39,"_22":169,"_69":150,"_137":104,"_139":151,"_141":26,"_142":-5,"_166":170,"_94":171},{"_18":128,"_20":129,"_130":37,"_131":-5,"_132":72,"_133":70,"_134":39,"_22":165,"_69":136,"_137":138,"_139":140,"_141":26,"_142":143,"_166":167,"_94":168},["D",1789061262881],"children",[],[129],["D",1789061186501],[],[146],["D",1769548632131],["D",1789519842404],{"_16":17,"_92":88},{"_16":17,"_85":86,"_87":88,"_34":35,"_89":90,"_91":26},{"_69":70,"_20":71,"_18":72,"_73":19,"_74":75,"_76":77,"_78":28,"_79":80,"_81":82,"_83":21,"_84":17},"ctx",{"_62":-5,"_114":210,"_211":212,"_213":214,"_215":26,"_216":26,"_217":26,"_218":39,"_219":-5,"_220":-7,"_221":-7,"_222":43,"_223":26,"_224":26,"_225":-5,"_226":26,"_227":26,"_228":26,"_229":-5},"ENV",{"_181":182,"_183":184,"_185":71,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209},"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"]

Search