[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_250":251,"_252":253},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":60,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",25,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","backend/db.ts","latestPath","fileId","03d04502-3170-11f1-a5cc-42dde27851f2","name","db.ts","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n//await createTables();\n\nexport async function insertYTUrl(\n url: string,\n title: string | null,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO YTLINKS (url, title, description) VALUES(:url, :title, :description)`,\n args: { url, title, description },\n });\n\n // await sqlite.execute({\n // sql: `insert into kv(key, value) values (:key, :value)`,\n // args: { key: \"specialkey\", value: \"specialvalue\" },\n // });\n}\n\nexport async function insertBook(\n title: string,\n author: string | null,\n description: string | null,\n genre: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO BKLINKS (title, author, description, genre) VALUES (:title, :author, :description, :genre)`,\n args: { title, author, description, genre },\n });\n}\n\nexport async function insertUncommonWord(\n term: string,\n description: string | null,\n notes: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO UNCOMMON_WORDS (term, description, notes) VALUES (:term, :description, :notes)`,\n args: { term, description, notes },\n });\n}\n\nexport async function insertGHubLink(\n url: string,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO GHUB (url, description) VALUES (:term, :description)`,\n args: { url, description },\n });\n}\n\nexport async function createTables() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS YTLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL UNIQUE,\n title TEXT NULL,\n description TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS BKLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n title TEXT NOT NULL,\n author TEXT NOT NULL,\n description TEXT NULL,\n genre TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS UNCOMMON_WORDS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n term TEXT NOT NULL,\n description TEXT NULL,\n notes TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n /* Add any other tables or migrations you want here\n\n However, you should know that SQLite has much more limited\n support for altering existing tables as compared to other databases.\n Often it's easier to create new tables with the schema you want, and then\n copy the data over. */\n ]);\n}","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n//await createTables();\n\nexport async function insertYTUrl(\n url: string,\n title: string | null,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO YTLINKS (url, title, description) VALUES(:url, :title, :description)`,\n args: { url, title, description },\n });\n\n // await sqlite.execute({\n // sql: `insert into kv(key, value) values (:key, :value)`,\n // args: { key: \"specialkey\", value: \"specialvalue\" },\n // });\n}\n\nexport async function insertBook(\n title: string,\n author: string | null,\n description: string | null,\n genre: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO BKLINKS (title, author, description, genre) VALUES (:title, :author, :description, :genre)`,\n args: { title, author, description, genre },\n });\n}\n\nexport async function insertUncommonWord(\n term: string,\n description: string | null,\n notes: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO UNCOMMON_WORDS (term, description, notes) VALUES (:term, :description, :notes)`,\n args: { term, description, notes },\n });\n}\n\nexport async function insertGHubLink(\n url: string,\n description: string | null,\n) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO GHUB (url, description) VALUES (:url, :description)`,\n args: { url, description },\n });\n}\n\nexport async function createTables() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS YTLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n url TEXT NOT NULL UNIQUE,\n title TEXT NULL,\n description TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS BKLINKS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n title TEXT NOT NULL,\n author TEXT NOT NULL,\n description TEXT NULL,\n genre TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n\n `CREATE TABLE IF NOT EXISTS UNCOMMON_WORDS (\n id INTEGER PRIMARY KEY AUTOINCREMENT, \n term TEXT NOT NULL,\n description TEXT NULL,\n notes TEXT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )`,\n /* Add any other tables or migrations you want here\n\n However, you should know that SQLite has much more limited\n support for altering existing tables as compared to other databases.\n Often it's easier to create new tables with the schema you want, and then\n copy the data over. */\n ]);\n}","createdAt",["D",1775619676352],"branchVersion","branchId","89f88876-3169-11f1-9094-42dde27851f2","id","89f035d6-3169-11f1-9094-42dde27851f2","khacks",["D",1775446478026],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Personal hacks","imageUrl","019d3acb-4266-73d5-b8a9-93ce4f16a9b3","pinnedFileId","019d60db-4d3b-744e-a4f9-a1cd54af5feb","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019d3acb-4266-73d5-b8a9-96af6d3b07cc","tursoName","89f035d6316911f1909442dde27851f2","tursoHostname","89f035d6316911f1909442dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789470042795],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":56,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",215,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","KMan","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzNCZDkxUG1lV2dqZEV1N1ljYXFxVUM1Ull2bSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":245,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":246,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":247,"_85":248,"_87":249,"_89":25},"tree",[175,177,184,185],"files",[175,176,177,178,179,180,181,182,183,184,185],"counts",{"_165":64,"_166":149,"_167":64,"_168":169,"_170":171},"contents",[131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":159,"_32":160,"_30":161,"_137":-5,"_42":43,"_41":162,"_139":60,"_39":163,"_13":149,"_34":157,"_36":-5,"_24":25,"_144":-5,"_27":164},{"_44":153,"_32":154,"_30":155,"_137":-5,"_42":43,"_41":149,"_139":60,"_39":156,"_13":64,"_34":157,"_36":-5,"_24":25,"_144":-5,"_27":158},{"_44":146,"_32":147,"_30":148,"_137":-5,"_42":43,"_41":149,"_139":60,"_39":150,"_13":64,"_34":20,"_36":151,"_24":25,"_144":-5,"_27":152},{"_44":135,"_32":136,"_30":58,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":140,"_13":141,"_34":142,"_36":143,"_24":25,"_144":46,"_27":145},"0b6c0c4e-32bd-11f1-8e24-42dde27851f2","index.ts","parentId",19,"latest",["D",1775592294576],9,"http","import { serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { insertBook, insertUncommonWord, insertYTUrl } from \"./backend/db.ts\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\napp.post(\"/books\", async (c) => {\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.title || typeof body.title !== \"string\") {\n return c.json({\n error: \"Request must include a 'title' property with a string value\",\n }, 400);\n }\n\n if (body.title.trim() === \"\") {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n\n insertBook(\n body.title,\n body.author,\n body.description ?? null,\n body.genre ?? null,\n );\n\n // Return the newly created phrase\n return c.json({\n message: \"Book saved successfully\",\n yturl: body.title,\n }, 200);\n } catch (error) {\n console.error(\"Error adding books:\", error);\n return c.json({ error: \"Failed to books\" }, 500);\n }\n});\n\napp.post(\"/uncommon\", async (c) => {\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.term || typeof body.term !== \"string\") {\n return c.json({\n error: \"Request must include a 'term' property with a string value\",\n }, 400);\n }\n\n if (body.term.trim() === \"\") {\n return c.json({ error: \"Term cannot be empty\" }, 400);\n }\n\n insertUncommonWord(body.term, body.description ?? null, body.notes ?? null);\n\n return c.json({\n message: \"Uncommon phrase saved successfully\",\n yturl: body.term,\n }, 200);\n } catch (error) {\n console.error(\"Error adding uncommon phrase:\", error);\n return c.json({ error: \"Failed to save the phrase\" }, 500);\n }\n});\n\napp.post(\"/ytube\", async (c) => {\n //await ensureTableExists();\n\n try {\n // Parse JSON body\n const body = await c.req.json().catch(() => null);\n\n // Validate input\n if (!body || typeof body !== \"object\") {\n return c.json({ error: \"Request body must be a valid JSON object\" }, 400);\n }\n\n if (!body.url || typeof body.url !== \"string\") {\n return c.json({\n error: \"Request must include a 'url' property with a string value\",\n }, 400);\n }\n\n if (body.url.trim() === \"\") {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n\n //https://www.youtube.com/oembed?url=\n const data = await fetch(\n `https://www.youtube.com/oembed?url=${body.url}&format=json`,\n );\n const jsonData = await data.json();\n\n insertYTUrl(body.url.trim(), jsonData.title, body.description ?? null);\n\n // Return the newly created phrase\n return c.json({\n message: \"YT Url saved successfully\",\n yturl: jsonData.title,\n }, 201);\n } catch (error) {\n console.error(\"Error adding YT url:\", error);\n return c.json({ error: \"Failed to save YT url\" }, 500);\n }\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","label",[136],"89fbc892-3169-11f1-9094-42dde27851f2","README.md","019d60db-4d3b-744e-a4f9-9d1d6b380c62",1,["D",1775446478026],"# React Hono Starter\n\nThis app is a starter template for client-side React and server-side Hono.\n\n## Getting started\n\nGet a copy of this starter template by clicking the **Remix** button in the\ntop-right.\n\n## How it works\n\n- The **entrypoint** is [`index.ts`](index.ts). That's the backend HTTP server,\n which also serves the all the frontend assets.\n\n- The **client-side entrypoint** is\n [`/frontend/index.html`](/frontend/index.html)\n - which in turn imports [`/frontend/index.tsx`](/frontend/index.tsx)\n - which in turn imports the React app from\n [`/frontend/components/App.tsx`](/frontend/components/App.tsx).\n\nSo if you wanted to get a sense of how this app comes together, we suggest\nreading the files in this order:\n\n[`index.ts`](index.ts) -> [`/frontend/index.html`](/frontend/index.html) ->\n[`/frontend/index.tsx`](/frontend/index.tsx) ->\n[`/frontend/components/App.tsx`](/frontend/components/App.tsx)\n\n## Further resources\n\n- [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a\n bigger example project, with a SQLite database table, queries, client-side\n CSS, a favicon, and shared code that runs on both client and server.",[147],"89fbc75c-3169-11f1-9094-42dde27851f2","frontend","019d60db-4d3b-744e-a4f9-99649d93cb85",["D",1775446478026],"directory",[154],"ff6af6c4-316f-11f1-88b8-42dde27851f2","backend","fd9c88d0-316f-11f1-ae4b-42dde27851f2",3,["D",1775449252133],[160],"pulls","branches","forks","envVars",{"_172":149,"_174":64},"connections",{"_172":64,"_173":64},"count","unfilledCount","emptyCount",{"_44":159,"_32":160,"_30":161,"_137":-5,"_42":43,"_41":162,"_139":60,"_39":242,"_13":149,"_34":157,"_36":-5,"_24":25,"_144":-5,"_187":243,"_27":244},{"_44":237,"_32":33,"_30":31,"_137":161,"_42":43,"_41":14,"_139":25,"_39":238,"_13":239,"_34":35,"_36":38,"_24":25,"_144":-5,"_187":240,"_27":241},{"_44":153,"_32":154,"_30":155,"_137":-5,"_42":43,"_41":149,"_139":60,"_39":234,"_13":64,"_34":157,"_36":-5,"_24":25,"_144":-5,"_187":235,"_27":236},{"_44":230,"_32":229,"_30":224,"_137":155,"_42":43,"_41":149,"_139":60,"_39":231,"_13":64,"_34":157,"_36":-5,"_24":25,"_144":-5,"_187":232,"_27":233},{"_44":221,"_32":222,"_30":223,"_137":224,"_42":43,"_41":149,"_139":60,"_39":225,"_13":64,"_34":35,"_36":226,"_24":25,"_144":-5,"_187":227,"_27":228},{"_44":214,"_32":215,"_30":216,"_137":155,"_42":43,"_41":149,"_139":60,"_39":217,"_13":64,"_34":20,"_36":218,"_24":25,"_144":-5,"_187":219,"_27":220},{"_44":207,"_32":208,"_30":209,"_137":155,"_42":43,"_41":149,"_139":25,"_39":210,"_13":64,"_34":20,"_36":211,"_24":25,"_144":-5,"_187":212,"_27":213},{"_44":200,"_32":201,"_30":202,"_137":155,"_42":43,"_41":149,"_139":25,"_39":203,"_13":64,"_34":35,"_36":204,"_24":25,"_144":-5,"_187":205,"_27":206},{"_44":193,"_32":194,"_30":195,"_137":155,"_42":43,"_41":149,"_139":60,"_39":196,"_13":64,"_34":20,"_36":197,"_24":25,"_144":-5,"_187":198,"_27":199},{"_44":146,"_32":147,"_30":148,"_137":-5,"_42":43,"_41":149,"_139":60,"_39":190,"_13":64,"_34":20,"_36":151,"_24":25,"_144":-5,"_187":191,"_27":192},{"_44":135,"_32":136,"_30":58,"_137":-5,"_42":43,"_41":138,"_139":25,"_39":186,"_13":141,"_34":142,"_36":143,"_24":25,"_144":46,"_187":188,"_27":189},["D",1775592294576],"children",[],[136],["D",1775446478026],[],[147],"89fbc446-3169-11f1-9094-42dde27851f2","style.css","019d60db-4d3b-744e-a4f9-9411665e62ef",["D",1775446478026],"body {\n font-family: -apple-system, Arial, sans-serif;\n color: #333;\n padding: 20px;\n}\n\nbutton {\n background-color: #4a90e2;\n color: white;\n border: none;\n padding: 8px 16px;\n border-radius: 4px;\n cursor: pointer;\n}\n\nbutton:hover {\n background-color: #357ae8;\n}",[],[154,194],"89fbba32-3169-11f1-9094-42dde27851f2","index.tsx","019d60db-4d3b-744e-a4f9-93129402de20",["D",1775446478026],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[154,201],"89fbb550-3169-11f1-9094-42dde27851f2","index.html","019d60db-4d3b-744e-a4f9-8e243d39f3d6",["D",1775446478026],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[154,208],"89fbaf38-3169-11f1-9094-42dde27851f2","favicon.svg","019d60db-4d3b-744e-a4f9-89ecb6740d40",["D",1775446478026],"\n",[],[154,215],"89fb886e-3169-11f1-9094-42dde27851f2","App.tsx","019d60db-4d3a-758a-85f2-055b8e771277","019d60db-4d3b-744e-a4f9-875ac38dca3b",["D",1775446478026],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [clicked, setClicked] = useState(0);\n return (\n

Val Town React + Hono Starter

\n I've been clicked times\n

\n );\n}",[],[154,229,222],"components","89fbacb8-3169-11f1-9094-42dde27851f2",["D",1775446478026],[179],[154,229],["D",1775446478026],[178,180,181,182,183],[154],"cc34a654-32fc-11f1-974f-42b51c65c3df",["D",1775619676352],12,[],[160,33],["D",1775449252133],[176],[160],["D",1775446478026],["D",1789470042795],{"_101":100,"_108":104},{"_101":100,"_102":-5,"_103":104,"_18":56,"_105":106,"_107":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_128":283,"_284":285,"_286":287,"_288":25,"_289":25,"_290":25,"_291":60,"_292":-5,"_293":-7,"_294":-7,"_295":64,"_296":25,"_297":25,"_298":-5,"_299":25,"_300":25,"_301":25,"_302":-5},"ENV",{"_254":255,"_256":257,"_258":91,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282},"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 · v25