full-stack // project
PgPulse
## what I built
- 01
Production-grade, multi-tenant API analytics platform built on PostgreSQL 16 for tracking endpoint performance.
- 02
Ingests API request events per tenant and provides overview, endpoint, latency, error, and timeseries analytics — all isolated via Row-Level Security.
- 03
Scales with RANGE partitioning, a streaming read replica, PgBouncer connection pooling, and a materialized view refreshed by pg_cron.
- 04
Includes an in-database alert system that evaluates threshold rules every minute and delivers webhooks on breach.