Val Swiper

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_214":215,"_216":217},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_162":-5,"_20":163,"_22":164,"_165":166,"_167":168,"_25":169,"_24":-5,"_170":-5,"_171":-5,"_172":54,"_173":174,"_175":45,"_176":-5,"_177":-5,"_178":179},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","dcm31","name","val-swiper","branchName","main","version","path","","project",{"_34":104,"_13":14,"_46":105,"_106":-5,"_107":54,"_108":109,"_110":109,"_111":112,"_113":-5,"_114":115,"_116":-5,"_117":54,"_118":-5,"_119":-5,"_120":62,"_121":122,"_123":124,"_125":126,"_127":128,"_129":-5,"_130":131,"_132":131,"_133":134,"_135":134,"_136":134,"_137":131,"_138":131,"_139":140,"_141":142,"_143":144,"_145":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","f79f0312-0380-11f1-896c-42dde27851f2","main.ts","fileId","0b54ac42-030c-11f1-8b91-42dde27851f2","parentId","branchId","0b51f27c-030c-11f1-8b91-42dde27851f2","branchVersion",32,"latest",true,"createdAt",["D",1770398787015],9,"fileType","http","content","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 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/broken\" && req.method === \"POST\") {\n const body = await req.json();\n await markBroken(body.id);\n return Response.json({ ok: true });\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","deleted",false,"label",[36],"0da7603e-030c-11f1-99f7-42dde27851f2","lib","0da76110-030c-11f1-99f7-42dde27851f2",2,["D",1770348572867],0,"directory",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1770398787015],"children",[],[36],["D",1770348572867],[74,75,76],[58],{"_34":95,"_13":96,"_37":97,"_39":59,"_40":41,"_42":98,"_44":45,"_46":99,"_17":100,"_49":83,"_51":101,"_53":54,"_55":-5,"_68":102,"_18":103},{"_34":87,"_13":88,"_37":89,"_39":59,"_40":41,"_42":90,"_44":45,"_46":91,"_17":48,"_49":83,"_51":92,"_53":54,"_55":-5,"_68":93,"_18":94},{"_34":77,"_13":78,"_37":79,"_39":59,"_40":41,"_42":80,"_44":45,"_46":81,"_17":82,"_49":83,"_51":84,"_53":54,"_55":-5,"_68":85,"_18":86},"07c00b4e-039d-11f1-a7be-42dde27851f2","ui.ts","54286328-030c-11f1-981a-42dde27851f2",34,["D",1770410839989],6,"script","// ── Render ───────────────────────────────────────────────────────────\n\nexport function renderApp(): string {\n return `\n\n\n \n \n Val Swiper\n \n\n\n${getHTML()}\n\n\n`;\n}\n\n// ── HTML ─────────────────────────────────────────────────────────────\n\nfunction getHTML(): string {\n return `\n

\n\n \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 \n Liked Vals\n

`;\n}\n\n// ── CSS ──────────────────────────────────────────────────────────────\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/* Error overlay on broken cards */\n.card .card-error{position:absolute;inset:0;display:flex;flex-direction:column;align-items:center;justify-content:center;background:#0a0a0a;z-index:6;gap:12px}\n.card .card-error p{color:#666;font-size:14px}\n.card .card-error .skip-broken{padding:10px 28px;border-radius:4px;border:none;background:#FE2C55;color:#fff;font-size:14px;font-weight:600;cursor:pointer}\n\n/* Action bar (right side) */\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;filter:drop-shadow(0 0 4px rgba(0,0,0,.9)) drop-shadow(0 0 1px rgba(0,0,0,1))}\n.action-label{font-size:12px;font-weight:600;line-height:1;text-shadow:0 0 4px rgba(0,0,0,.9),0 1px 2px rgba(0,0,0,1)}\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 0 6px rgba(0,0,0,1),0 1px 4px rgba(0,0,0,.9),0 0 2px rgba(0,0,0,1)}\n#desc-line{font-size:14px;color:rgba(255,255,255,.85);line-height:1.35;text-shadow:0 0 6px rgba(0,0,0,1),0 1px 3px rgba(0,0,0,.9),0 0 2px rgba(0,0,0,1);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 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/* Heart burst (double-tap) */\n@keyframes heartBurst{0%{transform:scale(0);opacity:1}50%{transform:scale(1.4);opacity:1}100%{transform:scale(1.6) translateY(-40px);opacity:0}}\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\n// ── JS ───────────────────────────────────────────────────────────────\n\nfunction getJS(): string {\n return `\n(function(){\nvar vals=[],idx=0,fetching=false,liked=new Set(),totalLikes=0;\nvar LOAD_TIMEOUT=12000;\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\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]&&vals[idx].id))toggleLike();\n heartBurst(e);\n }\n lastTap=now;\n },{passive:true});\n\n loadVals();\n}\n\n// ── Data Loading ────────────────────────────────────\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 renderCards();\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\n// ── Card Rendering ──────────────────────────────────\n\nfunction renderCards(){\n vals.forEach(function(v,i){\n if(document.getElementById(\"c\"+i))return;\n el.feed.appendChild(createCard(v,i));\n });\n}\n\nfunction createCard(val,index){\n var card=document.createElement(\"div\");\n card.className=\"card\";card.id=\"c\"+index;\n\n var loader=document.createElement(\"div\");\n loader.className=\"card-loader\";\n loader.innerHTML='

Loading…

';\n\n var iframe=document.createElement(\"iframe\");\n iframe.sandbox=\"allow-scripts allow-same-origin allow-popups allow-forms allow-modals\";\n iframe.loading=\"lazy\";\n\n var loaded=false;\n iframe.onload=function(){\n loaded=true;\n // Check if iframe loaded an error page (about:blank, empty, etc.)\n try{\n var doc=iframe.contentDocument;\n // If we can access the doc and it's blank or very short, it's likely broken\n if(doc && doc.body && doc.body.innerHTML.length<20 && !doc.body.querySelector(\"*\")){\n showCardError(card,val,index);\n return;\n }\n }catch(e){/* cross-origin — that's fine, means it loaded something */}\n loader.classList.add(\"done\");\n };\n\n iframe.onerror=function(){\n if(!loaded) showCardError(card,val,index);\n };\n\n // Timeout: if still loading after N seconds, show error\n setTimeout(function(){\n if(!loaded){\n showCardError(card,val,index);\n }\n },LOAD_TIMEOUT);\n\n iframe.src=val.url;\n\n card.appendChild(iframe);\n card.appendChild(loader);\n return card;\n}\n\nfunction showCardError(card,val,index){\n // Don't double-add\n if(card.querySelector(\".card-error\"))return;\n\n // Hide loader\n var loader=card.querySelector(\".card-loader\");\n if(loader)loader.classList.add(\"done\");\n\n // Report broken to backend\n fetch(\"/api/broken\",{\n method:\"POST\",\n headers:{\"Content-Type\":\"application/json\"},\n body:JSON.stringify({id:val.id})\n }).catch(function(){});\n\n // Show error overlay\n var err=document.createElement(\"div\");\n err.className=\"card-error\";\n err.innerHTML='

This val didn\\\\'t load

';\n err.querySelector(\"button\").onclick=function(){go(index+1)};\n card.appendChild(err);\n}\n\n// ── Scroll / Navigation ─────────────────────────────\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\n// ── UI Updates ──────────────────────────────────────\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\n// ── Actions ─────────────────────────────────────────\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)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\n// ── Saved Panel ─────────────────────────────────────\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\n// ── Double-tap heart burst ──────────────────────────\n\nfunction heartBurst(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// ── Helpers ─────────────────────────────────────────\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",[],[58,78],"8d6401be-0380-11f1-8525-42dde27851f2","fetch-vals.ts","2108f7be-030c-11f1-8bbe-42dde27851f2",26,["D",1770398608775],"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",[],[58,88],"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",[],[58,96],"0b519c96-030c-11f1-8b91-42dde27851f2",["D",1770348568956],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Swipe through random public vals - like Tinder for vals","imageUrl","userId","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","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",{"_11":12,"_161":157},"org",{"_11":12,"_154":155,"_156":157,"_114":115,"_158":159,"_160":54},"branch",{"_17":80,"_13":16,"_34":41,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":14,"_153":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789552799&sig=9e2f7c6ad81bfe0a417f4ee593a56f46019d3f18deb24441c667547de12b5000","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":104,"_13":14,"_46":209,"_106":-5,"_107":54,"_108":109,"_110":109,"_111":112,"_113":-5,"_114":115,"_116":-5,"_117":54,"_118":-5,"_119":-5,"_120":62,"_121":122,"_123":124,"_125":126,"_127":210,"_129":-5,"_130":131,"_132":131,"_133":134,"_135":134,"_136":134,"_137":131,"_138":131,"_139":211,"_141":212,"_143":213,"_145":54},[194,198],"files",[194,195,196,197,198],"counts",{"_184":62,"_185":186,"_187":62,"_31":188,"_189":190},[180,181],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_18":183},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":182},[36],[58],"pulls","branches",1,"forks",{"_191":62,"_193":62},"connections",{"_191":62,"_192":62},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":63,"_51":-5,"_53":54,"_55":-5,"_68":207,"_18":208},{"_34":95,"_13":96,"_37":97,"_39":59,"_40":41,"_42":98,"_44":45,"_46":99,"_17":100,"_49":83,"_51":101,"_53":54,"_55":-5,"_68":205,"_18":206},{"_34":87,"_13":88,"_37":89,"_39":59,"_40":41,"_42":90,"_44":45,"_46":91,"_17":48,"_49":83,"_51":92,"_53":54,"_55":-5,"_68":203,"_18":204},{"_34":77,"_13":78,"_37":79,"_39":59,"_40":41,"_42":80,"_44":45,"_46":81,"_17":82,"_49":83,"_51":84,"_53":54,"_55":-5,"_68":201,"_18":202},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":199,"_18":200},[],[36],[],[58,78],[],[58,88],[],[58,96],[195,196,197],[58],["D",1770348568956],["D",1789540832752],{"_11":12,"_161":157},{"_11":12,"_154":155,"_156":157,"_114":115,"_158":159,"_160":54},{"_17":80,"_13":16,"_34":41,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":14,"_153":12},"ctx",{"_139":-5,"_177":247,"_248":249,"_250":251,"_252":54,"_253":54,"_254":54,"_255":45,"_256":-5,"_257":-7,"_258":-7,"_259":62,"_260":54,"_261":54,"_262":-5,"_263":54,"_264":54,"_265":54,"_266":-5},"ENV",{"_218":219,"_220":221,"_222":16,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246},"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"]

Code