This is an English rewrite of an article I originally published in Japanese. I've run the design on PostgreSQL 17 in Docker and folded the measured numbers into this post. TL;DR Designing a points system where each grant expires on its own date (think airline miles, not "12 months since last ac...

Source: [Dev.to](https://dev.to/matsubo/designing-an-expiring-points-system-on-an-rdbms-with-benchmarks-5hk1)

Sponsored