Repo stars

Repo stars

No data yet. Run laszlocph/capacitorReleaseStatsCollector once (or wait for the daily cron).

\n \n `,\n { headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n const cumulative = rows.map((r) => Number(r.stars_total));\n const delta = rows.map((r) => Number(r.stars_delta));\n const mainSeries =\n mode === \"delta\"\n ? delta.map((n) => (Number.isFinite(n) ? n : null))\n : cumulative.map((n) => (Number.isFinite(n) ? n : null));\n const trend =\n mode === \"delta\" && trendWindow > 1 ? movingAverage(mainSeries, trendWindow) : null;\n\n const selectedDate = dateParam || latestDate;\n const stargazers = (await sql`\n SELECT login, html_url, avatar_url, starred_at\n FROM github_repo_daily_stargazers\n WHERE repo = ${REPO} AND snapshot_date = ${selectedDate}\n ORDER BY login ASC;\n `) as StargazerRow[];\n\n const recentDaysWithStars = (await sql<{ snapshot_date: string; stars_delta: number }>`\n SELECT snapshot_date, stars_delta\n FROM github_repo_daily_metrics\n WHERE repo = ${REPO} AND stars_delta > 0\n ORDER BY snapshot_date DESC\n LIMIT 20;\n `) as Array<{ snapshot_date: string; stars_delta: number }>;\n\n const payload = {\n repo: REPO,\n metric: \"stars\",\n mode,\n trendWindow,\n latestDate,\n dates,\n stars_total: cumulative,\n stars_delta: delta,\n selectedDate,\n stargazers,\n recentDaysWithStars,\n };\n\n if (format === \"json\") {\n return new Response(JSON.stringify(payload, null, 2), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n const datasets = [\n {\n label: mode === \"delta\" ? \"New stars / day\" : \"Stars (total)\",\n data: mainSeries,\n borderWidth: 2,\n pointRadius: 1.5,\n tension: 0.2,\n borderColor: \"hsl(215 80% 45%)\",\n backgroundColor: \"hsl(215 80% 45% / 0.15)\",\n },\n ...(trend\n ? [\n {\n label: `${trendWindow}-day avg`,\n data: trend,\n borderWidth: 2,\n pointRadius: 0,\n borderDash: [6, 6],\n tension: 0.15,\n borderColor: \"hsl(0 0% 20%)\",\n backgroundColor: \"transparent\",\n },\n ]\n : []),\n ];\n\n const stargazerHtml =\n stargazers.length === 0\n ? `

No stars recorded for ${htmlEscape(selectedDate)}.

`\n : `

\n ${stargazers\n .map(\n (s) => `\n $\"${htmlEscape(s.login)}\"$ \n

@${htmlEscape(s.login)}

\n `,\n )\n .join(\"\")}\n

`;\n\n const dayLinks = recentDaysWithStars\n .map((d) => {\n const href = hrefWith({ metric: \"stars\", date: d.snapshot_date });\n return `${htmlEscape(d.snapshot_date)} (+${htmlEscape(\n String(d.stars_delta),\n )})`;\n })\n .join(\" · \");\n\n const dateOptions = dates\n .slice(-90)\n .map((d) => {\n const selected = d === selectedDate ? \" selected\" : \"\";\n return ``;\n })\n .join(\"\");\n\n return new Response(\n `\n \n \n \n \n ${htmlEscape(REPO)} – stars\n \n \n \n \n

Repo stars

\n Downloads\n Stars\n

Repo: ${htmlEscape(REPO)} · Latest snapshot: ${htmlEscape(\n latestDate,\n )}

\n Cumulative\n Daily delta\n trend:\n off ·\n 7d ·\n 14d\n \n format:\n html ·\n json\n \n

Days with new stars (click to see profiles):

${dayLinks || `None yet.`}

Stargazers · ${htmlEscape(selectedDate)}

\n \n

${htmlEscape(String(stargazers.length))} users

\n ${stargazerHtml}\n

\n \n \n `,\n { headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n const latestRows = (await sql<\n { d: string | null }\n >`SELECT MAX(snapshot_date) AS d FROM github_release_asset_downloads WHERE repo = ${REPO};`) as Array<\n { d: string | null }\n >;\n const latestDate = latestRows?.[0]?.d ?? null;\n\n if (!latestDate) {\n return new Response(\n `\n \n \n \n \n Capacitor release stats\n \n \n \n

Capacitor release stats

No data yet. Run laszlocph/capacitorReleaseStatsCollector once (or wait for the daily cron) to populate SQLite.

\n \n `,\n { headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n // If tag is provided: per-asset time series for that tag.\n if (tag) {\n const rows = (await sql`\n SELECT snapshot_date, asset, download_count\n FROM github_release_asset_downloads\n WHERE repo = ${REPO} AND tag = ${tag}\n ORDER BY snapshot_date ASC, asset ASC;\n `) as TimeseriesRow[];\n\n const byAsset = new Map>();\n const dates: string[] = [];\n const dateSet = new Set();\n\n for (const r of rows) {\n if (!dateSet.has(r.snapshot_date)) {\n dateSet.add(r.snapshot_date);\n dates.push(r.snapshot_date);\n }\n const m = byAsset.get(r.asset) ?? new Map();\n m.set(r.snapshot_date, r.download_count);\n byAsset.set(r.asset, m);\n }\n\n const assetDatasets = [...byAsset.entries()].map(([asset, series], idx) => {\n const cumulative = dates.map((d) => series.get(d) ?? null);\n const data = mode === \"delta\" ? deltasFromCumulative(cumulative) : cumulative;\n return {\n label: asset,\n data,\n borderWidth: 2,\n pointRadius: 1.5,\n spanGaps: true,\n tension: 0.2,\n borderColor: `hsl(${(idx * 47) % 360} 70% 45%)`,\n backgroundColor: `hsl(${(idx * 47) % 360} 70% 45% / 0.15)`,\n };\n });\n\n // Optional trend: moving average of the total (sum of assets) in delta mode.\n let trendDataset: Record | null = null;\n if (mode === \"delta\" && trendWindow > 1) {\n const totals = dates.map((_, i) => {\n let sum = 0;\n let hasAny = false;\n for (const ds of assetDatasets) {\n const v = (ds.data as Array)[i];\n if (typeof v === \"number\" && Number.isFinite(v)) {\n sum += v;\n hasAny = true;\n }\n }\n return hasAny ? sum : null;\n });\n trendDataset = {\n label: `${trendWindow}-day avg (total)`,\n data: movingAverage(totals, trendWindow),\n borderWidth: 2,\n pointRadius: 0,\n borderDash: [6, 6],\n tension: 0.15,\n borderColor: \"hsl(0 0% 20%)\",\n backgroundColor: \"transparent\",\n };\n }\n\n const datasets = trendDataset ? [...assetDatasets, trendDataset] : assetDatasets;\n\n const payload = { repo: REPO, tag, latestDate, dates, datasets };\n if (format === \"json\") {\n return new Response(JSON.stringify(payload, null, 2), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n return new Response(\n `\n \n \n \n \n ${htmlEscape(REPO)} – ${htmlEscape(tag)}\n \n \n \n \n

Capacitor release stats

\n All tags\n Stars\n

Repo: ${htmlEscape(REPO)} · Tag: ${htmlEscape(tag)} · Latest snapshot: ${htmlEscape(latestDate)}

\n Downloads\n Cumulative\n Daily delta\n trend:\n off ·\n 7d ·\n 14d\n \n format:\n html ·\n json\n \n

\n \n \n `,\n { headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n // Default view: latest totals per tag (sum across assets) on the latest snapshot date.\n const totals = (await sql`\n SELECT tag, SUM(download_count) AS downloads\n FROM github_release_asset_downloads\n WHERE repo = ${REPO} AND snapshot_date = ${latestDate}\n GROUP BY tag\n ORDER BY tag ASC;\n `) as TotalsRow[];\n\n const payload = {\n repo: REPO,\n latestDate,\n totals,\n tags: totals.map((t) => t.tag),\n downloads: totals.map((t) => t.downloads),\n };\n\n if (format === \"json\") {\n return new Response(JSON.stringify(payload, null, 2), {\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n }\n\n const links = totals\n .map((t) => {\n const href = hrefWith({ tag: t.tag, metric: \"downloads\", format: \"html\" });\n return `${htmlEscape(t.tag)}`;\n })\n .join(\" · \");\n\n return new Response(\n `\n \n \n \n \n Capacitor release stats\n \n \n \n \n

Capacitor release stats

\n Downloads\n Stars\n

Repo: ${htmlEscape(REPO)} · Latest snapshot: ${htmlEscape(latestDate)}

\n Cumulative\n Daily delta\n trend:\n off ·\n 7d ·\n 14d\n \n format:\n html ·\n json\n \n

Click a tag for per-asset time series:

${links}

\n \n \n `,\n { headers: { \"content-type\": \"text/html; charset=utf-8\" } },\n );\n}\n\n\n","deleted","label",[99],"permalink","https://www.val.town/x/laszlocph/capacitorReleaseStatsChart/code/index.http.ts","extension","actionData","errors"]