Designing an Expiring-Points System on an RDBMS (with Benchmarks)
A battle-tested relational design for airline-mile-style points that expire per grant, support exact cancellation, and satisfy accounting audits — plus real PostgreSQL benchmarks and a scalability analysis.