\n Developer Statistics\n ${max ? `Updated ${max}` : \"\"}\n

\n This page receives data from our GitHub Actions runs and other developer-adjacent\n data, and then shows us statistics of those values over time. We're using it to track\n how our dependencies sizes and other stats affect our application.\n

\n \n

\n View source: Val Town (generated with Deno ${Deno.version.deno})\n

\n \n \n \n `;\n\n return c.html(html);\n});\n\nconst script = (async () => {\n const Plot = await import(\n \"https://cdn.jsdelivr.net/npm/@observablehq/plot@0.6/+esm\"\n );\n const d3 = await import(\"https://cdn.jsdelivr.net/npm/d3@7/+esm\");\n const data = ((window as any).DATA as Rows).map((d) => ({\n ...d,\n date: new Date(d.date + \"+05\"),\n }));\n\n const domain = d3.extent(data, (d) => d.date);\n\n const groups: Record = {};\n for (let x of data) {\n groups[x.name] = groups[x.name] || [];\n groups[x.name].push(x);\n }\n const container = document.querySelector(\"#plot\")!;\n\n Object.entries(groups).map(([name, data], i, { length }) => {\n const wrap = container.appendChild(document.createElement(\"div\"));\n const c = d3.schemeTableau10[i];\n wrap.className = `relative bg-[${c}] border-t border-[${c}] bg-opacity-10 ${\n i === length - 1 ? \"border-b\" : \"\"\n }`;\n const title = wrap.appendChild(document.createElement(\"h2\"));\n title.className =\n `text-xs bg-[${c}] text-[${c}] block p-1 rounded bg-opacity-10 font-semibold font-mono absolute top-1 left-1`;\n title.innerText = name;\n const div = wrap.appendChild(document.createElement(\"div\"));\n const width = div.getBoundingClientRect().width;\n const plot = Plot.lineY(data, {\n x: \"date\",\n y: \"value\",\n curve: \"step-after\",\n stroke: () => c,\n tip: true,\n }).plot({\n width,\n x: { domain, grid: true },\n y: { grid: true, label: null, paddingOuter: 100 },\n marginLeft: 80,\n marginBottom: 40,\n marginTop: 40,\n height: 300,\n });\n div.append(plot);\n });\n}).toString().split(\"\\n\").slice(1).slice(0, -1).join(\"\\n\");\n\nasync function getRows() {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME}`);\n const rows = result.rows.map((r) => ({\n id: String(r[0]),\n name: String(r[1]),\n value: +r[2],\n date: String(r[3]),\n }));\n return rows;\n}\n\ntype Rows = Awaited>;\n\napp.get(\"/api\", async function apiRoute(c) {\n try {\n return c.json(await getRows());\n } catch (error) {\n console.error(\"Error fetching data:\", error);\n return c.text(\"Error fetching data\", 500);\n }\n});\n\napp.post(\"/\", async (c) => {\n try {\n const authHeader = c.req.header(\"Authorization\");\n if (authHeader !== `Bearer ${Deno.env.get(\"DEVSTATS_KEY\")}`) {\n return c.text(\"Unauthorized\", 401);\n }\n\n const { name, value } = await c.req.json();\n\n if (!name || !value) {\n return c.text(\"Missing name or value in the request body\", 400);\n }\n\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAME} (name, value) VALUES (?, ?)`,\n args: [name, value],\n });\n\n return c.text(\"Data inserted successfully\", 201);\n } catch (error) {\n console.error(\"Error inserting data:\", error);\n return c.text(\"Error inserting data\", 500);\n }\n});\n\nexport default async function (req: Request): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n value REAL NOT NULL,\n date DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n return app.fetch(req);\n}","deleted","label","tmcw-devstats",[98],"permalink","https://www.val.town/x/tmcw/devstats/code/main.tsx","extension","actionData","errors"]