[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_196":197,"_198":199},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_149":-5,"_20":150,"_22":151,"_152":153,"_154":155,"_25":156,"_24":-5,"_157":-5,"_158":-5,"_159":55,"_160":161,"_162":46,"_163":-5,"_164":-5,"_165":166},"routes/_app.x.$handle.$name.branch.$branch.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","pmillspaugh","name","tld-wiki","branchName","main","version","path","","project",{"_35":88,"_13":14,"_47":89,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":96,"_97":98,"_99":100,"_101":60,"_102":46,"_103":46,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":114,"_115":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":127,"_128":129,"_130":131,"_132":55},"tree",[75,76,77],"file","contents",[32,33,34],"upstream","pull","ahead","behind","envVars",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_18":74},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":14,"_18":66},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","463c98f4-16ff-11f1-97a4-42dde27851f2","sqlite.ts","fileId","8e80064c-a124-11f0-a83f-0224a6c84d84","parentId","branchId","87a0c02c-a120-11f0-9e52-0224a6c84d84","branchVersion",119,"latest",true,"createdAt",["D",1772542107592],22,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// await sqlite.execute(`\n// CREATE TABLE IF NOT EXISTS tld_wiki (\n// id INTEGER PRIMARY KEY AUTOINCREMENT,\n// tld TEXT NOT NULL,\n// email TEXT NOT NULL,\n// name TEXT NOT NULL,\n// entry TEXT NOT NULL,\n// submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n// approved_at TIMESTAMP,\n// status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'approved', 'rejected'))\n// );\n// `);\n\nconsole.log(await sqlite.execute(`SELECT * FROM tld_wiki;`));","deleted",false,"label",[37],"1e615f01-fd59-45f5-ae13-fb38c1982c34","main.ts","87a356f2-a120-11f0-9e52-0224a6c84d84",125,["D",1787929487825],49,"http","import { Context, Hono } from \"npm:hono@3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c: Context) => {\n return c.redirect(\"https://dotcom.press/tld-wiki\");\n});\n\napp.post(\"/submit\", async (c: Context) => {\n try {\n const formData = await c.req.formData();\n const tld = formData.get(\"tld\") as string;\n const email = formData.get(\"email\") as string;\n const name = formData.get(\"name\") as string;\n const entry = formData.get(\"entry\") as string;\n\n console.log(\"Received wiki entry:\", {\n tld,\n entry,\n name,\n email,\n submittedAt: new Date().toISOString(),\n });\n\n // There's also client-side validation, but just in case...\n if (!entry || !name || !email || !tld) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n const result = await sqlite.execute({\n sql:\n `INSERT INTO tld_wiki (tld, email, name, entry) VALUES (?, ?, ?, ?);`,\n args: [tld, email, name, entry],\n });\n\n const id = result.lastInsertRowid;\n const secret = Deno.env.get(\"MODERATOR_SECRET\");\n\n await sendEmail({\n subject: `TLD wiki submission for ${tld} from ${email}`,\n html: `\n

${name}

${entry}

\n APPROVE\n / \n REJECT\n `,\n });\n\n return c.json({\n success: true,\n message: \"Entry submitted successfully\",\n });\n } catch (error) {\n console.error(\"Error processing form submission:\", error);\n return c.json({ error: \"Internal server error\" }, 500);\n }\n});\n\napp.get(\"/tld/:tld\", async (c: Context) => {\n try {\n const tld = c.req.param(\"tld\");\n\n const { rows } = await sqlite.execute({\n sql: `\n SELECT id, name, entry, submitted_at \n FROM tld_wiki \n WHERE tld = ? AND status = 'approved'\n ORDER BY submitted_at DESC\n `,\n args: [tld],\n });\n\n const entries = rows.map((row: any[]) => ({\n name: row[1],\n entry: row[2],\n submitted_at: row[3],\n }));\n\n return c.json(entries);\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to fetch entries\" }, 500);\n }\n});\n\napp.get(\"/approve/:id\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n const secret = c.req.query(\"secret\");\n\n if (secret !== Deno.env.get(\"MODERATOR_SECRET\")) {\n return c.json({ error: \"Not authorized to approve\" }, 401);\n }\n\n await sqlite.execute({\n sql: `\n UPDATE tld_wiki\n SET status = 'approved', approved_at = CURRENT_TIMESTAMP\n WHERE id = ?;\n `,\n args: [id],\n });\n\n return c.json({\n success: true,\n message: \"Entry approved successfully\",\n });\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to approve entry\" }, 500);\n }\n});\n\napp.get(\"/reject/:id\", async (c: Context) => {\n try {\n const id = c.req.param(\"id\");\n const secret = c.req.query(\"secret\");\n\n if (secret !== Deno.env.get(\"MODERATOR_SECRET\")) {\n return c.json({ error: \"Not authorized to reject\" }, 401);\n }\n\n await sqlite.execute({\n sql: `\n UPDATE tld_wiki\n SET status = 'rejected'\n WHERE id = ?;\n `,\n args: [id],\n });\n\n return c.json({\n success: true,\n message: \"Entry rejected successfully\",\n });\n } catch (error) {\n console.error(\"Error fetching entries:\", error);\n return c.json({ error: \"Failed to reject entry\" }, 500);\n }\n});\n\nexport default app.fetch;",[59],"33f008b6-31bc-11f1-9146-42dde27851f2","README.md","c2cd82e8-a143-11f0-b151-0224a6c84d84",124,["D",1775481981981],9,"## TLD wiki\n\nHosted at [dotcom.press/tld-wiki](https://dotcom.press/tld-wiki).\n\nSubmit wiki entries for any TLD, e.g. interesting websites that use it, personal\nor company anecdotes, or links to articles.\n\nIncludes all 1,592 TLDs from\n[IANA's root zone database](https://www.iana.org/domains/root/db), refreshed\ndaily from Eric Case's [iana-data](https://github.com/case/iana-data) repo\n(thanks, Eric!).\n\n## How it works\n\nThis val uses a Hono router from its HTTP endpoint to submit, approve/reject,\nand fetch wiki submissions. Entries are stored using SQLite.",[68],{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_79":86,"_18":87},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":14,"_79":83,"_18":84},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":80,"_18":81},["D",1772542107592],"children",[],[37],["D",1787929487825],[],[59],["D",1775481981981],[],[68],"87a065c8-a120-11f0-9e52-0224a6c84d84",["D",1759582153490],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","dotcom.press/tld-wiki","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/81019705-4b87-440e-b1a1-c202e2b41100/square512?exp=1789563599&sig=8d7c2a0137a9fa99577f8cc7bd45634ef423b8d6c4f6da6e206a05f07a9f4224","userId","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","631c5cff-7089-4994-8427-c7580df789cd","tursoName","87a065c8a12011f09e520224a6c84d84","tursoHostname","87a065c8a12011f09e520224a6c84d84-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789536037138],"pinned",0,"userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_148":144},"org",{"_11":12,"_141":142,"_143":144,"_99":100,"_145":146,"_147":55},"branch",{"_17":61,"_13":16,"_35":42,"_133":88,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Pete Millspaugh","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c3c0aadf-86a9-4c2e-ef01-fb649d6fb000/square512?exp=1789563599&sig=adf1a5ac0fa2e9cdf8971f11f995711c7d7d47e9c24a087fa25160e15a044d6a","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":88,"_13":14,"_47":191,"_90":-5,"_91":55,"_92":93,"_94":93,"_95":96,"_97":98,"_99":100,"_101":60,"_102":46,"_103":46,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":192,"_115":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_126":193,"_128":194,"_130":195,"_132":55},[182,183,184],"files",[182,183,184],"counts",{"_173":116,"_174":106,"_175":116,"_31":176,"_177":178},[167,168,169],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":71,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_18":172},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":62,"_17":63,"_50":64,"_52":65,"_54":55,"_56":14,"_18":171},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":170},[37],[59],[68],"pulls","branches","forks",{"_179":106,"_181":116},"connections",{"_179":116,"_180":116},"count","unfilledCount","emptyCount",{"_35":67,"_13":68,"_38":69,"_40":-5,"_41":42,"_43":70,"_45":46,"_47":85,"_17":72,"_50":24,"_52":73,"_54":55,"_56":-5,"_79":189,"_18":190},{"_35":58,"_13":59,"_38":60,"_40":-5,"_41":42,"_43":61,"_45":46,"_47":82,"_17":63,"_50":64,"_52":65,"_54":55,"_56":14,"_79":187,"_18":188},{"_35":36,"_13":37,"_38":39,"_40":-5,"_41":42,"_43":44,"_45":46,"_47":78,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_79":185,"_18":186},[],[37],[],[59],[],[68],["D",1759582153490],["D",1789536037138],{"_11":12,"_148":144},{"_11":12,"_141":142,"_143":144,"_99":100,"_145":146,"_147":55},{"_17":61,"_13":16,"_35":42,"_133":88,"_134":-5,"_135":-5,"_136":-5,"_137":-5,"_138":-5,"_139":14,"_140":12},"ctx",{"_126":-5,"_164":229,"_230":231,"_232":233,"_234":55,"_235":55,"_236":55,"_237":46,"_238":-5,"_239":-7,"_240":-7,"_241":116,"_242":55,"_243":55,"_244":-5,"_245":55,"_246":55,"_247":55,"_248":-5},"ENV",{"_200":201,"_202":203,"_204":16,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228},"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