Val Swiper

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_201":202,"_203":204},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_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":125,"_126":-5,"_127":-5,"_128":129},"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":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",27,"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","0b54ac42-030c-11f1-8b91-42dde27851f2","name","fileType","http","content","import { renderApp } from \"./lib/ui.ts\";\nimport { fetchRandomVals, refreshValPool } from \"./lib/fetch-vals.ts\";\nimport { initDb, addLike, getLikes, markSeen, clearSeen } from \"./lib/db.ts\";\n\nlet dbReady = false;\n\nasync function ensureDb() {\n if (!dbReady) {\n await initDb();\n dbReady = true;\n }\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // Serve frontend immediately (no DB needed)\n if (url.pathname === \"/\" || url.pathname === \"\") {\n return new Response(renderApp(), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // All API routes need DB\n await ensureDb();\n\n if (url.pathname === \"/api/vals\") {\n const vals = await fetchRandomVals(8);\n return Response.json(vals);\n }\n\n if (url.pathname === \"/api/like\" && req.method === \"POST\") {\n const body = await req.json();\n await addLike(body.id, body.name, body.author, body.url);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/likes\") {\n const likes = await getLikes();\n return Response.json(likes);\n }\n\n if (url.pathname === \"/api/seen\" && req.method === \"POST\") {\n const body = await req.json();\n await markSeen(body.id);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/refresh\") {\n const count = await refreshValPool();\n return Response.json({ refreshed: count });\n }\n\n if (url.pathname === \"/api/clear-seen\" && req.method === \"POST\") {\n await clearSeen();\n return Response.json({ ok: true });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","import { renderApp } from \"./lib/ui.ts\";\nimport { fetchRandomVals, refreshValPool } from \"./lib/fetch-vals.ts\";\nimport { initDb, addLike, getLikes, markSeen, markBroken, clearSeen } from \"./lib/db.ts\";\n\nlet dbReady = false;\n\nasync function ensureDb() {\n if (!dbReady) {\n await initDb();\n dbReady = true;\n }\n}\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // ── Serve frontend (no DB needed) ──\n if (url.pathname === \"/\" || url.pathname === \"\") {\n return new Response(renderApp(), {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // ── API routes (all need DB) ──\n await ensureDb();\n\n if (url.pathname === \"/api/vals\") {\n const vals = await fetchRandomVals(8);\n return Response.json(vals);\n }\n\n if (url.pathname === \"/api/like\" && req.method === \"POST\") {\n const body = await req.json();\n await addLike(body.id, body.name, body.author, body.url);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/likes\") {\n return Response.json(await getLikes());\n }\n\n if (url.pathname === \"/api/seen\" && req.method === \"POST\") {\n const body = await req.json();\n await markSeen(body.id);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/broken\" && req.method === \"POST\") {\n const body = await req.json();\n if (body.id) await markBroken(body.id);\n return Response.json({ ok: true });\n }\n\n if (url.pathname === \"/api/refresh\") {\n const count = await refreshValPool();\n return Response.json({ refreshed: count });\n }\n\n if (url.pathname === \"/api/clear-seen\" && req.method === \"POST\") {\n await clearSeen();\n return Response.json({ ok: true });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}\n","createdAt",["D",1770398618693],"branchVersion","branchId","0b51f27c-030c-11f1-8b91-42dde27851f2","id","0b519c96-030c-11f1-8b91-42dde27851f2","val-swiper",["D",1770348568956],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Swipe through random public vals - like Tinder for vals","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","0b519c96030c11f18b9142dde27851f2","tursoHostname","0b519c96030c11f18b9142dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789540832752],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",34,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dcm31","handle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789574399&sig=a925208509ae04f12f2c0946312b0486500a05bf884a2b0f9b9455e5f9f79132","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":196,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":197,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":198,"_82":199,"_84":200,"_86":25},"tree",[157,161],"files",[157,158,159,160,161],"counts",{"_146":61,"_147":148,"_149":61,"_150":151,"_152":153},"contents",[130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":125,"_38":143,"_13":61,"_33":144,"_35":-5,"_24":25,"_137":-5,"_27":145},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":135,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_27":138},"934acafe-0380-11f1-bbeb-42dde27851f2","parentId","latest",["D",1770398618693],6,"label",[28],"0da7603e-030c-11f1-99f7-42dde27851f2","lib","0da76110-030c-11f1-99f7-42dde27851f2",2,["D",1770348572867],"directory",[140],"pulls","branches",1,"forks","envVars",{"_154":61,"_156":61},"connections",{"_154":61,"_155":61},"count","unfilledCount","emptyCount",{"_43":139,"_32":140,"_30":141,"_133":-5,"_41":42,"_40":142,"_134":125,"_38":193,"_13":61,"_33":144,"_35":-5,"_24":25,"_137":-5,"_163":194,"_27":195},{"_43":184,"_32":185,"_30":186,"_133":141,"_41":42,"_40":187,"_134":125,"_38":188,"_13":189,"_33":171,"_35":190,"_24":25,"_137":-5,"_163":191,"_27":192},{"_43":175,"_32":176,"_30":177,"_133":141,"_41":42,"_40":178,"_134":125,"_38":179,"_13":180,"_33":171,"_35":181,"_24":25,"_137":-5,"_163":182,"_27":183},{"_43":166,"_32":167,"_30":168,"_133":141,"_41":42,"_40":169,"_134":25,"_38":170,"_13":142,"_33":171,"_35":172,"_24":25,"_137":-5,"_163":173,"_27":174},{"_43":132,"_32":28,"_30":31,"_133":-5,"_41":42,"_40":14,"_134":25,"_38":162,"_13":136,"_33":34,"_35":37,"_24":25,"_137":-5,"_163":164,"_27":165},["D",1770398618693],"children",[],[28],"5f8297f6-0380-11f1-8525-42dde27851f2","ui.ts","54286328-030c-11f1-981a-42dde27851f2",22,["D",1770398531821],"script","export function renderApp(): string {\n return `\n\n\n \n \n Val Swiper\n \n\n\n${getHTML()}\n\n\n`;\n}\n\nfunction getHTML(): string {\n return `\n

\n\n

\n \n\n \n\n \n

\n\n

@...

\n\n

Finding vals...

\n\n

No more vals to show

\n \n

\n\n

\n \n Liked Vals\n

`;\n}\n\nfunction getCSS(): string {\n return `\n*{box-sizing:border-box;margin:0;padding:0}\nbody{font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;background:#000;color:#fff;overflow:hidden;-webkit-user-select:none;user-select:none}\n#app{position:fixed;inset:0}\n\n/* ── Feed ─────────────────────────────────────────────── */\n#feed{position:absolute;inset:0;overflow-y:scroll;scroll-snap-type:y mandatory;scrollbar-width:none;-ms-overflow-style:none}\n#feed::-webkit-scrollbar{display:none}\n.card{position:relative;width:100vw;height:100vh;scroll-snap-align:start;scroll-snap-stop:always;background:#000}\n.card iframe{width:100%;height:100%;border:none;background:#111}\n.card .card-loader{position:absolute;inset:0;display:flex;flex-direction:column;align-items:center;justify-content:center;background:#000;z-index:5;gap:14px;transition:opacity .3s}\n.card .card-loader.done{opacity:0;pointer-events:none}\n.card .card-loader p{color:#555;font-size:13px}\n\n/* ── Action bar (right side, TikTok style) ────────────── */\n#action-bar{position:fixed;right:8px;bottom:160px;z-index:80;display:flex;flex-direction:column;align-items:center;gap:18px}\n.action-btn{background:none;border:none;color:#fff;cursor:pointer;display:flex;flex-direction:column;align-items:center;gap:2px;padding:0;-webkit-tap-highlight-color:transparent}\n.action-btn:active .icon-wrap{transform:scale(.85)}\n.icon-wrap{width:44px;height:44px;display:flex;align-items:center;justify-content:center;transition:transform .15s}\n.icon-wrap svg{width:28px;height:28px}\n.action-label{font-size:12px;font-weight:600;line-height:1;filter:drop-shadow(0 1px 2px rgba(0,0,0,.9))}\n\n/* Like states */\n#like-btn .heart-filled{display:none}\n#like-btn.liked .heart-outline{display:none}\n#like-btn.liked .heart-filled{display:block;animation:popHeart .35s ease-out}\n#like-btn.liked .action-label{color:#FE2C55}\n@keyframes popHeart{0%{transform:scale(0)}50%{transform:scale(1.35)}100%{transform:scale(1)}}\n\n/* ── Bottom bar ───────────────────────────────────────── */\n#bottom-bar{position:fixed;bottom:0;left:0;right:70px;padding:14px 16px 28px;z-index:60;background:linear-gradient(transparent,rgba(0,0,0,.7));pointer-events:none}\n#author-line{font-size:16px;font-weight:700;margin-bottom:4px;text-shadow:0 1px 4px rgba(0,0,0,.9)}\n#desc-line{font-size:14px;color:rgba(255,255,255,.85);line-height:1.35;text-shadow:0 1px 3px rgba(0,0,0,.8);overflow:hidden;display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical}\n\n/* ── Loading / Empty ──────────────────────────────────── */\n#loading-screen,#empty-screen{position:fixed;inset:0;display:flex;flex-direction:column;align-items:center;justify-content:center;gap:20px;background:#000;z-index:200}\n#loading-screen.gone,#empty-screen.gone{display:none}\n#loading-screen p{color:#555;font-size:14px}\n.loader{width:36px;height:36px;border:3px solid rgba(255,255,255,.12);border-top-color:#FE2C55;border-radius:50%;animation:spin .7s linear infinite}\n@keyframes spin{to{transform:rotate(360deg)}}\n#empty-screen p{font-size:17px;color:#666}\n#refresh-btn{padding:12px 36px;border-radius:4px;border:none;background:#FE2C55;color:#fff;font-size:15px;font-weight:700;cursor:pointer}\n\n/* ── Saved / Liked Panel ──────────────────────────────── */\n#saved-panel{position:fixed;inset:0;background:#000;z-index:300;overflow-y:auto}\n#saved-header{display:flex;align-items:center;gap:14px;padding:14px 16px;border-bottom:1px solid rgba(255,255,255,.08);position:sticky;top:0;background:#000;z-index:10}\n#saved-header button{background:none;border:none;color:#fff;cursor:pointer;display:flex;align-items:center;padding:4px}\n#saved-header button svg{width:22px;height:22px}\n#saved-header span{font-size:17px;font-weight:700}\n#saved-grid{padding:4px;display:grid;grid-template-columns:repeat(3,1fr);gap:2px}\n.saved-card{position:relative;aspect-ratio:9/16;overflow:hidden;background:#111;cursor:pointer;text-decoration:none;color:inherit;display:block}\n.saved-card .thumb{width:100%;height:100%;background:linear-gradient(135deg,#25272e,#161822)}\n.saved-card .overlay{position:absolute;bottom:0;left:0;right:0;padding:8px;background:linear-gradient(transparent,rgba(0,0,0,.85))}\n.saved-card .s-name{font-size:12px;font-weight:600;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}\n.saved-card .s-author{font-size:11px;color:#888}\n.saved-empty{grid-column:1/-1;text-align:center;padding:80px 20px;color:#555;font-size:15px}\n\n.gone{display:none!important}\n@media(max-width:768px){#action-bar{right:6px;bottom:130px;gap:16px}.icon-wrap svg{width:26px;height:26px}}\n`;\n}\n\nfunction getJS(): string {\n return `\n(function(){\nvar vals=[],idx=0,fetching=false,liked=new Set(),totalLikes=0;\nvar el={};\n\nfunction boot(){\n el.feed=document.getElementById(\"feed\");\n el.likeBtn=document.getElementById(\"like-btn\");\n el.openBtn=document.getElementById(\"open-btn\");\n el.savedBtn=document.getElementById(\"saved-btn\");\n el.likeCount=document.getElementById(\"like-count\");\n el.savedCount=document.getElementById(\"saved-count\");\n el.authorName=document.getElementById(\"author-name\");\n el.descLine=document.getElementById(\"desc-line\");\n el.loadingScreen=document.getElementById(\"loading-screen\");\n el.emptyScreen=document.getElementById(\"empty-screen\");\n el.savedPanel=document.getElementById(\"saved-panel\");\n el.savedBack=document.getElementById(\"saved-back\");\n el.savedGrid=document.getElementById(\"saved-grid\");\n el.refreshBtn=document.getElementById(\"refresh-btn\");\n\n el.likeBtn.onclick=toggleLike;\n el.openBtn.onclick=openCurrent;\n el.savedBtn.onclick=showSaved;\n el.savedBack.onclick=hideSaved;\n el.refreshBtn.onclick=refresh;\n el.feed.addEventListener(\"scroll\",onScroll,{passive:true});\n\n document.addEventListener(\"keydown\",function(e){\n if(!el.savedPanel.classList.contains(\"gone\"))return;\n if(e.key===\"ArrowDown\"){e.preventDefault();go(idx+1)}\n else if(e.key===\"ArrowUp\"){e.preventDefault();go(idx-1)}\n else if(e.key===\"l\")toggleLike();\n });\n\n // Double-tap to like (TikTok style)\n var lastTap=0;\n el.feed.addEventListener(\"touchend\",function(e){\n var now=Date.now();\n if(now-lastTap<300){\n if(!liked.has(vals[idx]?.id))toggleLike();\n showHeartBurst(e);\n }\n lastTap=now;\n },{passive:true});\n\n loadVals();\n}\n\nfunction loadVals(){\n if(fetching)return;\n fetching=true;\n fetch(\"/api/vals\").then(function(r){return r.json()}).then(function(nv){\n if(nv.length>0){\n vals=vals.concat(nv);\n render();\n el.loadingScreen.classList.add(\"gone\");\n }else if(vals.length===0){\n el.loadingScreen.classList.add(\"gone\");\n el.emptyScreen.classList.remove(\"gone\");\n }\n fetching=false;\n }).catch(function(){\n el.loadingScreen.classList.add(\"gone\");\n el.emptyScreen.classList.remove(\"gone\");\n fetching=false;\n });\n}\n\nfunction render(){\n vals.forEach(function(v,i){\n if(document.getElementById(\"c\"+i))return;\n var d=document.createElement(\"div\");\n d.className=\"card\";d.id=\"c\"+i;\n\n var ld=document.createElement(\"div\");\n ld.className=\"card-loader\";\n ld.innerHTML='

';\n\n var f=document.createElement(\"iframe\");\n f.sandbox=\"allow-scripts allow-same-origin allow-popups allow-forms allow-modals\";\n f.loading=\"lazy\";f.src=v.url;\n f.onload=function(){ld.classList.add(\"done\")};\n setTimeout(function(){ld.classList.add(\"done\")},10000);\n\n d.appendChild(f);d.appendChild(ld);\n el.feed.appendChild(d);\n });\n}\n\nfunction onScroll(){\n var ni=Math.round(el.feed.scrollTop/window.innerHeight);\n if(ni!==idx&&ni>=0&&ni=vals.length-3)loadVals();\n }\n}\n\nfunction go(i){\n if(i<0||i>=vals.length)return;\n el.feed.scrollTo({top:i*window.innerHeight,behavior:\"smooth\"});\n}\n\nfunction updateUI(){\n var v=vals[idx];if(!v)return;\n el.authorName.textContent=v.author;\n el.descLine.textContent=v.name||v.description||\"\";\n el.likeBtn.classList.toggle(\"liked\",liked.has(v.id));\n}\n\nfunction toggleLike(){\n var v=vals[idx];if(!v)return;\n if(liked.has(v.id)){\n liked.delete(v.id);totalLikes--;\n }else{\n liked.add(v.id);totalLikes++;\n fetch(\"/api/like\",{method:\"POST\",headers:{\"Content-Type\":\"application/json\"},body:JSON.stringify(v)}).catch(function(){});\n }\n el.likeCount.textContent=totalLikes;\n el.savedCount.textContent=totalLikes;\n el.likeBtn.classList.toggle(\"liked\",liked.has(v.id));\n}\n\nfunction openCurrent(){\n var v=vals[idx];if(!v)return;\n window.open(v.url,\"_blank\");\n}\n\nfunction seen(id){\n fetch(\"/api/seen\",{method:\"POST\",headers:{\"Content-Type\":\"application/json\"},body:JSON.stringify({id:id})}).catch(function(){});\n}\n\nfunction showSaved(){\n el.savedPanel.classList.remove(\"gone\");\n fetch(\"/api/likes\").then(function(r){return r.json()}).then(function(ls){\n if(!ls.length){el.savedGrid.innerHTML='

No liked vals yet

';return}\n el.savedGrid.innerHTML=ls.map(function(l){\n return '

'+esc(l.name)+'

@'+esc(l.author)+'

';\n }).join(\"\");\n }).catch(function(){el.savedGrid.innerHTML='

Failed to load

'});\n}\n\nfunction hideSaved(){el.savedPanel.classList.add(\"gone\")}\n\nfunction refresh(){\n fetch(\"/api/clear-seen\",{method:\"POST\"}).then(function(){return fetch(\"/api/refresh\")}).then(function(){location.reload()}).catch(function(){});\n}\n\nfunction showHeartBurst(e){\n var t=e.changedTouches?e.changedTouches[0]:e;\n var h=document.createElement(\"div\");\n h.innerHTML='';\n h.style.cssText=\"position:fixed;z-index:9999;pointer-events:none;left:\"+(t.clientX-30)+\"px;top:\"+(t.clientY-30)+\"px;animation:heartBurst .6s ease-out forwards\";\n document.body.appendChild(h);\n setTimeout(function(){h.remove()},700);\n}\n\n// inject burst animation\nvar st=document.createElement(\"style\");\nst.textContent=\"@keyframes heartBurst{0%{transform:scale(0);opacity:1}50%{transform:scale(1.4);opacity:1}100%{transform:scale(1.6) translateY(-40px);opacity:0}}\";\ndocument.head.appendChild(st);\n\nfunction esc(s){var d=document.createElement(\"div\");d.textContent=s||\"\";return d.innerHTML}\n\nif(document.readyState===\"loading\")document.addEventListener(\"DOMContentLoaded\",boot);else boot();\n})();\n`;\n}\n",[],[140,167],"8d6401be-0380-11f1-8525-42dde27851f2","fetch-vals.ts","2108f7be-030c-11f1-8bbe-42dde27851f2",26,["D",1770398608775],9,"import {\n addToPool,\n getVerifiedFromPool,\n getVerifiedPoolSize,\n getPoolSize,\n markVerified,\n markBroken,\n type PoolVal,\n} from \"./db.ts\";\n\nconst SEARCH_TERMS = [\n \"app\", \"game\", \"dashboard\", \"tool\", \"demo\",\n \"website\", \"chat\", \"todo\", \"calculator\", \"clock\",\n \"art\", \"generator\", \"tracker\", \"timer\", \"converter\",\n \"quiz\", \"map\", \"chart\", \"blog\", \"form\", \"search\",\n \"image\", \"color\", \"emoji\", \"random\", \"joke\", \"html\",\n \"recipe\", \"crypto\", \"homepage\", \"landing\", \"page\",\n \"portfolio\", \"widget\", \"viewer\", \"editor\", \"ui\",\n \"hono\", \"react\", \"playground\", \"tldraw\", \"pixel\",\n];\n\n// Returns true only if the val responds 2xx\nasync function isAlive(url: string): Promise {\n try {\n const c = new AbortController();\n const t = setTimeout(() => c.abort(), 4000);\n const res = await fetch(url, {\n method: \"GET\",\n signal: c.signal,\n redirect: \"follow\",\n headers: { Accept: \"text/html\" },\n });\n clearTimeout(t);\n await res.text(); // consume body\n return res.ok;\n } catch {\n return false;\n }\n}\n\nasync function fetchFromSearchApi(term: string, offset: number): Promise {\n try {\n const url = new URL(\"https://api.val.town/v1/search/vals\");\n url.searchParams.set(\"query\", term);\n url.searchParams.set(\"limit\", \"100\");\n url.searchParams.set(\"offset\", String(offset));\n\n const c = new AbortController();\n const t = setTimeout(() => c.abort(), 5000);\n const res = await fetch(url.toString(), { signal: c.signal });\n clearTimeout(t);\n\n if (!res.ok) return [];\n const data = await res.json();\n\n return (data.data || [])\n .filter((v: any) => {\n if (v.type !== \"http\" && v.type !== \"httpnext\") return false;\n if (v.public === false) return false;\n if (v.code && v.code.length < 50) return false;\n return true;\n })\n .map((v: any) => ({\n id: v.id,\n name: v.name,\n author: v.author?.username || \"unknown\",\n url: `https://${v.author?.username}-${v.name}.web.val.run/`,\n description: v.description || \"\",\n }));\n } catch {\n return [];\n }\n}\n\n// Health-check a batch in parallel, return only living ones\nasync function filterAlive(vals: PoolVal[]): Promise {\n const results = await Promise.all(\n vals.map(async (v) => ((await isAlive(v.url)) ? v : null)),\n );\n return results.filter((v): v is PoolVal => v !== null);\n}\n\n// Search → health-check → return only verified-alive vals\nexport async function quickFetch(count = 8): Promise {\n const term = SEARCH_TERMS[Math.floor(Math.random() * SEARCH_TERMS.length)];\n const offset = Math.floor(Math.random() * 40);\n const raw = await fetchFromSearchApi(term, offset);\n\n const candidates = raw.sort(() => Math.random() - 0.5).slice(0, count * 3);\n const alive = await filterAlive(candidates);\n const final = alive.slice(0, count);\n\n // Save as verified\n if (final.length > 0) {\n addToPool(final, true).catch(() => {});\n }\n\n return final;\n}\n\n// Background pool refresh\nexport async function refreshValPool(): Promise {\n let total = 0;\n const terms = [...SEARCH_TERMS].sort(() => Math.random() - 0.5).slice(0, 2);\n\n for (const term of terms) {\n const offset = Math.floor(Math.random() * 40);\n const raw = await fetchFromSearchApi(term, offset);\n const alive = await filterAlive(raw.slice(0, 20));\n if (alive.length > 0) {\n await addToPool(alive, true);\n total += alive.length;\n }\n }\n return total;\n}\n\n// Main entry: serve from verified pool, else live-search\nexport async function fetchRandomVals(count = 8): Promise {\n try {\n const vSize = await getVerifiedPoolSize();\n if (vSize >= count) {\n if (vSize < 30) refreshValPool().catch(() => {});\n const fromPool = await getVerifiedFromPool(count + 4);\n // Re-verify pool vals in case they went stale\n const alive = await filterAlive(fromPool);\n const deadIds = fromPool\n .filter((v) => !alive.find((a) => a.id === v.id))\n .map((v) => v.id);\n for (const id of deadIds) markBroken(id).catch(() => {});\n if (alive.length >= count) return alive.slice(0, count);\n }\n } catch {\n /* pool not ready */\n }\n\n return quickFetch(count);\n}\n",[],[140,176],"76d559d4-0380-11f1-8974-42dde27851f2","db.ts","1605996c-030c-11f1-9558-42dde27851f2",24,["D",1770398570948],5,"import { sqlite } from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\n// ── Schema ──────────────────────────────────────────────────────────\n\nexport async function initDb() {\n await sqlite.batch([\n { sql: `CREATE TABLE IF NOT EXISTS val_pool (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n author TEXT NOT NULL,\n url TEXT NOT NULL,\n description TEXT DEFAULT '',\n verified INTEGER DEFAULT 0,\n discovered_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS likes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n val_id TEXT NOT NULL,\n val_name TEXT NOT NULL,\n val_author TEXT NOT NULL,\n val_url TEXT NOT NULL,\n liked_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS seen (\n val_id TEXT PRIMARY KEY,\n seen_at TEXT DEFAULT (datetime('now'))\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS broken (\n val_id TEXT PRIMARY KEY,\n broken_at TEXT DEFAULT (datetime('now'))\n )` },\n ]);\n}\n\n// ── Types ───────────────────────────────────────────────────────────\n\nexport interface PoolVal {\n id: string;\n name: string;\n author: string;\n url: string;\n description: string;\n}\n\n// ── Pool operations ─────────────────────────────────────────────────\n\nexport async function addToPool(vals: PoolVal[], verified = false) {\n if (!vals.length) return;\n const stmts = vals.map((v) => ({\n sql: `INSERT OR IGNORE INTO val_pool (id, name, author, url, description, verified)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [v.id, v.name, v.author, v.url, v.description, verified ? 1 : 0],\n }));\n await sqlite.batch(stmts);\n}\n\nexport async function getVerifiedFromPool(count: number): Promise {\n const result = await sqlite.execute({\n sql: `SELECT id, name, author, url, description FROM val_pool\n WHERE verified = 1\n AND id NOT IN (SELECT val_id FROM seen)\n AND id NOT IN (SELECT val_id FROM broken)\n ORDER BY RANDOM() LIMIT ?`,\n args: [count],\n });\n return rowsToVals(result.rows);\n}\n\nexport async function getUnverifiedFromPool(count: number): Promise {\n const result = await sqlite.execute({\n sql: `SELECT id, name, author, url, description FROM val_pool\n WHERE verified = 0\n AND id NOT IN (SELECT val_id FROM seen)\n AND id NOT IN (SELECT val_id FROM broken)\n ORDER BY RANDOM() LIMIT ?`,\n args: [count],\n });\n return rowsToVals(result.rows);\n}\n\nexport async function markVerified(ids: string[]) {\n if (!ids.length) return;\n const stmts = ids.map((id) => ({\n sql: `UPDATE val_pool SET verified = 1 WHERE id = ?`,\n args: [id],\n }));\n await sqlite.batch(stmts);\n}\n\nexport async function getPoolSize(): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM val_pool\n WHERE id NOT IN (SELECT val_id FROM seen)\n AND id NOT IN (SELECT val_id FROM broken)`,\n );\n const row = result.rows[0];\n return (row as any).cnt ?? (row as any)[0] ?? 0;\n}\n\nexport async function getVerifiedPoolSize(): Promise {\n const result = await sqlite.execute(\n `SELECT COUNT(*) as cnt FROM val_pool\n WHERE verified = 1\n AND id NOT IN (SELECT val_id FROM seen)\n AND id NOT IN (SELECT val_id FROM broken)`,\n );\n const row = result.rows[0];\n return (row as any).cnt ?? (row as any)[0] ?? 0;\n}\n\nexport async function markSeen(valId: string) {\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO seen (val_id) VALUES (?)`,\n args: [valId],\n });\n}\n\n// ── Broken vals ─────────────────────────────────────────────────────\n\nexport async function markBroken(valId: string) {\n await sqlite.batch([\n { sql: `INSERT OR IGNORE INTO broken (val_id) VALUES (?)`, args: [valId] },\n { sql: `DELETE FROM val_pool WHERE id = ?`, args: [valId] },\n ]);\n}\n\nexport async function isBroken(valId: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT 1 FROM broken WHERE val_id = ?`,\n args: [valId],\n });\n return result.rows.length > 0;\n}\n\n// ── Likes ───────────────────────────────────────────────────────────\n\nexport async function addLike(valId: string, name: string, author: string, url: string) {\n await sqlite.execute({\n sql: `INSERT INTO likes (val_id, val_name, val_author, val_url) VALUES (?, ?, ?, ?)`,\n args: [valId, name, author, url],\n });\n}\n\nexport async function getLikes() {\n const result = await sqlite.execute(\n `SELECT id, val_id, val_name, val_author, val_url, liked_at\n FROM likes ORDER BY liked_at DESC LIMIT 100`,\n );\n return result.rows.map((r: any) => ({\n id: r.id ?? r[0],\n valId: r.val_id ?? r[1],\n name: r.val_name ?? r[2],\n author: r.val_author ?? r[3],\n url: r.val_url ?? r[4],\n likedAt: r.liked_at ?? r[5],\n }));\n}\n\n// ── Maintenance ─────────────────────────────────────────────────────\n\nexport async function clearSeen() {\n await sqlite.execute(`DELETE FROM seen`);\n}\n\n// ── Helpers ─────────────────────────────────────────────────────────\n\nfunction rowsToVals(rows: any[]): PoolVal[] {\n return rows.map((r: any) => ({\n id: r.id ?? r[0],\n name: r.name ?? r[1],\n author: r.author ?? r[2],\n url: r.url ?? r[3],\n description: r.description ?? r[4],\n }));\n}\n",[],[140,185],["D",1770348572867],[158,159,160],[140],["D",1770348568956],["D",1789540832752],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_127":234,"_235":236,"_237":238,"_239":25,"_240":25,"_241":25,"_242":125,"_243":-5,"_244":-7,"_245":-7,"_246":61,"_247":25,"_248":25,"_249":-5,"_250":25,"_251":25,"_252":25,"_253":-5},"ENV",{"_205":206,"_207":208,"_209":88,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233},"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 · v27