[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_297":298,"_299":300},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":57,"_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",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_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":24},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","crash_atomicity_probe.ts","latestPath","fileId","2466ba10-a990-11f1-9b5c-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst T=\"c4e7_crash_atomicity\";\nconst MARK=\"shadow/c4e7_crash_atomicity_marker.json\";\nconst sleep=(ms:number)=>new Promise(r=>setTimeout(r,ms));\n\nasync function readRow(){\n const r=await sqlite.execute(`SELECT v,note FROM ${T} WHERE id=1`);\n return r.rows[0]??null;\n}\nasync function setMarker(x:any){await blob.setJSON(MARK,{...x,at:Date.now()});}\n\nexport default async function(req:Request):Promise{\n const u=new URL(req.url);\n const action=u.searchParams.get(\"action\")||\"status\";\n const nonce=u.searchParams.get(\"nonce\")||\"default\";\n\n if(action===\"init\"){\n await sqlite.execute(`DROP TABLE IF EXISTS ${T}`);\n await sqlite.execute(`CREATE TABLE ${T}(id INTEGER PRIMARY KEY,v INTEGER NOT NULL,note TEXT NOT NULL)`);\n await sqlite.execute(`INSERT INTO ${T}(id,v,note) VALUES(1,0,'baseline')`);\n await setMarker({nonce,action,phase:\"READY\"});\n return Response.json({ok:true,action,nonce,row:await readRow()});\n }\n\n if(action===\"reset\"){\n const v=Number(u.searchParams.get(\"v\")||\"0\");\n const tx=await (sqlite as any).transaction(\"write\");\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='baseline' WHERE id=1`,args:[v]});\n await tx.commit();\n await setMarker({nonce,action,phase:\"RESET\",v});\n return Response.json({ok:true,action,nonce,row:await readRow()});\n }\n\n if(action===\"commit_control\"){\n const value=Number(u.searchParams.get(\"v\")||\"10\");\n const tx=await (sqlite as any).transaction(\"write\");\n const started=Date.now();\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='committed-control' WHERE id=1`,args:[value]});\n const wrote=Date.now();\n await tx.commit();\n const committed=Date.now();\n await setMarker({nonce,action,phase:\"COMMITTED\",value,started,wrote,committed});\n return Response.json({ok:true,action,nonce,started,wrote,committed,row:await readRow()});\n }\n\n if(action===\"throw_unhandled\"){\n const value=Number(u.searchParams.get(\"v\")||\"20\");\n const tx=await (sqlite as any).transaction(\"write\");\n const started=Date.now();\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='unhandled-uncommitted' WHERE id=1`,args:[value]});\n const wrote=Date.now();\n await setMarker({nonce,action,phase:\"WROTE_UNCOMMITTED\",value,started,wrote});\n throw new Error(\"C4E7_INTENTIONAL_UNHANDLED_AFTER_WRITE\");\n }\n\n if(action===\"return_open\"){\n const value=Number(u.searchParams.get(\"v\")||\"30\");\n const tx=await (sqlite as any).transaction(\"write\");\n const started=Date.now();\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='return-open-uncommitted' WHERE id=1`,args:[value]});\n const wrote=Date.now();\n await setMarker({nonce,action,phase:\"RETURNING_WITH_TX_OPEN\",value,started,wrote});\n return Response.json({ok:true,action,nonce,returned_with_open_transaction:true,started,wrote});\n }\n\n if(action===\"abandon\"){\n const value=Number(u.searchParams.get(\"v\")||\"40\");\n let tx:any=await (sqlite as any).transaction(\"write\");\n const started=Date.now();\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='abandoned-uncommitted' WHERE id=1`,args:[value]});\n const wrote=Date.now();\n tx=null;\n await setMarker({nonce,action,phase:\"REFERENCE_DROPPED\",value,started,wrote});\n await sleep(250);\n return Response.json({ok:true,action,nonce,reference_dropped:true,started,wrote,returned:Date.now()});\n }\n\n if(action===\"timeout_hold\"){\n const value=Number(u.searchParams.get(\"v\")||\"50\");\n const ms=Math.max(61000,Math.min(90000,Number(u.searchParams.get(\"ms\")||70000)));\n const tx=await (sqlite as any).transaction(\"write\");\n const started=Date.now();\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='timeout-uncommitted' WHERE id=1`,args:[value]});\n const wrote=Date.now();\n await setMarker({nonce,action,phase:\"TIMEOUT_HOLDING\",value,started,wrote,requested_ms:ms});\n await sleep(ms);\n await tx.commit();\n const committed=Date.now();\n await setMarker({nonce,action,phase:\"TIMEOUT_PATH_COMMITTED\",value,started,wrote,committed});\n return Response.json({ok:true,action,nonce,started,wrote,committed,row:await readRow()});\n }\n\n if(action===\"check\"){\n let marker:any=null;try{marker=JSON.parse(await (await blob.get(MARK)).text())}catch{}\n const started=Date.now();\n const row=await readRow();\n return Response.json({ok:true,action,nonce,started,read_at:Date.now(),row,marker});\n }\n\n if(action===\"post_write\"){\n const delta=Number(u.searchParams.get(\"delta\")||\"1\");\n const txStart=Date.now();\n const tx=await (sqlite as any).transaction(\"write\");\n const txObjectAt=Date.now();\n const r=await tx.execute(`SELECT v FROM ${T} WHERE id=1`);\n const firstStatementAt=Date.now();\n const before=Number((r.rows[0] as any).v);\n await tx.execute({sql:`UPDATE ${T} SET v=?,note='post-write' WHERE id=1`,args:[before+delta]});\n await tx.commit();\n const committedAt=Date.now();\n return Response.json({ok:true,action,nonce,before,after:before+delta,txStart,txObjectAt,firstStatementAt,committedAt,first_statement_delay_ms:firstStatementAt-txObjectAt,row:await readRow()});\n }\n\n return Response.json({ok:true,action:\"status\"});\n}","createdAt",["D",1788657197621],"branchVersion","branchId","b7adc8d8-2a44-4133-9edb-ce15696bf684","id","cd2463f0-cb23-40b9-b28a-3da55e82d4db","brain-shadow-tx-c4e7",["D",1788654882934],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Throwaway Brain transaction parity probe","imageUrl","6be0fc5c-1fef-4bd6-a1e1-67a3f8c0764e","pinnedFileId","01a07423-90d5-70c6-8557-62d52cebb5a9","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0715b-703f-741f-ab35-c85020e4a5e0","tursoName","cd2463f0cb2340b9b28a3da55e82d4db","tursoHostname","cd2463f0cb2340b9b28a3da55e82d4db-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789527031073],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",26,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","mosadek","handle","displayName","Mo Sadek","avatar","https://lh3.googleusercontent.com/a/ACg8ocL1eT_LHhKSg5px3nXIO6eez79aZXef466qXKh2gak-0iwrvw=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":292,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":293,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":294,"_82":295,"_84":296,"_86":24},"tree",[223,227,228,229,230,231,232,233,234,235,236],"files",[223,224,225,226,227,228,229,230,231,232,233,234,235,236],"counts",{"_213":61,"_214":174,"_215":61,"_216":217,"_218":219},"contents",[129,130,131,132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":207,"_31":208,"_29":209,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":210,"_13":61,"_32":211,"_34":-5,"_23":24,"_149":-5,"_26":212},{"_41":201,"_31":202,"_29":203,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":204,"_13":61,"_32":20,"_34":205,"_23":24,"_149":-5,"_26":206},{"_41":198,"_31":27,"_29":30,"_143":-5,"_39":40,"_38":14,"_145":57,"_36":199,"_13":61,"_32":33,"_34":35,"_23":24,"_149":-5,"_26":200},{"_41":191,"_31":192,"_29":193,"_143":-5,"_39":40,"_38":194,"_145":57,"_36":195,"_13":144,"_32":33,"_34":196,"_23":24,"_149":-5,"_26":197},{"_41":185,"_31":186,"_29":187,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":188,"_13":61,"_32":147,"_34":189,"_23":24,"_149":-5,"_26":190},{"_41":178,"_31":179,"_29":180,"_143":-5,"_39":40,"_38":181,"_145":57,"_36":182,"_13":61,"_32":147,"_34":183,"_23":24,"_149":-5,"_26":184},{"_41":172,"_31":173,"_29":55,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":175,"_13":61,"_32":33,"_34":176,"_23":24,"_149":-5,"_26":177},{"_41":165,"_31":166,"_29":167,"_143":-5,"_39":40,"_38":168,"_145":57,"_36":169,"_13":61,"_32":147,"_34":170,"_23":24,"_149":-5,"_26":171},{"_41":158,"_31":159,"_29":160,"_143":-5,"_39":40,"_38":161,"_145":57,"_36":162,"_13":61,"_32":147,"_34":163,"_23":24,"_149":-5,"_26":164},{"_41":151,"_31":152,"_29":153,"_143":-5,"_39":40,"_38":154,"_145":57,"_36":155,"_13":61,"_32":33,"_34":156,"_23":24,"_149":-5,"_26":157},{"_41":140,"_31":141,"_29":142,"_143":-5,"_39":40,"_38":144,"_145":57,"_36":146,"_13":61,"_32":147,"_34":148,"_23":24,"_149":-5,"_26":150},"36a83900-21fc-4ecc-a596-6ea9213f5c7c","tx_probe.ts","cc74516e-a98a-11f1-b61d-1607ee4eb77e","parentId",2,"latest",["D",1788654902545],"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nasync function main() {\n const table = \"c4e7_tx_probe\";\n const out: Record = {\n schema: \"BRAIN_VAL_NATIVE_TX_QUALIFICATION_V1\",\n sqlite_transaction_type: typeof (sqlite as any).transaction,\n pass: false,\n checks: {},\n };\n const checks = out.checks as Record;\n\n await sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\n await sqlite.execute(`CREATE TABLE ${table}(id INTEGER PRIMARY KEY, v INTEGER NOT NULL, note TEXT NOT NULL)`);\n await sqlite.execute({ sql: `INSERT INTO ${table}(id,v,note) VALUES(1,10,'seed')` });\n\n if (typeof (sqlite as any).transaction !== \"function\") {\n checks.transaction_api = \"MISSING\";\n console.log(JSON.stringify(out));\n return;\n }\n checks.transaction_api = \"PRESENT\";\n\n const tx1 = await (sqlite as any).transaction(\"write\");\n const r1 = await tx1.execute(`SELECT v FROM ${table} WHERE id=1`);\n const before = Number((r1.rows[0] as any).v);\n await tx1.execute({ sql: `UPDATE ${table} SET v=?, note='rollback' WHERE id=1`, args: [before + 1] });\n const r2 = await tx1.execute(`SELECT v FROM ${table} WHERE id=1`);\n const insideRollback = Number((r2.rows[0] as any).v);\n await tx1.rollback();\n const r3 = await sqlite.execute(`SELECT v,note FROM ${table} WHERE id=1`);\n const afterRollback = Number((r3.rows[0] as any).v);\n checks.interactive_read_write = before === 10 && insideRollback === 11;\n checks.rollback_isolation = afterRollback === 10 && (r3.rows[0] as any).note === \"seed\";\n\n const tx2 = await (sqlite as any).transaction(\"write\");\n const r4 = await tx2.execute(`SELECT v FROM ${table} WHERE id=1`);\n const dynamicBefore = Number((r4.rows[0] as any).v);\n const upd = await tx2.execute({\n sql: `UPDATE ${table} SET v=?, note='commit' WHERE id=1 AND v=?`,\n args: [dynamicBefore + 5, dynamicBefore],\n });\n await tx2.commit();\n const r5 = await sqlite.execute(`SELECT v,note FROM ${table} WHERE id=1`);\n checks.dynamic_conditional_commit =\n Number((upd as any).rowsAffected) === 1 &&\n Number((r5.rows[0] as any).v) === 15 &&\n (r5.rows[0] as any).note === \"commit\";\n\n const tx3 = await (sqlite as any).transaction(\"write\");\n let constraintCaught = false;\n try {\n await tx3.execute(`UPDATE ${table} SET v=99,note='should-rollback' WHERE id=1`);\n await tx3.execute(`INSERT INTO ${table}(id,v,note) VALUES(1,0,'duplicate')`);\n await tx3.commit();\n } catch (_e) {\n constraintCaught = true;\n try { await tx3.rollback(); } catch { /* already rolled back/closed */ }\n }\n const r6 = await sqlite.execute(`SELECT v,note FROM ${table} WHERE id=1`);\n checks.error_rollback =\n constraintCaught &&\n Number((r6.rows[0] as any).v) === 15 &&\n (r6.rows[0] as any).note === \"commit\";\n\n out.pass = Object.values(checks).every((v) => v === true || v === \"PRESENT\");\n await sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\n console.log(JSON.stringify(out));\n}\n\nawait main();\n","label",[141],"fb1fbf6c-545d-4f24-b5f0-de36b8565d1a","state_machine_probe.ts","30192e80-a98e-11f1-9774-1607ee4eb77e",9,["D",1788656358233],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst T=\"c4e7_generation_cas\";\nconst sleep=(ms:number)=>new Promise(r=>setTimeout(r,ms));\n\nexport default async function(req:Request):Promise{\n const u=new URL(req.url);\n const action=u.searchParams.get(\"action\")||\"status\";\n if(action===\"init\"){\n await sqlite.execute(`DROP TABLE IF EXISTS ${T}`);\n await sqlite.execute(`CREATE TABLE ${T}(k TEXT PRIMARY KEY,v INTEGER NOT NULL)`);\n await sqlite.execute(`INSERT INTO ${T}(k,v) VALUES('generation',0)`);\n return Response.json({ok:true,action,generation:0});\n }\n if(action===\"cas\"){\n const expected=Number(u.searchParams.get(\"expected\")||\"0\");\n const hold=Math.max(0,Math.min(1000,Number(u.searchParams.get(\"hold\")||\"0\")));\n const tx=await (sqlite as any).transaction(\"write\");\n const start=Date.now();\n const r=await tx.execute(`SELECT v FROM ${T} WHERE k='generation'`);\n const actual=Number((r.rows[0] as any).v);\n const readAt=Date.now();\n if(actual!==expected){\n await tx.rollback();\n return Response.json({ok:false,reason:\"STALE_WRITE\",expected,actual,start,readAt});\n }\n if(hold) await sleep(hold);\n const upd=await tx.execute({sql:`UPDATE ${T} SET v=? WHERE k='generation' AND v=?`,args:[actual+1,actual]});\n if(Number((upd as any).rowsAffected)!==1){\n await tx.rollback();\n return Response.json({ok:false,reason:\"CAS_RACE_LOST\",expected,actual,start,readAt});\n }\n await tx.commit();\n const committed=Date.now();\n return Response.json({ok:true,expected,actual,generation:actual+1,start,readAt,committed});\n }\n if(action===\"orchestrate\"){\n const self=new URL(req.url);\n self.search=\"?action=cas&expected=0&hold=250\";\n const p1=fetch(self).then(async r=>({status:r.status,body:await r.json()}));\n const p2=fetch(self).then(async r=>({status:r.status,body:await r.json()}));\n const [a,b]=await Promise.all([p1,p2]);\n const r=await sqlite.execute(`SELECT v FROM ${T} WHERE k='generation'`);\n const finalGeneration=Number((r.rows[0] as any).v);\n const oks=[a,b].filter((x:any)=>x.body?.ok===true).length;\n const stale=[a,b].filter((x:any)=>x.body?.reason===\"STALE_WRITE\").length;\n return Response.json({ok:oks===1&&stale===1&&finalGeneration===1,action,results:[a,b],final_generation:finalGeneration,successes:oks,stale_rejections:stale});\n }\n const r=await sqlite.execute(`SELECT v FROM ${T} WHERE k='generation'`).catch(()=>({rows:[]}));\n return Response.json({ok:true,action:\"status\",generation:(r.rows[0] as any)?.v??null});\n}",[152],"6fb269b6-b30c-4ea4-a934-5b4dcd2ccf59","nonfinite_sqlite_probe.ts","ecec8378-a98d-11f1-94a9-1607ee4eb77e",8,["D",1788656245533],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst table=\"c4e7_nonfinite\";\nawait sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\nawait sqlite.execute(`CREATE TABLE ${table}(name TEXT PRIMARY KEY,x REAL NOT NULL)`);\nconst cases:[string,number][]=[[\"inf\",Infinity],[\"ninf\",-Infinity],[\"nan\",NaN]];\nconst results:any[]=[];\nfor(const [name,x] of cases){\n try{\n await sqlite.execute({sql:`INSERT INTO ${table}(name,x) VALUES(?,?)`,args:[name,x]});\n const r=await sqlite.execute({sql:`SELECT x,typeof(x) AS typ FROM ${table} WHERE name=?`,args:[name]});\n const val=(r.rows[0] as any)?.x;\n results.push({name,inserted:true,returned:String(val),is_finite:Number.isFinite(Number(val)),is_nan:Number.isNaN(Number(val)),typeof_sql:(r.rows[0] as any)?.typ});\n }catch(e){results.push({name,inserted:false,error:String(e)});}\n}\nawait sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\nconsole.log(JSON.stringify({schema:\"BRAIN_VAL_NATIVE_NONFINITE_SQLITE_PROBE_V1\",results}));",[159],"34fe831b-411a-45c0-bb9f-01c23ab15833","multiwriter_probe.ts","7d12adf4-a98b-11f1-bf88-1607ee4eb77e",3,["D",1788655198900],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst table=\"c4e7_multiwriter\";\nawait sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\nawait sqlite.execute(`CREATE TABLE ${table}(id INTEGER PRIMARY KEY,v INTEGER NOT NULL)`);\nawait sqlite.execute(`INSERT INTO ${table}(id,v) VALUES(1,0)`);\nconst t0=Date.now();\nconst tx1=await (sqlite as any).transaction(\"write\");\nawait tx1.execute(`UPDATE ${table} SET v=1 WHERE id=1`);\nlet tx2AcquiredAt:number|null=null;\nconst p2=(async()=>{\n const tx2=await (sqlite as any).transaction(\"write\");\n tx2AcquiredAt=Date.now();\n const r=await tx2.execute(`SELECT v FROM ${table} WHERE id=1`);\n const seen=Number((r.rows[0] as any).v);\n await tx2.execute({sql:`UPDATE ${table} SET v=? WHERE id=1`,args:[seen+1]});\n await tx2.commit();\n return {seen};\n})();\nawait new Promise(r=>setTimeout(r,150));\nconst acquiredBeforeCommit=tx2AcquiredAt!==null;\nawait tx1.commit();\nconst tx2Result=await Promise.race([\n p2,\n new Promise((_,rej)=>setTimeout(()=>rej(new Error(\"TX2_TIMEOUT\")),3000))\n]);\nconst finalR=await sqlite.execute(`SELECT v FROM ${table} WHERE id=1`);\nconst finalV=Number((finalR.rows[0] as any).v);\nawait sqlite.execute(`DROP TABLE IF EXISTS ${table}`);\nconsole.log(JSON.stringify({\n schema:\"BRAIN_VAL_NATIVE_MULTIWRITER_QUALIFICATION_V1\",\n pass:!acquiredBeforeCommit&&(tx2Result as any).seen===1&&finalV===2,\n tx2_acquired_before_tx1_commit:acquiredBeforeCommit,\n tx2_seen_value:(tx2Result as any).seen,\n final_value:finalV,\n tx2_acquire_delay_ms:(tx2AcquiredAt??Date.now())-t0\n}));",[166],"14ed252d-1580-4166-9548-2f07106fa89c","main.tsx",1,["D",1788654882934],"/** @jsxImportSource npm:hono/jsx */\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport FormPage from \"./components/FormPage.tsx\";\nimport SubmissionsPage from \"./components/SubmissionsPage.tsx\";\nimport { addSubmission, listSubmissions } from \"./db.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => c.html());\n\napp.post(\"/submit\", async (c) => {\n const form = await c.req.formData();\n const name = String(form.get(\"name\") ?? \"\").trim();\n const email = String(form.get(\"email\") ?? \"\").trim();\n const message = String(form.get(\"message\") ?? \"\").trim();\n if (!name || !email || !message) {\n return c.text(\"Name, email, and message are all required.\", 400);\n }\n await addSubmission(name, email, message);\n return c.redirect(\"/submissions\");\n});\n\napp.get(\"/submissions\", async (c) => {\n const submissions = await listSubmissions();\n return c.html();\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n",[173],"49334ef3-31f4-4ba0-ae32-78a9ac00fd53","float_surface_probe.ts","a207f996-a98d-11f1-a18f-1607ee4eb77e",7,["D",1788656119898],"const vals=[\n 0,-0,1,-1,10,103.055,1e-7,1e-6,1e-5,1e15,1e16,1e20,1e21,\n 1.2345678901234567,1.0000000000000002,1.2e30,1.2e-30,5e-324,2.2250738585072014e-308\n];\nconsole.log(JSON.stringify(vals.map(v=>({v:String(v),json:JSON.stringify(v),negzero:Object.is(v,-0)}))));",[179],"5e399f6f-d7fd-4efa-abe5-347091198811","db.ts","01a07423-90d5-70c6-8557-5e397ecfed8e",["D",1788654882934],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface Submission {\n id: number;\n name: string;\n email: string;\n message: string;\n created_at: string;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS submissions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function addSubmission(name: string, email: string, message: string) {\n await sqlite.execute({\n sql: \"INSERT INTO submissions (name, email, message) VALUES (?, ?, ?)\",\n args: [name, email, message],\n });\n}\n\nexport async function listSubmissions(): Promise {\n const result = await sqlite.execute(\n \"SELECT id, name, email, message, created_at FROM submissions ORDER BY id DESC\",\n );\n return result.rows as unknown as Submission[];\n}\n",[186],"93a9ada8-e07d-421c-90c6-02d2ddd4081d","cross_invocation_probe.ts","1adc412a-a98d-11f1-8795-1607ee4eb77e",6,["D",1788655979040],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst TABLE = \"c4e7_cross_invocation\";\nconst MARK = \"shadow/c4e7_cross_invocation_marker.json\";\nconst sleep = (ms:number) => new Promise(r => setTimeout(r, ms));\n\nexport default async function(req: Request): Promise {\n const u = new URL(req.url);\n const action = u.searchParams.get(\"action\") || \"status\";\n const nonce = u.searchParams.get(\"nonce\") || \"default\";\n\n if (action === \"init\") {\n await sqlite.execute(`DROP TABLE IF EXISTS ${TABLE}`);\n await sqlite.execute(`CREATE TABLE ${TABLE}(id INTEGER PRIMARY KEY, v INTEGER NOT NULL, note TEXT NOT NULL)`);\n await sqlite.execute(`INSERT INTO ${TABLE}(id,v,note) VALUES(1,0,'seed')`);\n await blob.setJSON(MARK, {nonce, phase:\"READY\", at:Date.now()});\n return Response.json({ok:true,action,nonce});\n }\n\n if (action === \"hold\") {\n const holdMs = Math.max(500, Math.min(10000, Number(u.searchParams.get(\"ms\") || 4000)));\n const tx = await (sqlite as any).transaction(\"write\");\n const started = Date.now();\n await tx.execute(`UPDATE ${TABLE} SET v=1,note='hold-uncommitted' WHERE id=1`);\n const firstWriteDone = Date.now();\n await blob.setJSON(MARK, {nonce, phase:\"HOLDING\", started, firstWriteDone});\n await sleep(holdMs);\n await tx.commit();\n const committed = Date.now();\n await blob.setJSON(MARK, {nonce, phase:\"COMMITTED\", started, firstWriteDone, committed});\n return Response.json({ok:true,action,nonce,started,firstWriteDone,committed,hold_ms:committed-firstWriteDone});\n }\n\n if (action === \"probe_direct\") {\n const txStart = Date.now();\n const tx = await (sqlite as any).transaction(\"write\");\n const txObjectAt = Date.now();\n const r = await tx.execute(`SELECT v,note FROM ${TABLE} WHERE id=1`);\n const firstReadAt = Date.now();\n const seenV = Number((r.rows[0] as any).v);\n const seenNote = String((r.rows[0] as any).note);\n await tx.execute({sql:`UPDATE ${TABLE} SET v=?,note='probe-committed' WHERE id=1`,args:[seenV+1]});\n await tx.commit();\n const committedAt = Date.now();\n return Response.json({\n ok:true,action,nonce,\n txStart,txObjectAt,firstReadAt,committedAt,\n tx_object_delay_ms:txObjectAt-txStart,\n first_statement_delay_ms:firstReadAt-txObjectAt,\n seen_v:seenV,seen_note:seenNote\n });\n }\n\n if (action === \"orchestrate\") {\n const holdMs = Math.max(500, Math.min(5000, Number(u.searchParams.get(\"ms\") || 1500)));\n const tx = await (sqlite as any).transaction(\"write\");\n const started = Date.now();\n await tx.execute(`UPDATE ${TABLE} SET v=1,note='orchestrator-uncommitted' WHERE id=1`);\n const firstWriteDone = Date.now();\n\n let probeResolvedAt: number | null = null;\n const self = new URL(req.url);\n self.search = `?action=probe_direct&nonce=${encodeURIComponent(nonce)}`;\n const probePromise = fetch(self).then(async (resp) => {\n const body = await resp.json();\n probeResolvedAt = Date.now();\n return {http_status: resp.status, body};\n });\n\n await sleep(holdMs);\n const preCommit = Date.now();\n const probeResolvedBeforeCommit = probeResolvedAt !== null;\n await tx.commit();\n const committed = Date.now();\n\n let probe:any;\n try {\n probe = await Promise.race([\n probePromise,\n sleep(6000).then(() => ({http_status:599, body:{ok:false,error:\"PROBE_TIMEOUT\"}}))\n ]);\n } catch (e) {\n probe = {http_status:598, body:{ok:false,error:String(e)}};\n }\n\n return Response.json({\n ok:true,action,nonce,started,firstWriteDone,preCommit,committed,hold_ms:preCommit-firstWriteDone,\n probe_resolved_before_commit: probeResolvedBeforeCommit,\n probe_resolved_at: probeResolvedAt,\n probe\n });\n }\n\n if (action === \"final\") {\n const r = await sqlite.execute(`SELECT v,note FROM ${TABLE} WHERE id=1`);\n let m:any = null;\n try { m = JSON.parse(await (await blob.get(MARK)).text()); } catch {}\n return Response.json({ok:true,action,nonce,row:r.rows[0],marker:m});\n }\n\n return Response.json({ok:true,action:\"status\"});\n}\n",[192],"2e332d9e-5b44-4aa3-b4fd-cac7805955e4",["D",1788657197621],[27],"2e17fbc5-ffc2-4c01-9d36-fc4f5bd416cd","README.md","01a07423-90d5-70c6-8557-59e1c2065c15",["D",1788654882934],"# What's the easiest way to put a form online and save submissions?\n\nRemix this val. It serves a contact form (name, email, message) at `/`, saves every submission to the val's own SQLite database, and lists everything received at `/submissions`. No external services, no API keys, no env vars.\n\n## Setup\n\n1. Remix this val.\n2. Open the HTTP endpoint of `main.tsx` — that is your live form. Share the URL.\n3. Visit `/submissions` on the same URL to see what people sent.\n\nEach remix gets its own private SQLite database, so your submissions stay with your copy.\n\n## Files\n\n- `main.tsx` — Hono routes: GET `/` (form), POST `/submit` (save), GET `/submissions` (list)\n- `db.ts` — creates the `submissions` table and holds the two queries\n- `components/Layout.tsx` — shared page shell with Tailwind (via Twind)\n- `components/FormPage.tsx` — the form\n- `components/SubmissionsPage.tsx` — the list\n\n## Notes\n\n- `/submissions` is public by default. If your form collects anything sensitive, protect that route before sharing the form URL.\n- No client-side JavaScript: the form is a plain HTML POST.\n",[202],"9c3921b0-62ac-4d17-9802-04bfd60ad208","components","01a07423-90d5-70c6-8557-552c6cafbd62",["D",1788654882934],"directory",[208],"pulls","branches","forks","envVars",{"_220":61,"_222":61},"connections",{"_220":61,"_221":61},"count","unfilledCount","emptyCount",{"_41":207,"_31":208,"_29":209,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":289,"_13":61,"_32":211,"_34":-5,"_23":24,"_149":-5,"_238":290,"_26":291},{"_41":282,"_31":283,"_29":284,"_143":209,"_39":40,"_38":174,"_145":57,"_36":285,"_13":61,"_32":147,"_34":286,"_23":24,"_149":-5,"_238":287,"_26":288},{"_41":275,"_31":276,"_29":277,"_143":209,"_39":40,"_38":174,"_145":57,"_36":278,"_13":61,"_32":147,"_34":279,"_23":24,"_149":-5,"_238":280,"_26":281},{"_41":268,"_31":269,"_29":270,"_143":209,"_39":40,"_38":174,"_145":57,"_36":271,"_13":61,"_32":147,"_34":272,"_23":24,"_149":-5,"_238":273,"_26":274},{"_41":201,"_31":202,"_29":203,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":265,"_13":61,"_32":20,"_34":205,"_23":24,"_149":-5,"_238":266,"_26":267},{"_41":198,"_31":27,"_29":30,"_143":-5,"_39":40,"_38":14,"_145":57,"_36":262,"_13":61,"_32":33,"_34":35,"_23":24,"_149":-5,"_238":263,"_26":264},{"_41":191,"_31":192,"_29":193,"_143":-5,"_39":40,"_38":194,"_145":57,"_36":259,"_13":144,"_32":33,"_34":196,"_23":24,"_149":-5,"_238":260,"_26":261},{"_41":185,"_31":186,"_29":187,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":256,"_13":61,"_32":147,"_34":189,"_23":24,"_149":-5,"_238":257,"_26":258},{"_41":178,"_31":179,"_29":180,"_143":-5,"_39":40,"_38":181,"_145":57,"_36":253,"_13":61,"_32":147,"_34":183,"_23":24,"_149":-5,"_238":254,"_26":255},{"_41":172,"_31":173,"_29":55,"_143":-5,"_39":40,"_38":174,"_145":57,"_36":250,"_13":61,"_32":33,"_34":176,"_23":24,"_149":-5,"_238":251,"_26":252},{"_41":165,"_31":166,"_29":167,"_143":-5,"_39":40,"_38":168,"_145":57,"_36":247,"_13":61,"_32":147,"_34":170,"_23":24,"_149":-5,"_238":248,"_26":249},{"_41":158,"_31":159,"_29":160,"_143":-5,"_39":40,"_38":161,"_145":57,"_36":244,"_13":61,"_32":147,"_34":163,"_23":24,"_149":-5,"_238":245,"_26":246},{"_41":151,"_31":152,"_29":153,"_143":-5,"_39":40,"_38":154,"_145":57,"_36":241,"_13":61,"_32":33,"_34":156,"_23":24,"_149":-5,"_238":242,"_26":243},{"_41":140,"_31":141,"_29":142,"_143":-5,"_39":40,"_38":144,"_145":57,"_36":237,"_13":61,"_32":147,"_34":148,"_23":24,"_149":-5,"_238":239,"_26":240},["D",1788654902545],"children",[],[141],["D",1788656358233],[],[152],["D",1788656245533],[],[159],["D",1788655198900],[],[166],["D",1788654882934],[],[173],["D",1788656119898],[],[179],["D",1788654882934],[],[186],["D",1788655979040],[],[192],["D",1788657197621],[],[27],["D",1788654882934],[],[202],"5f926b2f-4fde-474f-963c-ec1e70e79b5e","SubmissionsPage.tsx","01a07423-90d5-70c6-8557-50b7c4729ded",["D",1788654882934],"/** @jsxImportSource npm:hono/jsx */\nimport type { Submission } from \"../db.ts\";\nimport Layout from \"./Layout.tsx\";\n\nexport default function SubmissionsPage({ submissions }: { submissions: Submission[] }) {\n return (\n \n

Submissions ({submissions.length})

\n {submissions.length === 0\n ?

Nothing yet. Be the first to submit the form.

\n : (\n

\n
\n {s.name}\n {s.created_at}\n
\n
{s.email}
\n
{s.message}
\n

\n )}\n

\n back to form\n view source\n

\n \n );\n}\n",[],[208,269],"0f48a5fc-bde3-46e3-8c2a-bca3f129e8d6","Layout.tsx","01a07423-90d4-7139-98b5-a88de174e1fd",["D",1788654882934],"/** @jsxImportSource npm:hono/jsx */\n\nexport default function Layout({ title, children }: { title: string; children?: unknown }) {\n return (\n \n \n \n \n {title}\n \n \n \n \n

{children}

\n \n \n );\n}\n",[],[208,276],"6d8f9a93-bf70-4540-8e08-22e49c308da9","FormPage.tsx","01a07423-90d4-7139-98b5-a554b9b81841",["D",1788654882934],"/** @jsxImportSource npm:hono/jsx */\nimport Layout from \"./Layout.tsx\";\n\nexport default function FormPage() {\n return (\n \n

Contact form

\n Submissions are saved to this val's SQLite database.\n

\n \n

\n view submissions\n view source\n

\n \n );\n}\n",[],[208,283],["D",1788654882934],[224,225,226],[208],["D",1788654882934],["D",1789527031073],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_126":330,"_331":332,"_333":334,"_335":24,"_336":24,"_337":24,"_338":57,"_339":-5,"_340":-7,"_341":-7,"_342":61,"_343":24,"_344":24,"_345":-5,"_346":24,"_347":24,"_348":24,"_349":-5},"ENV",{"_301":302,"_303":304,"_305":88,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329},"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 · v10