[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_175":176,"_177":178},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_133":-5,"_20":134,"_22":135,"_136":137,"_138":139,"_25":140,"_24":-5,"_141":-5,"_142":-5,"_143":54,"_144":145,"_146":45,"_147":-5,"_148":-5,"_149":150},"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","kemilrajejarude","name","profcar-transcribe-260827","branchName","main","version","path","","project",{"_34":75,"_13":14,"_46":76,"_77":-5,"_78":54,"_79":80,"_81":80,"_82":83,"_84":-5,"_85":86,"_87":59,"_88":45,"_89":-5,"_90":-5,"_91":62,"_92":93,"_94":95,"_96":97,"_98":99,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":54},"tree",[66,67],"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":64,"_53":54,"_55":-5,"_18":65},{"_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","fb07e82c-96d2-437b-a52b-3b3e5e050398","transcribe.ts","fileId","ecdf74e6-a26a-11f1-8246-1607ee4eb77e","parentId","branchId","57cd85ed-a07d-476c-96fe-0a3b3306ff39","branchVersion",2,"latest",true,"createdAt",["D",1787871591208],1,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst AUDIO = \"https://a4af93de-8439-4a25-b77d-3369556baa8c.sandbox.floot.app/_cdn/static/5206286e-4321-4b33-aea5-4284dc21c990-26082709080910452_compactado_8k_full.ogg\";\nconst STT = \"https://notetakers.vipresearch.ca/stt/v1/transcribe\";\nconst SEG_SEC = 1200;\nconst SEGMENTS = 9;\n\nfunction u32(d: Uint8Array,o:number){return (d[o]|d[o+1]<<8|d[o+2]<<16|d[o+3]<<24)>>>0}\nfunction u64(d:Uint8Array,o:number){return Number(BigInt(u32(d,o))+(BigInt(u32(d,o+4))<<32n))}\nfunction w32(d:Uint8Array,o:number,v:number){d[o]=v&255;d[o+1]=(v>>>8)&255;d[o+2]=(v>>>16)&255;d[o+3]=(v>>>24)&255}\nfunction w64(d:Uint8Array,o:number,v:number){const b=BigInt(Math.floor(v));w32(d,o,Number(b&0xffffffffn));w32(d,o+4,Number((b>>32n)&0xffffffffn))}\nfunction crc(d:Uint8Array){let c=0>>>0;for(const b of d){c=(c^(b<<24))>>>0;for(let i=0;i<8;i++)c=(c&0x80000000)?(((c<<1)>>>0)^0x04C11DB7)>>>0:(c<<1)>>>0}return c>>>0}\nfunction patch(raw:Uint8Array,serial:number,seq:number,gran:number,ht:number){const x=new Uint8Array(raw);x[5]=ht;w64(x,6,gran);w32(x,14,serial);w32(x,18,seq);w32(x,22,0);w32(x,22,crc(x));return x}\ntype Pg={p:number,size:number,g:number,type:number};\nfunction parse(d:Uint8Array){let p=0,a:Pg[]=[];while(p0){const b=audio.findIndex(x=>x.g>=startThr);start=b<0?audio.length:b+1}if(start>=audio.length)return null;let end=audio.findIndex((x,i)=>i>=start&&x.g>=endThr);if(end<0)end=audio.length-1;const base=start===0?0:audio[start-1].g;const serial=(0x7c270000+index*7919)>>>0;const parts=[patch(d.slice(head.p,head.p+head.size),serial,0,0,2),patch(d.slice(tags.p,tags.p+tags.size),serial,1,0,0)];let seq=2;for(let i=start;i<=end;i++){const x=audio[i];let ht=x.type&1;if(i===end)ht|=4;parts.push(patch(d.slice(x.p,x.p+x.size),serial,seq++,(x.g-base)+preskip,ht))}return {bytes:join(parts),startSec:index*SEG_SEC,endSec:Math.min((index+1)*SEG_SEC,(audio[audio.length-1].g-preskip)/48000)} }\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS segments (idx INTEGER PRIMARY KEY, ok INTEGER NOT NULL, text TEXT, error TEXT, start_sec REAL, end_sec REAL, audio_bytes INTEGER, status INTEGER, processing_ms INTEGER, created_at TEXT DEFAULT CURRENT_TIMESTAMP)`);\nconst existing=await sqlite.execute(\"SELECT idx FROM segments WHERE ok=1 ORDER BY idx\");\nconst done=new Set(existing.rows.map((r:any)=>Number(r.idx)));\nlet index=-1; for(let i=0;i

Code