Implement a sliding window rate limiter using Postgres as the shared counter store.
This solution would:
- Use Postgres upserts to maintain shared rate limit counters (leveraging existing Postgres infrastructure)
- Implement a sliding window algorithm to prevent 2× burst across fixed window boundaries
- Support multi-instance deployments with consistent rate limits
- Avoid adding a new dependency (Redis) to the infrastructure
Related to: #79
Implement a sliding window rate limiter using Postgres as the shared counter store.
This solution would:
Related to: #79