[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_104":103,"_32":50,"_113":94,"_27":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_21":-5,"_125":-5,"_126":-5,"_127":25,"_128":129,"_130":131,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":-5,"_63":25,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":25},"version",4,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":21,"_34":35,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","README.md","latestPath","fileId","bc690c9e-0d34-11f1-8c29-42dde27851f2","name","fileType","content","## 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) (as of October\n4, 2025).\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.","createdAt",["D",1771465557557],"branchVersion","branchId","b075ce9a-0d34-11f1-bd64-42dde27851f2",{"_30":44,"_32":42,"_33":45,"_34":46,"_36":47,"_38":14,"_39":40,"_24":25},"migration.ts","migrate.ts","bc68d8e6-0d34-11f1-8c29-42dde27851f2","script","// SQLite migration to copy table from account-scoped SQLite to val-scoped SQLite\n// https://docs.val.town/reference/std/sqlite/usage\n\nimport { sqlite as globalSqlite } from \"https://esm.town/v/std/sqlite\";\nimport { sqlite as scopedSqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst TABLE = \"tld_wiki\";\n\n// 1. Get the original CREATE TABLE statement from account-scoped database\nconst { rows: schemaRows } = await globalSqlite.execute({\n sql: `SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ?;`,\n args: [TABLE],\n});\n\nif (schemaRows.length === 0) {\n throw new Error(`Table \"${TABLE}\" not found`);\n}\n\n// 2. Create the table in the val-scoped database\nconst createTableSql = (schemaRows[0] as any[])[0] as string;\nconst idempotentSql = createTableSql\n .replace(/IF NOT EXISTS\\s*/i, \"\")\n .replace(/CREATE TABLE/i, \"CREATE TABLE IF NOT EXISTS\");\n\nawait scopedSqlite.execute(idempotentSql);\nconsole.log(`✅ Created table \"${TABLE}\" in val-scoped database`);\n\n// 3. Fetch column names via PRAGMA\nconst { rows: pragmaRows } = await globalSqlite.execute({\n sql: `PRAGMA table_info(${TABLE});`,\n args: [],\n});\n\nconst columns = (pragmaRows as any[]).map((row) => row[1] as string);\nconsole.log(`📋 Columns: ${columns.join(\", \")}`);\n\n// 4. Fetch all rows from the account-scoped database\nconst { rows } = await globalSqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id;`);\nconsole.log(`📦 Found ${rows.length} rows`);\n\n// 5. Insert all rows into the val-scoped database\nconst placeholders = columns.map(() => \"?\").join(\", \");\nconst columnList = columns.join(\", \");\nconst CHUNK_SIZE = 100;\n\nfor (let i = 0; i < rows.length; i += CHUNK_SIZE) {\n const chunk = (rows as any[][]).slice(i, i + CHUNK_SIZE);\n await scopedSqlite.batch(\n chunk.map((row) => ({\n sql: `INSERT INTO ${TABLE} (${columnList}) VALUES (${placeholders});`,\n args: columns.map((_, i) => (row as any[])[i]),\n })),\n );\n console.log(`📩 Inserted rows ${i + 1}–${i + chunk.length}`);\n}\n\n\n// 6. Verify\nconst { rows: migratedRows } = await scopedSqlite.execute(\n `SELECT COUNT(*) as count FROM ${TABLE};`,\n);\nconsole.log(`✅ Migrated ${migratedRows.length} rows to val-scoped database`);",["D",1771465557557],"id","b06fc6da-0d34-11f1-bd64-42dde27851f2","copy-sqlite-table",["D",1771465537433],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Copy database tables from account-scoped to val-scoped SQLite","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/2b27439f-ea66-4f6d-3dc3-7a7a423f0600/square512?exp=1789552799&sig=88120ea777f6128cf083cc32bf13fc863d862590f53b4d23003164d38234539e","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",1,"orgId","631c5cff-7089-4994-8427-c7580df789cd","tursoName","b06fc6da0d3411f1bd6442dde27851f2","tursoHostname","b06fc6da0d3411f1bd6442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789527643940],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_18":61,"_109":110,"_111":25},"branch",{"_13":93,"_32":94,"_48":40,"_95":49,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":50,"_102":103},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","pmillspaugh","handle","displayName","Pete Millspaugh","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c3c0aadf-86a9-4c2e-ef01-fb649d6fb000/square512?exp=1789552799&sig=0422fb87fcd64231279bd51f44fe4022960366a004f3299609904c4f2c4714df","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":190,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":60,"_18":61,"_62":-5,"_63":25,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":191,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":192,"_88":193,"_90":194,"_92":25},"tree",[173,174,175,176],"files",[173,174,175,176],"counts",{"_163":146,"_164":67,"_165":67,"_166":167,"_168":169},"contents",[136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":160,"_32":28,"_30":31,"_143":-5,"_39":40,"_38":14,"_144":25,"_36":161,"_13":146,"_33":21,"_34":35,"_24":25,"_148":-5,"_27":162},{"_48":153,"_32":154,"_30":155,"_143":-5,"_39":40,"_38":67,"_144":25,"_36":156,"_13":146,"_33":157,"_34":158,"_24":25,"_148":-5,"_27":159},{"_48":150,"_32":42,"_30":44,"_143":-5,"_39":40,"_38":14,"_144":25,"_36":151,"_13":146,"_33":45,"_34":46,"_24":25,"_148":-5,"_27":152},{"_48":140,"_32":141,"_30":142,"_143":-5,"_39":40,"_38":67,"_144":25,"_36":145,"_13":146,"_33":45,"_34":147,"_24":25,"_148":-5,"_27":149},"b07a7bd4-0d34-11f1-bd64-42dde27851f2","sqlite.ts","019c7392-f7fc-752e-a41e-9444c0550f18","parentId","latest",["D",1771465537433],0,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\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;`));","label",[141],"bc68d828-0d34-11f1-8c29-42dde27851f2",["D",1771465557557],[42],"b07a53a2-0d34-11f1-bd64-42dde27851f2","main.ts","019c7392-f7fc-752e-a41e-8d86f7258bb0",["D",1771465537433],"http","import { Context, Hono } from \"npm:hono@3\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { email as sendEmail } from \"https://esm.town/v/std/email\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c: Context) => {\n return c.html(\n `,`,\n );\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;",[154],"bc690c12-0d34-11f1-8c29-42dde27851f2",["D",1771465557557],[28],"pulls","branches","forks","envVars",{"_170":146,"_172":146},"connections",{"_170":146,"_171":146},"count","unfilledCount","emptyCount",{"_48":160,"_32":28,"_30":31,"_143":-5,"_39":40,"_38":14,"_144":25,"_36":187,"_13":146,"_33":21,"_34":35,"_24":25,"_148":-5,"_178":188,"_27":189},{"_48":153,"_32":154,"_30":155,"_143":-5,"_39":40,"_38":67,"_144":25,"_36":184,"_13":146,"_33":157,"_34":158,"_24":25,"_148":-5,"_178":185,"_27":186},{"_48":150,"_32":42,"_30":44,"_143":-5,"_39":40,"_38":14,"_144":25,"_36":181,"_13":146,"_33":45,"_34":46,"_24":25,"_148":-5,"_178":182,"_27":183},{"_48":140,"_32":141,"_30":142,"_143":-5,"_39":40,"_38":67,"_144":25,"_36":177,"_13":146,"_33":45,"_34":147,"_24":25,"_148":-5,"_178":179,"_27":180},["D",1771465537433],"children",[],[141],["D",1771465557557],[],[42],["D",1771465537433],[],[154],["D",1771465557557],[],[28],["D",1771465537433],["D",1789527643940],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_18":61,"_109":110,"_111":25},{"_13":93,"_32":94,"_48":40,"_95":49,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":50,"_102":103},"ctx",{"_86":-5,"_133":228,"_229":230,"_231":232,"_233":25,"_234":25,"_235":25,"_236":131,"_237":-5,"_238":-7,"_239":-7,"_240":146,"_241":25,"_242":25,"_243":-5,"_244":25,"_245":25,"_246":25,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":94,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 · v4