LUKE HEADROOM / Editorial Desk

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_158":159,"_160":161},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","a8a4fe36-7fa1-11f1-8949-1607ee4eb77e","name","fileType","http","content","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\nlet ready: Promise | undefined;\nconst now = () => new Date().toISOString();\n\nasync function init() {\n if (ready) return ready;\n ready = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS review_items (\n id TEXT PRIMARY KEY, source_type TEXT NOT NULL, headline TEXT NOT NULL,\n source_url TEXT NOT NULL, summary TEXT NOT NULL, source_excerpt TEXT NOT NULL DEFAULT '',\n draft TEXT NOT NULL, status TEXT NOT NULL, evidence TEXT NOT NULL,\n alignment TEXT NOT NULL DEFAULT '', received_at TEXT NOT NULL, updated_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS item_comments (\n id INTEGER PRIMARY KEY AUTOINCREMENT, item_id TEXT NOT NULL, author TEXT NOT NULL,\n body TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS item_revisions (\n id INTEGER PRIMARY KEY AUTOINCREMENT, item_id TEXT NOT NULL, draft TEXT NOT NULL,\n status TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS push_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT, payload TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n const count = await sqlite.execute(\"SELECT COUNT(*) AS n FROM review_items\");\n if (Number(count.rows?.[0]?.n ?? 0) === 0) {\n const seed = [\n [\"market-001\",\"RSS\",\"Grid operators are rewriting power forecasts around AI load\",\"https://example.com/ai-power\",\"External source: data-center demand is moving from a compute story into a power-infrastructure story.\",\"Grid operators are revising load forecasts as data centers move from isolated projects into regional infrastructure decisions.\",\"The next bottleneck in AI is increasingly physical: generation, transmission, and the equipment that connects new load to the grid.\",\"needs_review\",\"high\",\"AI infrastructure demand aligns with the profile's power, grid, and physical bottleneck themes.\",\"2026-07-14T14:20:00Z\"],\n [\"market-002\",\"AgentMail\",\"Sovereign compute spending is moving from announcements to procurement\",\"https://example.com/sovereign-compute\",\"External source: public-sector compute programs are creating durable infrastructure demand.\",\"Government compute programs are moving from public commitments into procurement, creating a more durable demand signal.\",\"The important shift is from AI enthusiasm to government procurement. Once compute becomes strategic infrastructure, demand survives ordinary budget cycles.\",\"drafted\",\"medium\",\"The source supports the profile's view that strategic infrastructure spending can outlast ordinary enterprise cycles.\",\"2026-07-14T12:05:00Z\"],\n [\"market-003\",\"RSS\",\"Optical interconnect becomes the quiet constraint inside the AI cluster\",\"https://example.com/optical\",\"External source: bandwidth and power efficiency are becoming system-level constraints.\",\"The economics of each new accelerator generation increase the value of infrastructure that moves data between chips, racks, and campuses.\",\"Every new accelerator generation increases the value of the infrastructure that moves data between chips, racks, and campuses.\",\"approved\",\"high\",\"The source directly aligns with the profile's infrastructure-layer thesis around bandwidth, power efficiency, and bottlenecks.\",\"2026-07-13T18:45:00Z\"]\n ];\n for (const row of seed) await sqlite.execute({sql:`INSERT INTO review_items (id,source_type,headline,source_url,summary,source_excerpt,draft,status,evidence,alignment,received_at,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:row});\n }\n })();\n return ready;\n}\n\nconst page = `LUKE HEADROOM / Editorial Desk

LUKE HEADROOM

Review queue

Loading…

Last sync: loading

`;\n\napp.get(\"/\", async c => new Response(page,{headers:{\"content-type\":\"text/html; charset=utf-8\"}}));\napp.get(\"/source\", c => c.redirect(parseVal().links.self.val));\napp.get(\"/api/items\", async c => {await init();const r=await sqlite.execute(\"SELECT * FROM review_items WHERE status != 'archived' ORDER BY received_at DESC\");const rows=[];for(const x of r.rows){const cs=await sqlite.execute({sql:\"SELECT id,author,body,created_at FROM item_comments WHERE item_id=? ORDER BY created_at\",args:[x.id]});rows.push({...x,comments:cs.rows});}return c.json(rows)});\napp.patch(\"/api/items/:id\", async c => {await init();const id=c.req.param('id');const body=await c.req.json();const old=await sqlite.execute({sql:\"SELECT draft,status FROM review_items WHERE id=?\",args:[id]});if(!old.rows.length)return c.json({error:'not found'},404);await sqlite.execute({sql:\"INSERT INTO item_revisions (item_id,draft,status,created_at) VALUES (?,?,?,?)\",args:[id,old.rows[0].draft,old.rows[0].status,now()]});await sqlite.execute({sql:\"UPDATE review_items SET draft=?,status=?,updated_at=? WHERE id=?\",args:[body.draft??old.rows[0].draft,body.status??old.rows[0].status,now(),id]});return c.json({ok:true,id})});\napp.post(\"/api/items/:id/comments\", async c => {await init();const id=c.req.param('id');const body=await c.req.json();const created=now();await sqlite.execute({sql:\"INSERT INTO item_comments (item_id,author,body,created_at) VALUES (?,?,?,?)\",args:[id,body.author||'Editorial desk',body.body,created]});const r=await sqlite.execute(\"SELECT last_insert_rowid() AS id\");return c.json({id:r.rows[0].id,author:body.author||'Editorial desk',body:body.body,created_at:created})});\napp.get(\"/api/items/:id/revisions\", async c => {await init();const r=await sqlite.execute({sql:\"SELECT * FROM item_revisions WHERE item_id=? ORDER BY created_at DESC\",args:[c.req.param('id')]});return c.json(r.rows)});\napp.post(\"/api/items\", async c => {await init();const b=await c.req.json();const t=now();await sqlite.execute({sql:\"INSERT OR REPLACE INTO review_items (id,source_type,headline,source_url,summary,source_excerpt,draft,status,evidence,alignment,received_at,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)\",args:[b.id,b.source_type,b.headline,b.source_url,b.summary||b.source_excerpt,b.source_excerpt||b.summary,b.draft,b.status||'needs_review',b.evidence||'medium',b.alignment||'',b.received_at||t,t]});return c.json({ok:true,id:b.id})});\napp.post(\"/api/push\", async c => {await init();const r=await sqlite.execute(\"SELECT * FROM review_items ORDER BY updated_at DESC\");const comments=await sqlite.execute(\"SELECT * FROM item_comments ORDER BY created_at\");const revisions=await sqlite.execute(\"SELECT * FROM item_revisions ORDER BY created_at\");const push_id='push-'+Date.now();const payload={push_id,created_at:now(),authority:'valtown',target:'hermes-luke-headroom',items:r.rows,comments:comments.rows,revisions:revisions.rows};await sqlite.execute({sql:\"INSERT INTO push_events (payload,created_at) VALUES (?,?)\",args:[JSON.stringify(payload),payload.created_at]});return c.json({ok:true,push_id,queued_for_hermes:true,items:payload.items.length,comments:payload.comments.length,revisions:payload.revisions.length})});\napp.get(\"/api/pushes\", async c => {await init();const r=await sqlite.execute(\"SELECT id,created_at FROM push_events ORDER BY created_at DESC\");return c.json(r.rows)});\napp.get(\"/api/health\", async c => {await init();return c.json({ok:true,authority:'hermes',mode:'editorial-workspace',syncCadence:'manual-push'})});\napp.onError(err=>Promise.reject(err));\nexport default app.fetch;\n","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst app = new Hono();\nlet ready: Promise | undefined;\nconst now = () => new Date().toISOString();\n\nasync function init() {\n if (ready) return ready;\n ready = (async () => {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS review_items (\n id TEXT PRIMARY KEY, source_type TEXT NOT NULL, headline TEXT NOT NULL,\n source_url TEXT NOT NULL, summary TEXT NOT NULL, source_excerpt TEXT NOT NULL DEFAULT '',\n draft TEXT NOT NULL, status TEXT NOT NULL, evidence TEXT NOT NULL,\n alignment TEXT NOT NULL DEFAULT '', received_at TEXT NOT NULL, updated_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS item_comments (\n id INTEGER PRIMARY KEY AUTOINCREMENT, item_id TEXT NOT NULL, author TEXT NOT NULL,\n body TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS item_revisions (\n id INTEGER PRIMARY KEY AUTOINCREMENT, item_id TEXT NOT NULL, draft TEXT NOT NULL,\n status TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS push_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT, payload TEXT NOT NULL, created_at TEXT NOT NULL\n )`);\n const count = await sqlite.execute(\"SELECT COUNT(*) AS n FROM review_items\");\n if (Number(count.rows?.[0]?.n ?? 0) === 0) {\n const seed = [\n [\"market-001\",\"RSS\",\"Grid operators are rewriting power forecasts around AI load\",\"https://example.com/ai-power\",\"External source: data-center demand is moving from a compute story into a power-infrastructure story.\",\"Grid operators are revising load forecasts as data centers move from isolated projects into regional infrastructure decisions.\",\"The next bottleneck in AI is increasingly physical: generation, transmission, and the equipment that connects new load to the grid.\",\"needs_review\",\"high\",\"AI infrastructure demand aligns with the profile's power, grid, and physical bottleneck themes.\",\"2026-07-14T14:20:00Z\"],\n [\"market-002\",\"AgentMail\",\"Sovereign compute spending is moving from announcements to procurement\",\"https://example.com/sovereign-compute\",\"External source: public-sector compute programs are creating durable infrastructure demand.\",\"Government compute programs are moving from public commitments into procurement, creating a more durable demand signal.\",\"The important shift is from AI enthusiasm to government procurement. Once compute becomes strategic infrastructure, demand survives ordinary budget cycles.\",\"drafted\",\"medium\",\"The source supports the profile's view that strategic infrastructure spending can outlast ordinary enterprise cycles.\",\"2026-07-14T12:05:00Z\"],\n [\"market-003\",\"RSS\",\"Optical interconnect becomes the quiet constraint inside the AI cluster\",\"https://example.com/optical\",\"External source: bandwidth and power efficiency are becoming system-level constraints.\",\"The economics of each new accelerator generation increase the value of infrastructure that moves data between chips, racks, and campuses.\",\"Every new accelerator generation increases the value of the infrastructure that moves data between chips, racks, and campuses.\",\"approved\",\"high\",\"The source directly aligns with the profile's infrastructure-layer thesis around bandwidth, power efficiency, and bottlenecks.\",\"2026-07-13T18:45:00Z\"]\n ];\n for (const row of seed) await sqlite.execute({sql:`INSERT INTO review_items (id,source_type,headline,source_url,summary,source_excerpt,draft,status,evidence,alignment,received_at,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:row});\n }\n })();\n return ready;\n}\n\nconst page = `LUKE HEADROOM / Editorial Desk

LUKE HEADROOM

Review queue

Loading…

Last sync: loading

`;\n\napp.get(\"/\", async c => new Response(page,{headers:{\"content-type\":\"text/html; charset=utf-8\"}}));\napp.get(\"/source\", c => c.redirect(parseVal().links.self.val));\napp.get(\"/api/items\", async c => {await init();const r=await sqlite.execute(\"SELECT * FROM review_items WHERE status != 'archived' ORDER BY received_at DESC\");const rows=[];for(const x of r.rows){const cs=await sqlite.execute({sql:\"SELECT id,author,body,created_at FROM item_comments WHERE item_id=? ORDER BY created_at\",args:[x.id]});rows.push({...x,comments:cs.rows});}return c.json(rows)});\napp.patch(\"/api/items/:id\", async c => {await init();const id=c.req.param('id');const body=await c.req.json();const old=await sqlite.execute({sql:\"SELECT draft,status FROM review_items WHERE id=?\",args:[id]});if(!old.rows.length)return c.json({error:'not found'},404);await sqlite.execute({sql:\"INSERT INTO item_revisions (item_id,draft,status,created_at) VALUES (?,?,?,?)\",args:[id,old.rows[0].draft,old.rows[0].status,now()]});await sqlite.execute({sql:\"UPDATE review_items SET draft=?,status=?,updated_at=? WHERE id=?\",args:[body.draft??old.rows[0].draft,body.status??old.rows[0].status,now(),id]});return c.json({ok:true,id})});\napp.post(\"/api/items/:id/comments\", async c => {await init();const id=c.req.param('id');const body=await c.req.json();const created=now();await sqlite.execute({sql:\"INSERT INTO item_comments (item_id,author,body,created_at) VALUES (?,?,?,?)\",args:[id,body.author||'Editorial desk',body.body,created]});const r=await sqlite.execute(\"SELECT last_insert_rowid() AS id\");return c.json({id:r.rows[0].id,author:body.author||'Editorial desk',body:body.body,created_at:created})});\napp.get(\"/api/items/:id/revisions\", async c => {await init();const r=await sqlite.execute({sql:\"SELECT * FROM item_revisions WHERE item_id=? ORDER BY created_at DESC\",args:[c.req.param('id')]});return c.json(r.rows)});\napp.post(\"/api/items\", async c => {await init();const b=await c.req.json();const t=now();await sqlite.execute({sql:\"INSERT OR REPLACE INTO review_items (id,source_type,headline,source_url,summary,source_excerpt,draft,status,evidence,alignment,received_at,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)\",args:[b.id,b.source_type,b.headline,b.source_url,b.summary||b.source_excerpt,b.source_excerpt||b.summary,b.draft,b.status||'needs_review',b.evidence||'medium',b.alignment||'',b.received_at||t,t]});return c.json({ok:true,id:b.id})});\napp.post(\"/api/push\", async c => {await init();const r=await sqlite.execute(\"SELECT * FROM review_items ORDER BY updated_at DESC\");const comments=await sqlite.execute(\"SELECT * FROM item_comments ORDER BY created_at\");const revisions=await sqlite.execute(\"SELECT * FROM item_revisions ORDER BY created_at\");const push_id='push-'+Date.now();const payload={push_id,created_at:now(),authority:'valtown',target:'hermes-luke-headroom',items:r.rows,comments:comments.rows,revisions:revisions.rows};await sqlite.execute({sql:\"INSERT INTO push_events (payload,created_at) VALUES (?,?)\",args:[JSON.stringify(payload),payload.created_at]});return c.json({ok:true,push_id,queued_for_hermes:true,items:payload.items.length,comments:payload.comments.length,revisions:payload.revisions.length})});\napp.get(\"/api/pushes\", async c => {await init();const r=await sqlite.execute(\"SELECT id,created_at FROM push_events ORDER BY created_at DESC\");return c.json(r.rows)});\napp.get(\"/api/health\", async c => {await init();return c.json({ok:true,authority:'hermes',mode:'editorial-workspace',syncCadence:'manual-push'})});\napp.onError(err=>Promise.reject(err));\nexport default app.fetch;\n","createdAt",["D",1784052052615],"branchVersion","branchId","25a12779-704b-4a0a-8f52-1d35eadf2dad","id","788086ad-fd5c-4531-a0ee-62069aac0cab","luke-headroom-dashboard",["D",1784046691506],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Sanitized editorial review dashboard","imageUrl","4014c640-61ba-11f0-852d-15ceec715ebe","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","4014c641-61ba-11f0-852d-15ceec715ebe","tursoName","788086adfd5c4531a0ee62069aac0cab","tursoHostname","788086adfd5c4531a0ee62069aac0cab-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789472446807],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",45,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vvampa","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ6dlV1b1h4VzRxbTBVblhueldOUjc4R3N1ViJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":153,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":154,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":155,"_83":156,"_85":157,"_87":25},"tree",[148],"files",[148],"counts",{"_137":62,"_138":139,"_140":62,"_141":142,"_143":144},"contents",[129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":133,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_27":136},"cb26e0c1-8679-41be-8571-7534c79743ae","parentId","latest",["D",1784052052615],13,"label",[28],"pulls","branches",1,"forks","envVars",{"_145":62,"_147":62},"connections",{"_145":62,"_146":62},"count","unfilledCount","emptyCount",{"_43":130,"_32":28,"_30":31,"_131":-5,"_41":42,"_40":14,"_132":25,"_38":149,"_13":134,"_33":34,"_35":37,"_24":25,"_135":-5,"_150":151,"_27":152},["D",1784052052615],"children",[],[28],["D",1784046691506],["D",1789472446807],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":191,"_192":193,"_194":195,"_196":25,"_197":25,"_198":25,"_199":58,"_200":-5,"_201":-7,"_202":-7,"_203":62,"_204":25,"_205":25,"_206":-5,"_207":25,"_208":25,"_209":25,"_210":-5},"ENV",{"_162":163,"_164":165,"_166":89,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190},"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 · v14