Val — Time Dial (diagnostics + robust load)

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_130":-5,"_20":131,"_22":132,"_133":134,"_135":136,"_25":137,"_24":-5,"_138":-5,"_139":140,"_141":51,"_142":143,"_144":69,"_145":-5,"_146":-5,"_147":148},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":28,"_29":-5,"_30":31,"_32":33,"_34":-5},"handle","chriswmartin","name","Cleveland-Buoy","branchName","Updated","version","path","","project",{"_35":43,"_13":14,"_37":84,"_49":-5,"_85":51,"_52":53,"_86":53,"_87":-5,"_88":-5,"_89":90,"_91":92,"_93":69,"_94":69,"_95":-5,"_96":31,"_55":56,"_97":98,"_99":100,"_101":102,"_103":-5,"_104":105,"_106":105,"_107":108,"_109":108,"_110":108,"_111":105,"_112":105,"_113":114,"_115":116,"_117":118,"_50":51},"tree",[79],"file","contents",[58],"upstream",{"_35":36,"_37":38,"_39":40,"_13":41,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":12,"_55":56,"_57":14},"pull","ahead",0,"behind",100,"envVars","id","64889574-845b-11f0-9668-0224a6c84d84","createdAt",["D",1756418851197],"updatedAt",["D",1785351193091],"main","projectId","64882bac-845b-11f0-9668-0224a6c84d84",169,"forkedBranchId","forkedBranchVersion","lockfileKey","1785351194230-esm.town_v_chriswmartin_Cleveland-Buoy@169-main","deletedAt","isOwned",false,"privacy","public","userHandle","orgId","f9ac693b-9e35-4e47-8d7a-2fbf852b3f25","projectName",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_18":78},"58465e3e-8a5c-11f0-ab96-0224a6c84d84","main.tsx","fileId","01991a11-2b2e-73d9-8a44-2e82630244e9","parentId","branchId","522741da-8a5c-11f0-ba06-0224a6c84d84","branchVersion",2,"latest",true,["D",1757078967098],1,"fileType","http","content","// dial_val.ts\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst MAX_ROWS = 5000;\n\nfunction mapSqlResultToObjects(result: any) {\n if (!result) return [];\n if (\n Array.isArray(result) && result.length && typeof result[0] === \"object\" &&\n !Array.isArray(result[0])\n ) {\n return result;\n }\n if (\n result.rows && Array.isArray(result.rows) && Array.isArray(result.columns)\n ) {\n return result.rows.map((row: any[]) =>\n Object.fromEntries(row.map((v, i) => [result.columns[i], v]))\n );\n }\n if (result.rows && Array.isArray(result.rows)) {\n return result.rows;\n }\n return [];\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // API: return DB measurements\n if (url.pathname === \"/api/measurements\") {\n const limitParam = Number(url.searchParams.get(\"limit\") ?? 1000);\n const limit = Math.min(\n Number.isFinite(limitParam) && limitParam > 0 ? limitParam : 1000,\n MAX_ROWS,\n );\n try {\n const q = `\n select id, fetched_at, water_temp_f, wave_height_ft, wind_speed_mph\n from clewa_measurements\n order by id asc\n limit :limit\n `;\n const result = await sqlite.execute({ sql: q, args: { limit } });\n const rows = mapSqlResultToObjects(result);\n return new Response(JSON.stringify({ rows }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n } catch (err) {\n return new Response(JSON.stringify({ rows: [], error: String(err) }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n }\n }\n\n // UI HTML (assembled as lines to avoid server-side interpolation)\n const html = [\n \"\",\n '',\n \"\",\n ' ',\n ' ',\n \" Val — Time Dial (diagnostics + robust load)\",\n \" \",\n \"\",\n \"\",\n '

',\n '

—

',\n '

Loading…

',\n '

Water (°F)

—

',\n '

Wave (ft)

—

',\n '

Wind (mph)

—

',\n \"

\",\n \"

\",\n '

',\n ' ',\n ' ',\n ' ',\n ' 0 / 0',\n ' ',\n \"

\",\n \" \",\n \"\",\n \"\",\n ].join(\"\\n\");\n\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted","label",[60],{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":80,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_81":82,"_18":83},["D",1757078967098],"children",[],[60],["D",1756418851197],"legacyEnvVars","httpPrivacy","description","imageUrl","userId","d64c506a-4597-4bf9-ba45-8b6a781b5e0a","pinnedFileId","648b2d0c-845b-11f0-9668-0224a6c84d84","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","64882bac845b11f096680224a6c84d84","tursoHostname","64882bac845b11f096680224a6c84d84-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789578655349],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_129":125},"org",{"_11":12,"_123":-5,"_124":125,"_89":90,"_126":127,"_128":51},"branch",{"_17":67,"_13":16,"_35":65,"_42":43,"_45":36,"_46":119,"_120":53,"_121":43,"_122":56,"_57":14,"_54":12},69,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTBjN1NNRHdvcjN4SFo5UFVJckxsUmZXaFoifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":43,"_13":14,"_37":165,"_49":-5,"_85":51,"_52":53,"_86":53,"_87":-5,"_88":-5,"_89":90,"_91":92,"_93":69,"_94":69,"_95":-5,"_96":31,"_55":56,"_97":98,"_99":100,"_101":166,"_103":-5,"_104":105,"_106":105,"_107":108,"_109":108,"_110":108,"_111":105,"_112":105,"_113":167,"_115":168,"_117":169,"_50":51},[162],"files",[162],"counts",{"_153":31,"_154":67,"_155":31,"_34":156,"_157":158},[151],"upstreamProject","upstreamBranch",{"_35":36,"_37":149,"_39":150,"_13":41,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":12,"_55":56,"_57":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1756418851197],["D",1785351193091],{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":70,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_18":152},[60],"pulls","branches","forks",{"_159":31,"_161":31},"connections",{"_159":31,"_160":31},"count","unfilledCount","emptyCount",{"_35":59,"_13":60,"_61":62,"_63":-5,"_64":65,"_66":67,"_68":69,"_37":80,"_17":71,"_72":73,"_74":75,"_76":51,"_77":-5,"_81":163,"_18":164},[],[60],["D",1756418851197],["D",1789578655349],{"_11":12,"_129":125},{"_11":12,"_123":-5,"_124":125,"_89":90,"_126":127,"_128":51},{"_17":67,"_13":16,"_35":65,"_42":43,"_45":36,"_46":119,"_120":53,"_121":43,"_122":56,"_57":14,"_54":12},"ctx",{"_113":-5,"_146":203,"_204":205,"_206":207,"_208":51,"_209":51,"_210":51,"_211":69,"_212":-5,"_213":-7,"_214":-7,"_215":31,"_216":51,"_217":51,"_218":-5,"_219":51,"_220":51,"_221":51,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":41,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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