navyfragen-feed/src/db/ at main · karanshukla.ca/navyfragen-feed · Tangled

karanshukla.ca / navyfragen-feed

0

[READ-ONLY] Mirror of https://github.com/karanshukla/navyfragen-feed. Feed for the app Navyfragen.app (forked from feed starter pack) navyfragen.app

0

navyfragen-feed / src / db /

at main 3 files

Claude Further reduce memory footprint 4w ago

Further reduce memory footprint - SQLite mmap_size: 128MB → 16MB (right-sized for a small feed) - SQLite cache_size: 2MB → 1MB page cache - Remove temp_store = MEMORY (no complex queries that need temp tables) - Move allowlist middleware first, before compression/helmet, so blocked requests incur zero middleware overhead - Log heap and RSS every 5 min for ongoing visibility Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_01KjkbxoF9RZJBab1XvLTWNj

4 weeks ago

Reduce memory footprint: Jetstream, retention pruning, cache limits - Switch firehose to Jetstream (wss://jetstream.bsky.network) — JSON events, no CBOR/CAR parsing, filtered to app.bsky.feed.post only - Add JetstreamSubscription class (src/jetstream.ts) replacing the old xrpc-server Subscription; cursor persisted as microsecond timestamps - Add configurable FEEDGEN_RETENTION_DAYS (default 30) wired through Config, FirehoseSubscription, JetstreamSubscription, and backfill - Add FeedGenerator.pruneOldPosts() with daily scheduling and VACUUM - Reduce feed cache TTL from 5 min to 2 min; cap cache at 100 entries - Set NODE_OPTIONS=--max-old-space-size=256 in Dockerfile and scripts - Add ws + @types/ws as explicit dependencies Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_01KjkbxoF9RZJBab1XvLTWNj

4 weeks ago

simplify db schema + pagination (#94)

2 years ago