\n \n \n \n\n",[18,89],"71867964-e634-4bdd-a3e1-c5032b24dd4d",["D",1784581063902],"\n",[18,95],"7e4be533-6312-42fe-ae15-7e71c026ce6e",["D",1784581063902],[18,100],"pulls","branches","forks","envVars",{"_96":26,"_234":26},"connections",{"_96":26,"_233":26},"unfilledCount","emptyCount",{"_34":200,"_13":18,"_75":110,"_44":-5,"_36":37,"_203":41,"_211":24,"_38":318,"_40":26,"_78":101,"_201":-5,"_80":30,"_204":-5,"_253":319,"_17":320},{"_34":223,"_13":100,"_75":99,"_44":110,"_36":37,"_203":41,"_211":24,"_38":315,"_40":26,"_78":101,"_201":-5,"_80":30,"_204":-5,"_253":316,"_17":317},{"_34":307,"_13":308,"_75":309,"_44":99,"_36":37,"_203":310,"_211":24,"_38":311,"_40":41,"_78":79,"_201":312,"_80":30,"_204":-5,"_253":313,"_17":314},{"_34":219,"_13":95,"_75":94,"_44":110,"_36":37,"_203":41,"_211":24,"_38":304,"_40":26,"_78":21,"_201":221,"_80":30,"_204":-5,"_253":305,"_17":306},{"_34":215,"_13":89,"_75":88,"_44":110,"_36":37,"_203":104,"_211":24,"_38":301,"_40":41,"_78":21,"_201":217,"_80":30,"_204":-5,"_253":302,"_17":303},{"_34":210,"_13":77,"_75":76,"_44":110,"_36":37,"_203":41,"_211":24,"_38":298,"_40":26,"_78":79,"_201":213,"_80":30,"_204":-5,"_253":299,"_17":300},{"_34":290,"_13":291,"_75":292,"_44":-5,"_36":37,"_203":293,"_211":24,"_38":294,"_40":41,"_78":21,"_201":295,"_80":30,"_204":-5,"_253":296,"_17":297},{"_34":281,"_13":282,"_75":283,"_44":-5,"_36":37,"_203":284,"_211":24,"_38":285,"_40":41,"_78":286,"_201":287,"_80":30,"_204":-5,"_253":288,"_17":289},{"_34":273,"_13":274,"_75":275,"_44":-5,"_36":37,"_203":276,"_211":24,"_38":277,"_40":26,"_78":79,"_201":278,"_80":30,"_204":-5,"_253":279,"_17":280},{"_34":264,"_13":265,"_75":266,"_44":-5,"_36":37,"_203":267,"_211":24,"_38":268,"_40":26,"_78":269,"_201":270,"_80":30,"_204":-5,"_253":271,"_17":272},{"_34":256,"_13":257,"_75":123,"_44":-5,"_36":37,"_203":258,"_211":24,"_38":259,"_40":41,"_78":260,"_201":261,"_80":30,"_204":-5,"_253":262,"_17":263},{"_34":247,"_13":248,"_75":249,"_44":-5,"_36":37,"_203":250,"_211":24,"_38":251,"_40":41,"_78":79,"_201":252,"_80":30,"_204":-5,"_253":254,"_17":255},"50aebcc8-5990-46e3-8c72-f641d683ec2a","seed.ts","c60ef932-847d-11f1-a9ae-1607ee4eb77e",10,["D",1784581138227],"import { addIdea, ensureDb } from \"./db.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nawait ensureDb();\nconst count = await sqlite.execute(\"SELECT COUNT(*) AS count FROM ideas\");\nif (Number(count.rows[0].count) === 0) {\n await addIdea(\"Record the ChatGPT plugin demo\", \"Show a useful app emerging from one conversation.\", \"script\");\n await addIdea(\"Invite the team to remix it\", \"Every UI should lead viewers back to its source.\", \"script\");\n await addIdea(\"Ship the daily idea digest\", \"Let the scheduled job turn a pile of thoughts into a ritual.\", \"script\");\n}\nconst total = await sqlite.execute(\"SELECT COUNT(*) AS count FROM ideas\");\nconsole.log(`Idea Inbox ready with ${total.rows[0].count} ideas`);\nexport default total.rows[0];\n","children",[],[248],"98585659-3b13-413e-ab2b-e27d52919a72","index.ts",6,["D",1784581116936],"http","import { Hono } from \"npm:hono\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { addIdea, listIdeas, toggleIdea } from \"./db.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.get(\"/api/health\", (c) => c.json({\n ok: true,\n service: \"Idea Inbox\",\n runtime: \"Val Town\",\n capabilities: [\"React\", \"Hono\", \"SQLite\", \"Blob\", \"Email\", \"Cron\"],\n}));\n\napp.get(\"/api/ideas\", async (c) => c.json({ ideas: await listIdeas() }));\n\napp.post(\"/api/ideas\", async (c) => {\n const body = await c.req.json();\n const title = String(body.title ?? \"\").trim();\n if (!title) return c.json({ error: \"title is required\" }, 400);\n const idea = await addIdea(title, String(body.note ?? \"\").trim(), \"web\");\n return c.json({ idea }, 201);\n});\n\napp.patch(\"/api/ideas/:id/toggle\", async (c) => {\n const idea = await toggleIdea(Number(c.req.param(\"id\")));\n return idea ? c.json({ idea }) : c.json({ error: \"not found\" }, 404);\n});\n\napp.get(\"/api/digest\", async (c) => {\n const digest = (await blob.getJSON(\"latest-digest\")) ?? {\n generatedAt: null,\n count: 0,\n ideas: [],\n };\n return c.json({ digest });\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n",[],[257],"d8587b75-0315-465b-b878-0f9a0ca85e38","email-inbox.ts","c6bfdb08-847d-11f1-a286-1607ee4eb77e",5,["D",1784581116530],"email","import { addIdea } from \"./db.ts\";\n\nexport default async function (message: Email) {\n const title = message.subject?.trim() || \"Idea by email\";\n const note = message.text?.trim() || \"Captured from an incoming email.\";\n const idea = await addIdea(title, note, \"email\");\n console.log(`Captured email idea #${idea.id} from ${message.from}`);\n return idea;\n}\n",[],[265],"45d02a6a-a922-481b-be2f-ec22b63e6b9a","db.ts","c6556ff2-847d-11f1-9475-1607ee4eb77e",3,["D",1784581115836],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type Idea = {\n id: number;\n title: string;\n note: string;\n source: string;\n status: string;\n created_at: string;\n};\n\nexport async function ensureDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ideas (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n note TEXT NOT NULL DEFAULT '',\n source TEXT NOT NULL DEFAULT 'web',\n status TEXT NOT NULL DEFAULT 'new',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )`);\n}\n\nexport async function listIdeas(): Promise {\n await ensureDb();\n const result = await sqlite.execute(\n \"SELECT id, title, note, source, status, created_at FROM ideas ORDER BY id DESC LIMIT 50\",\n );\n return result.rows as unknown as Idea[];\n}\n\nexport async function addIdea(title: string, note = \"\", source = \"web\") {\n await ensureDb();\n const result = await sqlite.execute({\n sql: \"INSERT INTO ideas (title, note, source) VALUES (?, ?, ?) RETURNING *\",\n args: [title, note, source],\n });\n return result.rows[0] as unknown as Idea;\n}\n\nexport async function toggleIdea(id: number) {\n await ensureDb();\n const result = await sqlite.execute({\n sql: `UPDATE ideas\n SET status = CASE WHEN status = 'done' THEN 'new' ELSE 'done' END\n WHERE id = ? RETURNING *`,\n args: [id],\n });\n return result.rows[0] as unknown as Idea | undefined;\n}\n",[],[274],"87dadc8e-e8cc-4086-85fb-f902daed3d80","daily-digest.ts","c686a478-847d-11f1-9475-1607ee4eb77e",11,["D",1784581161004],"interval","import { ensureDb } from \"./db.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (interval?: Interval) {\n await ensureDb();\n const since = interval?.lastRunAt ?? new Date(Date.now() - 24 * 60 * 60 * 1000);\n const result = await sqlite.execute({\n sql: \"SELECT title, source, created_at FROM ideas WHERE datetime(created_at) >= datetime(?) ORDER BY created_at DESC\",\n args: [since.toISOString()],\n });\n const digest = {\n generatedAt: new Date().toISOString(),\n since: since.toISOString(),\n count: result.rows.length,\n ideas: result.rows,\n };\n await blob.setJSON(\"latest-digest\", digest);\n console.log(`Daily digest generated: ${digest.count} new ideas`);\n return digest;\n}\n",[],[282],"9bb2befb-161a-424f-89a7-119e4f3979d4","README.md","019f8152-053c-769d-b242-1500ac1563b4",9,["D",1784581126216],"# Idea Inbox — ChatGPT plugin marketplace demo\n\nA tiny personal operations hub built entirely through the Val Town plugin.\n\n## The story\n\nIdeas arrive everywhere. This val gives them one home:\n\n- **Web UI:** capture, review, and complete ideas.\n- **HTTP API:** connect forms, agents, or any other app.\n- **SQLite:** durable, structured, val-scoped persistence.\n- **Email trigger:** forward an email and its subject/body becomes an idea.\n- **Scheduled job:** compile new ideas into a daily digest stored in Blob.\n- **Runnable script:** initialize the database with demo data.\n\nEverything is split into inspectable files and the live app links back to its source.\n\n## API\n\n- `GET /api/ideas`\n- `POST /api/ideas` with `{\"title\":\"...\",\"note\":\"...\"}`\n- `PATCH /api/ideas/:id/toggle`\n- `GET /api/digest`\n- `GET /api/health`\n\nThe scheduled job runs at 13:00 UTC (roughly morning in New York).\n",[],[291],["D",1784581063902],[],[18,77],["D",1784581117306],[],[18,89],["D",1784581063902],[],[18,95],"cb679398-bfe6-49de-99c4-8f46a9f7d40d","App.tsx","019f8152-053c-769d-b241-fba98c2bf375",8,["D",1784581117625],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\ntype Idea = {\n id: number;\n title: string;\n note: string;\n source: string;\n status: string;\n created_at: string;\n};\n\nconst sourceStyle: Record = {\n web: \"bg-blue-400/10 text-blue-300 border-blue-400/20\",\n email: \"bg-violet-400/10 text-violet-300 border-violet-400/20\",\n script: \"bg-amber-400/10 text-amber-300 border-amber-400/20\",\n};\n\nfunction Capability({ icon, label }: { icon: string; label: string }) {\n return (\n

{icon}

{label}

\n );\n}\n\nfunction IdeaCard({ idea, onToggle }: { idea: Idea; onToggle: () => void }) {\n return (\n \n

\n {idea.status === \"done\" ? \"✓\" : \"\"}\n

{idea.title}

\n {idea.note &&

{idea.note}

}\n

\n {idea.source}\n {new Date(idea.created_at + \"Z\").toLocaleDateString()}\n

\n \n );\n}\n\nexport function App() {\n const [ideas, setIdeas] = useState([]);\n const [title, setTitle] = useState(\"\");\n const [note, setNote] = useState(\"\");\n const [busy, setBusy] = useState(false);\n\n const refresh = async () => {\n const data = await fetch(\"/api/ideas\").then((r) => r.json());\n setIdeas(data.ideas);\n };\n\n useEffect(() => { refresh(); }, []);\n\n const submit = async (event: Event) => {\n event.preventDefault();\n if (!title.trim()) return;\n setBusy(true);\n await fetch(\"/api/ideas\", {\n method: \"POST\",\n headers: { \"content-type\": \"application/json\" },\n body: JSON.stringify({ title, note }),\n });\n setTitle(\"\");\n setNote(\"\");\n await refresh();\n setBusy(false);\n };\n\n const toggle = async (id: number) => {\n await fetch(`/api/ideas/${id}/toggle`, { method: \"PATCH\" });\n await refresh();\n };\n\n const open = ideas.filter((idea) => idea.status !== \"done\").length;\n\n return (\n

✦

Idea Inbox

running on Val Town

\n View source ↗\n

\n\n

\n Live full-stack val\n

Catch the thought.
Keep the momentum.

One quiet inbox for ideas arriving from the web, email, scripts, and scheduled automations.

\n\n \n\n

\n \n \n \n

\n\n

Today’s queue

{open} open {open === 1 ? \"idea\" : \"ideas\"}

\n \n

\n {ideas.length ? ideas.map((idea) => toggle(idea.id)}/>) : (\n

Your next good idea starts on the left.

\n )}\n

\n Click an idea to complete it\n Open JSON API →\n

\n\n \n

\n );\n}\n",[],[18,100,308],["D",1784581063902],[237],[18,100],["D",1784581063902],[236,238,239,240],[18],["D",1784581063902],["D",1789473745358],{"_11":12,"_166":83},{"_11":12,"_162":-5,"_82":83,"_31":81,"_163":164,"_165":30},{"_40":150,"_13":16,"_34":37,"_151":112,"_152":72,"_153":154,"_155":116,"_156":157,"_158":159,"_160":14,"_161":12},"ctx",{"_53":-5,"_187":359,"_360":361,"_362":363,"_364":30,"_365":30,"_366":30,"_367":24,"_368":-5,"_369":-7,"_370":-7,"_371":26,"_372":30,"_373":30,"_374":-5,"_375":30,"_376":30,"_377":30,"_378":-5},"ENV",{"_330":331,"_332":333,"_334":16,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358},"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"]

Catch the thought.Keep the momentum.

{open} open {open === 1 ? \"idea\" : \"ideas\"}

Catch the thought.
Keep the momentum.

History · frontend