gitflarePublicPartly agent-ready50
cf-d1-queues-pulse
Event analytics on Cloudflare D1 and Queues: ingestion API, batched consumer, rollups, live dashboard, load generator, dead-letter view.
- LicenseApache-2.0
- LanguageTypeScript
- Last landed
8a65841Oct 20, 2026
Build the full D1 + Queues pulse app: dashboard, load generator, dead letters, percentiles, docs
8a65841import * as Q from "./lib/sql";import { fillMinutes } from "./lib/series";import { percentile } from "./lib/percentile";import type { Env } from "./env"; export async function stats(url: URL, env: Env) { const w = Math.min(Math.max(parseInt(url.searchParams.get("window") ?? "60", 10) || 60, 1), 1440); const now = Date.now(); const end = Math.floor(now / 60000); const from = end - w + 1; type Row = { minute: number; count: number }; const [series, types, paths, countries, samples, batches, newest, h24s] = await Promise.all([ env.DB.prepare(Q.STATS_SERIES).bind(from).all<Row>(), env.DB.prepare(Q.STATS_TYPES).bind(from).all(), env.DB.prepare(Q.STATS_PATHS).bind(from).all(), env.DB.prepare(Q.STATS_COUNTRIES).bind(from).all(), env.DB.prepare(Q.STATS_SAMPLES).bind(from).all<{ value: number }>(), env.DB.prepare(Q.STATS_BATCHES).first<{ n: number }>(), env.DB.prepare(Q.STATS_NEWEST).first<{ m: number | null }>(), env.DB.prepare(Q.STATS_SERIES).bind(end - 1439).all<Row>(), ]); const filled = fillMinutes(series.results, end, w); const sum = (n: number) => filled.slice(-n).reduce((a, r) => a + r.count, 0); const vals = samples.results.map((r) => r.value); const m = newest?.m ?? null; return { totals: { m5: sum(5), h1: sum(60), h24: h24s.results.reduce((a, r) => a + r.count, 0), window: sum(w) }, series: filled, types: types.results, paths: paths.results, countries: countries.results, percentiles: { p50: percentile(vals, 50), p95: percentile(vals, 95), samples: vals.length }, consumerLag: m === null ? null : Math.max(0, now - m * 60000), batches: batches?.n ?? 0, };}