\n \n {label}\n \n \n {value != null ? value.toFixed(1) : \"—\"}\n {unit}\n \n

\n );\n}\n\nfunction App() {\n const [readings, setReadings] = useState([]);\n const [lastUpdated, setLastUpdated] = useState(null);\n const [error, setError] = useState(null);\n\n const fetchData = useCallback(async () => {\n try {\n const res = await fetch(API_URL);\n if (!res.ok) throw new Error(`HTTP ${res.status}`);\n const data = await res.json();\n\n // Normalise: val town sqlite returns { columns, rows } or plain array\n let rows: any[] = [];\n if (Array.isArray(data)) {\n rows = data;\n } else if (data.rows) {\n // { columns: [...], rows: [[...], ...] }\n rows = data.rows.map((r: any[]) =>\n Object.fromEntries(\n data.columns.map((c: string, i: number) => [c, r[i]]),\n )\n );\n }\n\n // Sort ascending by recorded_at, keep last 50 points\n rows.sort((a, b) => a.recorded_at?.localeCompare(b.recorded_at));\n setReadings(rows.slice(-50));\n setLastUpdated(new Date());\n setError(null);\n } catch (e: any) {\n setError(e.message);\n }\n }, []);\n\n useEffect(() => {\n fetchData();\n const id = setInterval(fetchData, POLL_INTERVAL_MS);\n return () => clearInterval(id);\n }, [fetchData]);\n\n const latest = readings.at(-1);\n\n const chartData = readings.map((r) => ({\n time: formatTime(r.recorded_at),\n temperature: Number(r.temperature),\n humidity: Number(r.humidity),\n }));\n\n console.log({ chartData });\n\n return (\n

\n {/* Header */}\n

\n ESP32 Sensor Dashboard\n

\n {latest?.port ?? \"—\"} · auto-refresh every{\" \"}\n {POLL_INTERVAL_MS / 1000}s\n

\n {lastUpdated\n ? (\n <>\n Last updated
\n {lastUpdated.toLocaleTimeString()}\n \n )\n : \"Loading…\"}\n

\n\n {/* Error banner */}\n {error && (\n

\n ❌ {error}\n

\n )}\n\n {/* Stat cards */}\n

\n \n \n

\n \n Readings\n \n \n {readings.length}\n \n

\n\n {/* Chart */}\n

\n History\n

\n {readings.length === 0\n ? (\n

\n No data yet…\n

\n )\n : (\n \n \n \n \n \n \n \n \n \n \n \n \n )}\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n return new Response(\n `\n \n \n ESP32 Sensor Dashboard\n \n \n \n \n

\n \n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}",[],[201],"files",[159,180,189,199],"counts",{"_211":33,"_212":213,"_214":33,"_215":216,"_219":220},"pulls","branches",1,"forks","envVars",{"_217":33,"_218":33},"count","emptyCount","connections",{"_217":33,"_221":33},"unfilledCount","contents",[],"file",{"_106":160,"_97":101,"_161":162,"_163":-5,"_164":147,"_165":166,"_167":168,"_108":226,"_102":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_100":227},["D",1771613012441],[101],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_95":96,"_97":98,"_99":45,"_102":103,"_100":101,"_104":236,"_157":241,"_207":254,"_224":255,"_222":257,"_258":-5,"_259":-5,"_260":-5,"_261":-5,"_262":263,"_215":-5},{"_106":107,"_97":98,"_108":237,"_110":-5,"_111":22,"_112":113,"_114":-5,"_115":-5,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":124,"_125":126,"_127":128,"_129":128,"_130":131,"_132":131,"_133":131,"_134":128,"_135":128,"_23":238,"_139":239,"_144":240,"_156":22},["D",1771499763519],{"_95":96,"_137":138},{"_95":96,"_141":138,"_14":116,"_142":143},{"_102":146,"_97":45,"_106":147,"_148":107,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":98,"_155":96},[242,245,248,251],{"_106":160,"_97":101,"_161":162,"_163":-5,"_164":147,"_165":166,"_167":168,"_108":169,"_102":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_177":243,"_100":244},[],[101],{"_106":181,"_97":182,"_161":183,"_163":-5,"_164":147,"_165":184,"_167":168,"_108":185,"_102":170,"_171":172,"_173":186,"_175":22,"_176":-5,"_177":246,"_100":247},[],[182],{"_106":190,"_97":191,"_161":192,"_163":-5,"_164":147,"_165":193,"_167":168,"_108":194,"_102":195,"_171":172,"_173":196,"_175":22,"_176":-5,"_177":249,"_100":250},[],[191],{"_106":200,"_97":201,"_161":202,"_163":-5,"_164":147,"_165":103,"_167":22,"_108":203,"_102":170,"_171":172,"_173":204,"_175":22,"_176":-5,"_177":252,"_100":253},[],[201],[242,245,248,251],{"_106":160,"_97":101,"_161":162,"_163":-5,"_164":147,"_165":166,"_167":168,"_108":226,"_102":170,"_171":172,"_173":174,"_175":22,"_176":-5,"_100":256},[101],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

nmsilva

esp32-sensors