\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\n

\n \n \n \n `\n\n return c.html(html)\n})\n\nconst script = (async () => {\n const Plot = await import(\"https://cdn.jsdelivr.net/npm/@observablehq/plot@0.6/+esm\")\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 + \"+5\"),\n }))\n\n const extent = 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 ${i === length - 1 ? \"border-b\" : \"\"}`\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: { extent, 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",[98],"permalink","https://www.val.town/x/carburo/devstats/code/main.tsx","extension","actionData","errors"]