Val — Tactile Knob

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_156":157,"_158":159},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_118":-5,"_20":119,"_22":120,"_121":122,"_123":124,"_25":125,"_24":-5,"_126":-5,"_127":-5,"_128":53,"_129":130,"_131":44,"_132":-5,"_133":-5,"_134":135},"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":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","chriswmartin","name","Cleveland-Buoy","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":44,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","88b71f7c-c931-4bce-a4be-88655ee6742c","main.tsx","fileId","648b2d0c-845b-11f0-9668-0224a6c84d84","parentId","branchId","64889574-845b-11f0-9668-0224a6c84d84","branchVersion",169,"latest",true,"createdAt",["D",1785351193091],168,"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 (Array.isArray(result)) return result;\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)) return result.rows;\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 requestedLimit = Number(url.searchParams.get(\"limit\") ?? MAX_ROWS);\n const limit = Math.min(\n Math.max(1, Number.isFinite(requestedLimit) ? Math.floor(requestedLimit) : MAX_ROWS),\n MAX_ROWS,\n );\n try {\n const q = `\n select id, fetched_at, water_temp_f, wave_height_ft, average_wave_height_ft,\n max_wave_height_ft, wave_period, wind_speed_mph, wind_direction\n from clewa_measurements_3\n order by id desc\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: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cache-Control\": \"no-store\",\n },\n });\n } catch (err) {\n console.error(\"Failed to load lake measurements\", err);\n return new Response(JSON.stringify({ rows: [], error: \"Unable to load measurements\" }), {\n status: 500,\n headers: {\n \"Content-Type\": \"application/json; charset=utf-8\",\n \"Cache-Control\": \"no-store\",\n },\n });\n }\n }\n\n const html = `\n\n\n \n \n Val — Tactile Knob\n \n\n\n

Lake Erie Conditions

—

Loading…

Water (°F)

—

Wave (ft)

—

Wind (mph)

—

\n \n \n \n

\n\n \n\n\n`;\n\n return new Response(html, {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1785351193091],"children",[],[35],"64882bac-845b-11f0-9668-0224a6c84d84",["D",1756418851197],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","d64c506a-4597-4bf9-ba45-8b6a781b5e0a","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","f9ac693b-9e35-4e47-8d7a-2fbf852b3f25","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,"_117":113},"org",{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yaTBjN1NNRHdvcjN4SFo5UFVJckxsUmZXaFoifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":151,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":-5,"_69":-5,"_70":71,"_72":37,"_73":44,"_74":44,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":152,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":153,"_98":154,"_100":155,"_102":53},[148],"files",[148],"counts",{"_138":77,"_139":140,"_141":77,"_31":142,"_143":144},[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":137},[35],"pulls","branches",2,"forks",{"_145":77,"_147":77},"connections",{"_145":77,"_146":77},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":149,"_18":150},[],[35],["D",1756418851197],["D",1789578655349],{"_11":12,"_117":113},{"_11":12,"_111":-5,"_112":113,"_70":71,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_133":189,"_190":191,"_192":193,"_194":53,"_195":53,"_196":53,"_197":44,"_198":-5,"_199":-7,"_200":-7,"_201":77,"_202":53,"_203":53,"_204":-5,"_205":53,"_206":53,"_207":53,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":16,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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