[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_186":187,"_188":189},"routes/_app.x.$handle.$name",{"_103":102,"_32":45,"_112":89,"_27":55,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":124,"_125":126,"_127":25,"_128":129,"_130":59,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":31,"_58":59,"_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":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","019c0151-50ab-717f-a053-086f9373c7a5","name","fileType","http","content","/** @jsxImportSource npm:hono@4.11.5/jsx */\nimport { Hono } from \"npm:hono@4.11.5\";\nimport type { FC } from \"npm:hono@4.11.5/jsx\";\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\n\nawait sqlite.execute(\"CREATE TABLE IF NOT EXISTS messages (message TEXT)\");\n\nconst app = new Hono();\n\nconst Layout: FC = (props: any) => {\n return (\n \n \n \n

{props.children}

\n \n \n );\n};\n\nconst Top: FC<{}> = 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.message}

{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;","createdAt",["D",1789061262881],"branchVersion","branchId","8bdf14a4-fbc5-11f0-92c6-42dde27851f2","id","8bd8da3a-fbc5-11f0-92c6-42dde27851f2","guestbook-demo",["D",1769548632131],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Guestbook","imageUrl","","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","631c5cff-7089-4994-8427-c7580df789cd","tursoName","8bd8da3afbc511f092c642dde27851f2","tursoHostname","8bd8da3afbc511f092c642dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519842404],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_18":56,"_108":109,"_110":25},"branch",{"_13":14,"_32":89,"_43":42,"_90":44,"_91":92,"_93":94,"_95":50,"_96":97,"_98":99,"_100":45,"_101":102},"isOwned","main","projectId","forkedBranchId","b4d5835e-f894-11f0-9f94-42dde27851f2","forkedBranchVersion",26,"forkedProjectPrivacy","forkedProjectId","b4d4a9fc-f894-11f0-9f94-42dde27851f2","forkedProjectOrgId","f407f111-fdbb-4126-923f-44aed4d9e9ad","projectName","userHandle","pmillspaugh","handle","displayName","Pete Millspaugh","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c3c0aadf-86a9-4c2e-ef01-fb649d6fb000/square512?exp=1789538399&sig=bcce5f61c0dc098963a4ad10dd9f6b959ffe48da46958bcafad91bfee938a441","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":181,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":31,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":182,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":183,"_84":184,"_86":185,"_88":25},"tree",[172,173],"files",[172,173],"counts",{"_162":63,"_163":159,"_164":63,"_165":166,"_167":168},"contents",[144,145],"upstreamProject",{"_43":97,"_32":141,"_52":53,"_54":55,"_49":50,"_82":142},"upstreamBranch",{"_43":92,"_38":135,"_136":137,"_32":89,"_90":97,"_13":94,"_91":-5,"_93":-5,"_138":139,"_47":-5,"_88":25,"_49":50,"_101":140,"_64":99,"_100":141},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1769197802112],"updatedAt",["D",1769200327228],"lockfileKey","1769200327338-esm.town_v_tmcw_guestbook@26-main","tmcw","guestbook",{"_103":140,"_111":143},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7935dc1b-7699-4095-366a-2e9103307501/square512?exp=1789538399&sig=d2766d4ffa77c6d22d4b292ce119da78253a94b5556cff7d2c392e37b39c507a",{"_43":154,"_32":155,"_30":156,"_147":-5,"_41":42,"_40":157,"_148":59,"_38":158,"_13":159,"_33":20,"_35":160,"_24":25,"_151":-5,"_27":161},{"_43":146,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_148":59,"_38":149,"_13":150,"_33":34,"_35":37,"_24":25,"_151":152,"_27":153},"36706aa0-b9f5-49bd-b483-9b8a992d8a3f","parentId","latest",["D",1789061262881],2,"label","guestbook-example",[28],"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).",[155],"pulls","branches","forks","envVars",{"_169":63,"_171":63},"connections",{"_169":63,"_170":63},"count","unfilledCount","emptyCount",{"_43":154,"_32":155,"_30":156,"_147":-5,"_41":42,"_40":157,"_148":59,"_38":178,"_13":159,"_33":20,"_35":160,"_24":25,"_151":-5,"_175":179,"_27":180},{"_43":146,"_32":28,"_30":31,"_147":-5,"_41":42,"_40":14,"_148":59,"_38":174,"_13":150,"_33":34,"_35":37,"_24":25,"_151":152,"_175":176,"_27":177},["D",1789061262881],"children",[],[28],["D",1789061186501],[],[155],["D",1769548632131],["D",1789519842404],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_18":56,"_108":109,"_110":25},{"_13":14,"_32":89,"_43":42,"_90":44,"_91":92,"_93":94,"_95":50,"_96":97,"_98":99,"_100":45,"_101":102},"ctx",{"_82":-5,"_132":219,"_220":221,"_222":223,"_224":25,"_225":25,"_226":25,"_227":59,"_228":-5,"_229":-7,"_230":-7,"_231":63,"_232":25,"_233":25,"_234":-5,"_235":25,"_236":25,"_237":25,"_238":-5},"ENV",{"_190":191,"_192":193,"_194":89,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218},"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"]

Diff · v13