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 type { RollupRow } from "./aggregate"; export const UPSERT_ROLLUP = "INSERT INTO rollup_minute(minute,type,path,country,count,sum) VALUES(?,?,?,?,?,?) " + "ON CONFLICT(minute,type,path,country) DO UPDATE SET count = count + excluded.count, sum = sum + excluded.sum"; export function upsertParams(r: RollupRow): unknown[] { return [r.minute, r.type, r.path, r.country, r.count, r.sum];}export const STATS_SERIES = "SELECT minute, SUM(count) AS count FROM rollup_minute WHERE minute >= ? GROUP BY minute ORDER BY minute";export const STATS_TYPES = "SELECT type AS key, SUM(count) AS count FROM rollup_minute WHERE minute >= ? GROUP BY type ORDER BY count DESC LIMIT 10";export const INSERT_DEAD = "INSERT INTO dead_letters(body,error,attempts,at) VALUES(?,?,?,?)";export const INSERT_STAT = "INSERT INTO consumer_stats(batch_at,size,ms) VALUES(?,?,?)";export const PURGE_OLD = "DELETE FROM rollup_minute WHERE minute < ?";export const STATS_PATHS = "SELECT path AS key, SUM(count) AS count FROM rollup_minute WHERE minute >= ? GROUP BY path ORDER BY count DESC LIMIT 10";export const STATS_COUNTRIES = "SELECT country AS key, SUM(count) AS count FROM rollup_minute WHERE minute >= ? GROUP BY country ORDER BY count DESC LIMIT 20";export const STATS_SAMPLES = "SELECT value FROM value_samples WHERE minute >= ?";export const STATS_BATCHES = "SELECT COUNT(*) AS n FROM consumer_stats";export const STATS_NEWEST = "SELECT MAX(minute) AS m FROM rollup_minute";export const INSERT_SAMPLE = "INSERT INTO value_samples(minute,value) VALUES(?,?)";export const PURGE_SAMPLES = "DELETE FROM value_samples WHERE minute < ?";export const PURGE_STATS = "DELETE FROM consumer_stats WHERE batch_at < ?";export const DLQ_LIST = "SELECT id, body, error, attempts, at FROM dead_letters ORDER BY id DESC LIMIT 200";export const DLQ_ONE = "SELECT id, body FROM dead_letters WHERE id = ?";export const DLQ_ALL = "SELECT id, body FROM dead_letters ORDER BY id LIMIT 100";export const DLQ_DELETE_ONE = "DELETE FROM dead_letters WHERE id = ?";export const DLQ_DELETE_ALL = "DELETE FROM dead_letters";