[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_220":221,"_222":223},"routes/_app.x.$handle.$name",{"_109":108,"_40":53,"_118":99,"_34":119,"_13":14,"_120":-5,"_11":121,"_122":123,"_124":125,"_126":127,"_128":129,"_26":-5,"_130":-5,"_131":-5,"_132":33,"_133":134,"_135":31,"_136":-5,"_137":-5,"_138":139},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_51":52,"_40":53,"_46":54,"_55":-5,"_56":33,"_57":58,"_59":58,"_60":61,"_62":63,"_19":64,"_65":66,"_67":31,"_68":31,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":79,"_80":81,"_82":83,"_84":83,"_85":86,"_87":86,"_88":86,"_89":83,"_90":83,"_91":92,"_93":94,"_95":96,"_97":33},"version",102,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","87d8a3d4-d50d-40a6-a60c-114becf21234","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":33,"_34":35,"_36":37},"file",{"_38":39,"_40":35,"_41":42,"_43":45,"_46":47,"_48":14,"_49":50,"_30":33},"previous",{"_38":39,"_40":35,"_41":42,"_43":44},"deleted",true,"deletedHere",false,"path","migration-generic.ts","latestPath","migration.ts","fileId","0b3ba990-0d2f-11f1-a92f-42dde27851f2","name","fileType","script","content","// SQLite migration to copy any 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 sqlite_master\nconst { rows: schemaRows } = await globalSqlite.execute({\n sql: `SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ?;`,\n args: [TABLE],\n});\n\nconsole.log(\"schemaRows:\", JSON.stringify(schemaRows));\n\nif (schemaRows.length === 0) {\n throw new Error(`Table \"${TABLE}\" not found in account-scoped database`);\n}\n\nconst createTableSql = (schemaRows[0] as any[])[0] as string;\n\n// 2. Create the table in the val-scoped database\nawait scopedSqlite.execute(createTableSql);\n\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.name as string);\nconsole.log(`📋 Columns: ${columns.join(\", \")}`);\n\n// 4. Fetch all rows from the account-scoped (global) database\nconst { rows } = await globalSqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id;`);\n\nconsole.log(`📦 Found ${rows.length} rows in account-scoped database`);\n\nif (rows.length === 0) {\n console.log(\"Nothing to migrate.\");\n} else {\n // 5. Insert all rows into the val-scoped database\n const placeholders = columns.map(() => \"?\").join(\", \");\n const columnList = columns.join(\", \");\n\n const CHUNK_SIZE = 100;\n for (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((col) => (row as any)[col]),\n })),\n );\n console.log(` Inserted rows ${i + 1}–${i + chunk.length}`);\n }\n\n console.log(`✅ Migrated ${rows.length} rows to val-scoped database`);\n}\n\n// 6. Verify\nconst { rows: migratedRows } = await scopedSqlite.execute(\n `SELECT status, COUNT(*) as count FROM ${TABLE} GROUP BY status;`,\n);\n\nconsole.log(`📊 Val-scoped database summary:`);\nfor (const row of migratedRows as any[]) {\n console.log(` ${(row as any).status}: ${(row as any).count}`);\n}","// SQLite migration to copy any 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 sqlite_master\nconst { rows: schemaRows } = await globalSqlite.execute({\n sql: `SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ?;`,\n args: [TABLE],\n});\n\nconsole.log(\"schemaRows:\", JSON.stringify(schemaRows));\n\nif (schemaRows.length === 0) {\n throw new Error(`Table \"${TABLE}\" not found in account-scoped database`);\n}\n\nconst createTableSql = (schemaRows[0] as any[])[0] as string;\n\n// 2. Create the table in the val-scoped database\nawait scopedSqlite.execute(createTableSql);\n\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 (global) database\nconst { rows } = await globalSqlite.execute(`SELECT * FROM ${TABLE} ORDER BY id;`);\n\nconsole.log(`📦 Found ${rows.length} rows in account-scoped database`);\n\nif (rows.length === 0) {\n console.log(\"Nothing to migrate.\");\n} else {\n // 5. Insert all rows into the val-scoped database\n const placeholders = columns.map(() => \"?\").join(\", \");\n const columnList = columns.join(\", \");\n\n const CHUNK_SIZE = 100;\n for (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((col) => (row as any)[col]),\n })),\n );\n console.log(` Inserted rows ${i + 1}–${i + chunk.length}`);\n }\n\n console.log(`✅ Migrated ${rows.length} rows to val-scoped database`);\n}\n\n// 6. Verify\nconst { rows: migratedRows } = await scopedSqlite.execute(\n `SELECT status, COUNT(*) as count FROM ${TABLE} GROUP BY status;`,\n);\n\nconsole.log(`📊 Val-scoped database summary:`);\nfor (const row of migratedRows as any[]) {\n console.log(` ${(row as any).status}: ${(row as any).count}`);\n}","createdAt",["D",1771464540929],"branchVersion","branchId","87a0c02c-a120-11f0-9e52-0224a6c84d84","id","87a065c8-a120-11f0-9e52-0224a6c84d84","tld-wiki",["D",1759582153490],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","dotcom.press/tld-wiki","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/81019705-4b87-440e-b1a1-c202e2b41100/square512?exp=1789549199&sig=501d64ad4bc7987d3535d88fa2a0f123569212f6adcc78910c76a843a22c3c0b","6906d0a1-0165-46b9-8717-60dfd935316a","pinnedFileId","87a356f2-a120-11f0-9e52-0224a6c84d84","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",{"_109":108,"_117":113},"org",{"_109":108,"_110":111,"_112":113,"_19":64,"_114":115,"_116":33},"branch",{"_13":98,"_40":99,"_51":50,"_100":52,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":53,"_107":108},"isOwned",125,"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=1789549199&sig=5dcf94cfebbbd82fe7301444629b792d7a556aae85beaef17cc9278c3addc60f","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_51":52,"_40":53,"_46":215,"_55":-5,"_56":33,"_57":58,"_59":58,"_60":61,"_62":63,"_19":64,"_65":66,"_67":31,"_68":31,"_69":-5,"_70":71,"_72":73,"_74":75,"_76":77,"_78":216,"_80":81,"_82":83,"_84":83,"_85":86,"_87":86,"_88":86,"_89":83,"_90":83,"_91":217,"_93":218,"_95":219,"_97":33},"tree",[194,195,196,197,198],"files",[194,195,196,197,198],"counts",{"_184":81,"_185":71,"_186":81,"_187":188,"_189":190},"contents",[140,141,142,143,144],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_51":176,"_40":177,"_38":178,"_148":-5,"_49":50,"_48":179,"_150":33,"_46":180,"_13":181,"_41":26,"_43":182,"_30":33,"_154":-5,"_34":183},{"_51":168,"_40":169,"_38":66,"_148":-5,"_49":50,"_48":170,"_150":33,"_46":171,"_13":172,"_41":173,"_43":174,"_30":33,"_154":53,"_34":175},{"_51":164,"_40":35,"_38":39,"_148":-5,"_49":50,"_48":14,"_150":33,"_46":165,"_13":166,"_41":42,"_43":45,"_30":33,"_154":-5,"_34":167},{"_51":156,"_40":157,"_38":158,"_148":-5,"_49":50,"_48":159,"_150":33,"_46":160,"_13":161,"_41":42,"_43":162,"_30":33,"_154":-5,"_34":163},{"_51":145,"_40":146,"_38":147,"_148":-5,"_49":50,"_48":149,"_150":33,"_46":151,"_13":152,"_41":42,"_43":153,"_30":33,"_154":-5,"_34":155},"89fb87b6-a13a-11f0-87bc-0224a6c84d84","sqlite.ts","8e80064c-a124-11f0-a83f-0224a6c84d84","parentId",62,"latest",["D",1759593324349],21,"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",[146],"561a2e82-0d2f-11f1-b8a0-42dde27851f2","migration-manual.ts","3213cfc6-0d2e-11f1-b14f-42dde27851f2",93,["D",1771463238426],7,"// SQLite migration to manually copy tld_wiki 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\n// 1. Create the new table in the val-scoped database\nawait scopedSqlite.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(\"✅ Created tld_wiki table in val-scoped database\");\n\n// 2. Fetch all rows from the account-scoped database\nconst { rows } = await globalSqlite.execute(`\n SELECT id, tld, email, name, entry, submitted_at, approved_at, status\n FROM tld_wiki\n ORDER BY id;\n`);\n\nconsole.log(`📦 Found ${rows.length} rows in account-scoped database`);\n\nif (rows.length === 0) {\n console.log(\"Nothing to migrate.\");\n} else {\n // 3. Insert all rows into the val-scoped database, preserving ids and timestamps\n await scopedSqlite.batch(\n (rows as any[]).map((row) => ({\n sql: `\n INSERT INTO tld_wiki (id, tld, email, name, entry, submitted_at, approved_at, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?);\n `,\n args: [\n row[0], // id\n row[1], // tld\n row[2], // email\n row[3], // name\n row[4], // entry\n row[5], // submitted_at\n row[6], // approved_at\n row[7], // status\n ],\n })),\n );\n\n console.log(`✅ Migrated ${rows.length} rows to val-scoped database`);\n}\n\n// 4. Verify\nconst { rows: migratedRows } = await scopedSqlite.execute(`\n SELECT status, COUNT(*) as count FROM tld_wiki GROUP BY status;\n`);\n\nconsole.log(\"📊 Val-scoped database summary:\");\nfor (const row of migratedRows as any[]) {\n console.log(` ${row[0]}: ${row[1]}`);\n}",[157],"5e747a1c-0d32-11f1-93a4-42dde27851f2",["D",1771464540929],12,[35],"c172c59c-0d2d-11f1-918b-42dde27851f2","main.ts",81,["D",1771462559530],46,"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;",[169],"63805312-a146-11f0-aeb0-0224a6c84d84","README.md","c2cd82e8-a143-11f0-b151-0224a6c84d84",73,["D",1759598413750],6,"## 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.",[177],"pulls","branches","forks","envVars",{"_191":71,"_193":81},"connections",{"_191":81,"_192":81},"count","unfilledCount","emptyCount",{"_51":176,"_40":177,"_38":178,"_148":-5,"_49":50,"_48":179,"_150":33,"_46":212,"_13":181,"_41":26,"_43":182,"_30":33,"_154":-5,"_200":213,"_34":214},{"_51":168,"_40":169,"_38":66,"_148":-5,"_49":50,"_48":170,"_150":33,"_46":209,"_13":172,"_41":173,"_43":174,"_30":33,"_154":53,"_200":210,"_34":211},{"_51":164,"_40":35,"_38":39,"_148":-5,"_49":50,"_48":14,"_150":33,"_46":206,"_13":166,"_41":42,"_43":45,"_30":33,"_154":-5,"_200":207,"_34":208},{"_51":156,"_40":157,"_38":158,"_148":-5,"_49":50,"_48":159,"_150":33,"_46":203,"_13":161,"_41":42,"_43":162,"_30":33,"_154":-5,"_200":204,"_34":205},{"_51":145,"_40":146,"_38":147,"_148":-5,"_49":50,"_48":149,"_150":33,"_46":199,"_13":152,"_41":42,"_43":153,"_30":33,"_154":-5,"_200":201,"_34":202},["D",1759593324349],"children",[],[146],["D",1771463238426],[],[157],["D",1771464540929],[],[35],["D",1771462559530],[],[169],["D",1759598413750],[],[177],["D",1759582153490],["D",1789536037138],{"_109":108,"_117":113},{"_109":108,"_110":111,"_112":113,"_19":64,"_114":115,"_116":33},{"_13":98,"_40":99,"_51":50,"_100":52,"_101":-5,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":53,"_107":108},"ctx",{"_91":-5,"_137":253,"_254":255,"_256":257,"_258":33,"_259":33,"_260":33,"_261":31,"_262":-5,"_263":-7,"_264":-7,"_265":81,"_266":33,"_267":33,"_268":-5,"_269":33,"_270":33,"_271":33,"_272":-5},"ENV",{"_224":225,"_226":227,"_228":99,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252},"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 · v102