I made the database compute everything: building an SLA-credit system of record on Aurora PostgreSQL + Vercel

Short summary

A principal product manager built Attest, an SLA credit system designed to prove calculations rather than estimate them. The key insight: move all computation to PostgreSQL using range and multirange types to subtract maintenance windows from incident impact windows, making the entire derivation auditable and exact. A single judgment call about excluding maintenance can swing credits thousands of dollars due to tier-boundary cascades.

• •Core pattern: move all business logic to the database, not application code, to achieve verifiable proofs instead of estimates
• •Technical depth: PostgreSQL range/multirange types elegantly model time intervals and handle set subtraction in a single operator
• •Business insight: architecture decisions (where the math lives) directly determine defensibility and customer trust

Generated with AI, which can make mistakes.