at main
5 folders
7 files
Reduce CPU usage: feed cache, DB index, tighter rate limits, expanded WAF
- Add 30s in-memory feed cache in navyfragen algo; invalidated immediately when
new posts are written via firehose, so feed freshness is unaffected
- Add DB migration 002 creating an index on post(indexedAt) to speed up the
ORDER BY query on every feed request
- Expand WAF blocklist from 7 to 24 patterns covering common scanner paths
(actuator, admin, cgi-bin, phpmyadmin, telescope, solr, etc.) — blocks
before rate-limit tracking to reduce overhead
- Halve global IP rate limit (100→50 per 15 min) and tighten slow-down
threshold (50→20 requests before adding delay)
- Add Cache-Control: public, max-age=30 on feed skeleton responses and
max-age=3600 on /.well-known/did.json so any upstream caching layer can
absorb repeat hits
- Remove console.log from the firehose hot path (fired on every matching post)
https://claude.ai/code/session_01D7FNEpSCcAhCdUqreSueTi